Open File

K

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
 
J

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
 
T

Tom Ogilvy

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