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

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

Jeff,

Easier to use the GetFileNameOpen method (look it up in VBA help). It is
file specific, but it doesn't open the file, but gives access to the explore
type dialog, and returns the full path and name of the file chosen, which
you then open. You could open this file and then get the path for the
others, or parse it to get the path.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Nick HK" wrote in message
...
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
|
|

Nick,

Thanks for your help on this one mate. Fingers crossed it works for me haha

Jeff

"Nick HK" wrote in message
...
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
|
|

G'day Bob,

No wonder I have no hair left - pulled most of it out haha. Many kind thanks
for your advice. I'm afraid excel is new to me - access yes, excel no. I
really come from a COBOL background, so it takes time to learn

Thanks again mate
Jeff

"Bob Phillips" wrote in message
...
Jeff,

Easier to use the GetFileNameOpen method (look it up in VBA help). It is
file specific, but it doesn't open the file, but gives access to the
explore
type dialog, and returns the full path and name of the file chosen, which
you then open. You could open this file and then get the path for the
others, or parse it to get the path.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Nick HK" wrote in message
...
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
|
|