Ed,
?Environ("UserName")

NickHK

"Ed Davis"
...
The path is always the same except for the user profile.

Example :
C:\Documents and settings\store2113\my documents\dailywork\Ugrounds.xls


The "store2113" is the only thing that is different.

Is there a way to have the macro open the file using
"C:\Documents and settings\%user profile%\My
Documents\Dailywwork\ugrounds.xls"?




"NickHK" wrote in message
...
Ed,
If you do not know what the path is, get the user to locate it first.
See:
Application.GetOpenFilename

NickHK

"Ed Davis" wrote in message
...
I am trying to open a file that I have saved. I am having the following
problem.

Sometimes it will open but other times I have to change the path.

The problem I have is that because I distribute the main file to several
people the exact path is different because of the user profile.


Workbooks.Open Filename:= _
"Ugrounds.xls"

Is there a way to stop the debugger from coming up and changing the
path?

Thanks in advance.

Ed Davis