hi,
i think it is:
Application.Dialogs(xlDialogOpen).Show
-----Original Message-----
Good morning.
I am using an Access VBA module to control Excel and I
need to figure out
code that can 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 dialogue box and
not specify a file. Any suggestions? Thanks
Cordially,
.
|