Need VBA assistance for Excel Open Dialogue Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
sPath = "C:\MyFolder"
chdrive sPath
chdir sPath
application.Dialogs(xlDialogOpen).Show


also look in excel vba help at Application.GetOpenfileName
 
Really cool. Thanks Tom.

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


also look in excel vba help at Application.GetOpenfileName
Click to expand...
 
Back
Top