How to get MAC address of client machine using Excel 2000 VBA?

Question

How to get MAC address of client machine using VBA Excel 2000?

Answer 1

You can execute at command prompt on the client machine and then look for the line towards the bottom of screen showing a line like the following:



Physical Address. . . . . . . . . : 00-0X-C7-B8-11-07



Physical Address is the MAC address.

Answer 2

Dos commands can be run directly using "Shell" command.



Try this line in the VBA window



Shell "ipconfig / all" , vbNormalFocus

Then the command will be executed and see what to do

You can also add ">> D:\1.txt" to save the output of the command to a file, then read that file in the VBA.



I used this technique several times in alot of issues and it helped me alot



Enjoy my profile, I am VBAXLMan

Answer 3

From the place did you acquire this administration? what's its call in code? Is it from Fm20.dll controls from which OCX report do you acquire it? Why did you used CommandBars to get entry to it? you are able to desire to get entry to it fro its call SetFocus could desire to artwork on any administration which could settle for concentration and has the valuables to genuine i want you to respond to those questions, touch me by way of Yahoo! and deliver me your handle in case you like me to deliver you the answer. Wao, it incredibly is a deep question study my profile, i'm XLMan