how to let the user to set the save path?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dong Gaofeng - 06 Jan 2006 04:10 GMT

in Access ,I need to export some data to An Excel file
now,the path is constant
I wanna to let the user to choose the path via dialog form
How can I realize it?

Reply to this Message

Allen Browne - 06 Jan 2006 04:14 GMT

The code in this link fires up the Windows File Save dialog:
http://www.mvps.org/access/api/api0001.htm

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> in Access ,I need to export some data to An Excel file
> now,the path is constant
> I wanna to let the user to choose the path via dialog form
> How can I realize it?

Reply to this Message