is there a way how to read windows serial number programmatically in VBA from Excel?
I know you can do it with VB script by challenging the WMI (Windows Management Information) and using that to read the registry, however I don't think it can be done with VBA. I don't believe that VBA has the right commands to do this - though there's a good chance I'm wrong.
If you are an admin on that PC and you want lots of information, or if you're wanting to learn VB code, try googling for the "SYDI Project". The very nice man that wrote it has his code available if you want to work out how it works.