Browse for directory (not file)

G

grossman

I'm creating export functionality. The names of the exported files are set. I
do, however, want the user to specify the directory where the file should be
saved. How do I create a control that will allow the user to select only the
directory where the file should be saved?

BTW...I'm an Access novice.

Thanks!
 
M

Marshall Barton

grossman said:
I'm creating export functionality. The names of the exported files are set. I
do, however, want the user to specify the directory where the file should be
saved. How do I create a control that will allow the user to select only the
directory where the file should be saved?
Click to expand...


This may be rather intimidating, but it's so well tested
that you can just Copy/Paste into a new Standard module and
use it as the example shows.
http://www.mvps.org/access/api/api0002.htm
 
Top