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