To All:

Thank you for all of your input. I have been scrambling lately so I haven't
had time to try to implement this. If anyone has, I know we would all love to
hear the results. This would be a great security feature for developers and
companies alike. I hope to have time this weekend to sit down and try all of
these wonderful suggestions.

Thanks Again

Frank Pytel
"urkec" wrote:


"Javier Amian" wrote:

I think it is much easier than what you guys are doing...

I would do the following:

1.- Get the MAC address of the router or server in your network and save
it to check against.
2.- Run a Shell in your VBA with like this:

Shell("cmd /c arp -a c:\localarp.txt", 1)

this will create a file with the entries of the ARP table in the local
machine. The router or the server MAC address for the network were your
script is run will definitely be in this file.
3.- Search the file for the MAC address you saved in step 1.

Alternatively, I would hide another file in some shared drive in the
office network and have your script check if it exists.
Chances are if someone took the script home, this file will not be
found...

Njoy



I think it can be done that way too, but using ipconfig /all is probably
better because you can use it with standalone computers. I am no expert in
this, I was just interested in comparing different methods of getting MAC.
Maybe some other value could also be used for protecting workbooks, operating
system serial number or something else.

--
urkec