Get machine name? 1

[scar]

I've hunted around for this but to no avail.
Please could someone tell me how I get at the name of the PC within VB. i.e the machine name. I want the program to behave differently if it's working on my own PC rather than the end-users'.
Many thanks

 

[jrbarnett]

There is an excellent FAQ on obtaining machine and logon names:

http://www.tek-tips.com/faqs.cfm?spid=181&sfid=3779

John

 

[scar]

Thanks - works perfectly

 

[Chattin]

For info as you have your answer. Check out

http://j-walk.com/ss/excel/tips/tip94.htm

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help