Need VBA assistance for Excel Open Dialogue Box
 

Good morning.

I need to figure out code that will simply change current directory to a set
directory and then show Excel's "Open" Diaglogue box. I am aware that I can
use an open command to open a certain file, but I don't want to do that,
just Excel's Open dialogue box. Any suggestions? Thanks

Cordially,

Need VBA assistance for Excel Open Dialogue Box
 

sPath = "C:\MyFolder"
chdrive sPath
chdir sPath
application.Dialogs(xlDialogOpen).Show


also look in excel vba help at Application.GetOpenfileName

--
Regards,
Tom Ogilvy



"Brent E" wrote in message
...
Good morning.

I need to figure out code that will simply change current directory to a
set
directory and then show Excel's "Open" Diaglogue box. I am aware that I
can
use an open command to open a certain file, but I don't want to do that,
just Excel's Open dialogue box. Any suggestions? Thanks

Cordially,

Need VBA assistance for Excel Open Dialogue Box
 

Really cool. Thanks Tom.

"Tom Ogilvy" wrote:

sPath = "C:\MyFolder"
chdrive sPath
chdir sPath
application.Dialogs(xlDialogOpen).Show


also look in excel vba help at Application.GetOpenfileName

--
Regards,
Tom Ogilvy



"Brent E" wrote in message
...
Good morning.

I need to figure out code that will simply change current directory to a
set
directory and then show Excel's "Open" Diaglogue box. I am aware that I
can
use an open command to open a certain file, but I don't want to do that,
just Excel's Open dialogue box. Any suggestions? Thanks

Cordially,