Need VBA assistance for Open Dialogue Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brent E - 07 Feb 2005 18:23 GMT

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,

Reply to this Message

Roger Carlson - 07 Feb 2005 19:05 GMT

Check out this link and look at the first sample:
http://www.mvps.org/access/api/index.html

Signature

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> Good morning.
>
[quoted text clipped - 5 lines]
>
> Cordially,

Reply to this Message