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