Need VBA assistance for Open Dialoge Box

B

Brent E

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, just Open dialogue box.
Any suggestions? Thanks

Cordially,
 
J

Jon Furman

Brent,

If you're on a more recent version of Office you could try the
FileDialog object that's in the Office object library. That's how I've been
doing it for the past few years. Before that I remember that you could do a
Windows. API call to get the file open dialog.

Hope this helps.

Jon
 
Top