[Ric Payne]

Is there an easy way to obtain the full path for a file from an File
Open Dialog Box?
Thank you in advance.
Ric Payne

[Rob Bovey]

"Ric Payne" wrote in message
om...
Is there an easy way to obtain the full path for a file from an File
Open Dialog Box?

Hi Ric,

I'm not sure exactly what you're asking. When you use the
Application.GetOpenFilename method to prompt the user to select a file, it
returns the full path and filename of whatever file the user selects. If
this isn't what you're looking for, can you be a bit more specific?

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

[Rob Bovey]

Hi Ric,

If the user uses the built-in File/Open dialog to open a file, the
current directory is automatically changed to the path the file was opened
from. If you want to see what that directory is, you can get the full path
and file name for any previously saved workbook using:

Workbooks("MyBook.xls").Path

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Ric Payne" wrote in message
...
Thank you for your response Rob.
What I want is to be able to identify the full path name when a user
opens a file using the File Open Dialog box and browses to a different
folder to the one that is currently being used. That will enable me to
set the new path as the default for the file that is being worked on.
Any help you can give me would be appreciated.
Ric Payne



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ric Payne]

Thank you again Rob.
Because I am only opening the file to get some data then closing it
again i wanted to capture the path so that when i subsequently saved
it i would go to the directory from which i originally got it and that
directory may not be the default directory which contains other data
files.
I figured that one way to do that was immediately after using the file
open or save dialog to cath the path as follows

NameOfPath=Left(FileName,InStrRev(FileName,"\"))

Where FileName is the name of the xls file that i opened.

That strips out the file name and leaves me with the path. Do you see
any problems with this?

"Rob Bovey" wrote in message ...
Hi Ric,

If the user uses the built-in File/Open dialog to open a file, the
current directory is automatically changed to the path the file was opened
from. If you want to see what that directory is, you can get the full path
and file name for any previously saved workbook using:

Workbooks("MyBook.xls").Path

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Ric Payne" wrote in message
...
Thank you for your response Rob.
What I want is to be able to identify the full path name when a user
opens a file using the File Open Dialog box and browses to a different
folder to the one that is currently being used. That will enable me to
set the new path as the default for the file that is being worked on.
Any help you can give me would be appreciated.
Ric Payne



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!