Directories
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
|