Jeff,
Give them an option to select the folder from which to work.
Look into the API BrowseForFolder, or use a control.

Save it path to a worksheet cell, or the registry and look it up each time
it's needed.

NickHK

"Jeff" wrote in message
...
| Hi,
|
| An application i'm developing, needs debugging. It's excel '95. When it
was
| written, the viscual basic code behind a macro, went to look in a specific
| directory on c:\ for the location of files/where to open files
|
| But now, one person could take the application and save it on any drive
AND
| directory - eg, fred saves under h:\mywork\applications\data, whereas mary
| might save to y:\officefiles\current
|
| So now the old chdrive "c:\" with chdir "c:\currentjobs\excel" is no good,
| because dozens of users could save the files on ANYYYY hard drive AND any
| directory = THOUSANDS of possible combinations
|
| How can i change the chdrive AND chdir code so that the application will
| work/open files from fred's or marys or WHOVERS home drive and directory
|
| Thanks in advance
| Jeff
|
|