Select drive to export file to

[Randy]

Access 2000. I am trying to find info on how to select a drive to export an
excel file created from a query. I need to be able to select any drive
using a cmd button to bring up the available drives, select the drive such
as Flash stick or floppy drive and then export the file to the selected
drive. I know you use the open dialog function somehow, but I dont know
how. Can anyone help me here. Thanks.

 

[Kipp Woodard]

Using this information, you can configure it to only display folders, vs
folders and files:

http://www.mvps.org/access/api/api0001.htm