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. I
want a dialogue box and not a file. Any suggestions? Thanks

Cordially,
 
Perhaps:

ChDir "c:\test\"
Application.Dialogs(xlDialogOpen).Show

--
Jim Rech
Excel MVP
| 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. I
| want a dialogue box and not a file. Any suggestions? Thanks
|
| Cordially,
 
Back
Top