Hi, I found some code online some time back that allows me to maintain a list of PC names in Excel 2007, ping the PC to get the IP address and return the value in another column.

Please Login or Register  to view this content.
Now I would like to do the same thing for MAC Addresses and I found code that allows you to retrieve the local MAC address and returns the value in a text box.

Please Login or Register  to view this content.
My ultimate goal is to retrieve the MAC addresses from the list of PC names in column A and return the value in column B. I've tried adjusting the code that gets me the IP addresses of those PC names to replace the ping code with MAC address code instead but I must be doing something wrong because I can't quite get it to work. Hopefully someone can help get me there? Thanks in advance for any help!