Need VBA assistance for Open Dialoge Box

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VBA assistance for Open Dialogue Box 1
Need VBA assistance for Excel Open Dialogue Box 2
Need VBA code for "Open Dialogue" box 2
Need VBA assistance for Excel Open Dialogue box 2
I need to use VBA to set directory 1
Need to find out VBA command that runs "Open" file dialogue box 1
I need VBA Assistance to test for instances 2
I need VBA assistance to set a directory in Access module 2

Top