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

I found it:

Application.DefaultFilePath = "c:\mypath"


-----Original Message-----
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
.

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

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

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
I found it:

Application.DefaultFilePath = "c:\mypath"


-----Original Message-----
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
.