Open File

[Kevin]

When using the GetOpenFileName method, is there a way to
set the directory the Open dialog box will start in? I
will have a default path for all files the user will need
to open.

Thanks!

Kevin

 

[Kevin]

I found it:

Application.DefaultFilePath = "c:\mypath"

 

[Jim Rech]

GetOpenFilename opens to whatever the current path is on the current drive.
So you could use ChDrive and ChDir to set these.

--
Jim Rech
Excel MVP
| When using the GetOpenFileName method, is there a way to
| set the directory the Open dialog box will start in? I
| will have a default path for all files the user will need
| to open.
|
| Thanks!
|
| Kevin

 

[Tom Ogilvy]

Nope, you missed it. This only sets where excel looks when you start it.
See Jim Rech's post.