How Do (or can I) Bring Up Dialog Box to Specify Output Directory?

M

mcl

I'm outputting 13 queries as csv which works fine but to the default
directory for MS Access. I know I can "hardwire" a specific directory for
each but can I lead things off with a dialog box which selects the output
directory and then uses that for all 13?
 

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

Macro Code for bringing up Save As dialog box and changing file Type 0
How do I set focus (and select text) on a text box on a modeless userform? 0
How to Specify Output Directory for Macro ? 2
How to disable the outputting report to PDF dialog box 0
NEWBIE Needs To Import All Records From A Folder 1
specify default path in dialog open box 1
save dialog box and open dialog box 1
save dialog box and open dialog box 1

Top