computer name find

[Craig Wilks]

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

 

[Norman Jones]

Hi Craig,

Try:

MsgBox Environ("ComputerName")

 

[Craig Wilks]

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

Craig Wilks

 

[Norman Jones]

Hi Craig,

"Computer Name"

should be:

"ComputerName"

(without the space), as in my post.

 

[Colo]

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