Try

ComputerName = environ("ComputerName")


It is one of the environmental parameters which you can see by opening
a DOS window and typing SET at the prompt


Start - Run
type CMD.EXE
at dos prompt type SET

From Vista
Start - Search - CMD.EXE
at dos prompt type SET

Each of the variables in that are returned can be obtained using the
environmental command in VBA,


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160666

Microsoft Office Help