Get MAC Address - Windows API
Here is a link to an article that contains Windows API code for getting the MAC address of the computer. I haven't tried the code out in VBA but it's a nice piece of code to keep.
http://www.osix.net/modules/article/?id=2