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. 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
"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,

see your other post.
-----Original 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,
.