Use the environmental varible UserProfile
Folder = environ("APPData")
This will return the following without a slash at the end.
C:\Documents and Settings\joel\Application Data
So you would want to do this
FName = Folder & "\book1.xla"
To get a list of all the environmental variables do the following
Start - Run
Enter : cmd.exe
In Dos Window type : Set
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=167046
Microsoft Office Help