Perhaps:

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

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