Davis,

I have an idea that you have to make a database or setting wich a file
contains data about your clients like: [UserName];[Path]
example:

John;C\DATA\2007\
Edgar;E\SERVERDATA\
etc...

Wich saved in a txt file then you have to initialize to read them before
saving file

--

Regards,

Halim


"Ed Davis" wrote:

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