computer name find
 

I run code on two different computers with two different printer
arrangments. I want to print using the code but need to have the code
ascertain which computer it is running on first. I thought there may be
some code to do this by finding the IP Address or the computer name for
instance.

Craig Wilks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

computer name find
 

Hi Craig,

Try:

MsgBox Environ("ComputerName")

---
Regards,
Norman



"Craig Wilks" wrote in message
...
I run code on two different computers with two different printer
arrangments. I want to print using the code but need to have the code
ascertain which computer it is running on first. I thought there may be
some code to do this by finding the IP Address or the computer name for
instance.

Craig Wilks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

computer name find
 

"Computer Name" does not seem to ring any bells for VB.

Craig Wilks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

computer name find
 

Hi Craig,

"Computer Name"

should be:

"ComputerName"

(without the space), as in my post.


---
Regards,
Norman



"Craig Wilks" wrote in message
...
"Computer Name" does not seem to ring any bells for VB.

Craig Wilks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

computer name find
 

Hi Craig,
Here is a way for getting IP address.
http://puremis.net/excel/code/079.shtm

--
Col

-----------------------------------------------------------------------
Colo's Profile: http://www.excelforum.com/member.php...nfo&userid=322
View this thread: http://www.excelforum.com/showthread.php?threadid=26668