DoCmd.OutputTo

J

Jeff

Hello,

I am exporting a Query to Excel using DoCmd.OutputTo.

When using DoCmd.OutputTo it brings up a Windows Dialog Box where the User
can select a Path & File Name to Save file too.

After this, is their a way to know what Path & File Name the User selected ?

I know how to default the File Name & Path & I know I can use API Windows
Dialog box to do this process, but still I was wondering just using
DoCmd.OutputTo, to know what Path & File Name the User selected ?

Any help would be greatly appreciated.

Thank you,
Jeff
 

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

How can I save directly into the same folder every time in Office 365 / Windows 10? 0
Incorporating the User Profile location into a document template path 1
Error outlook.com 0xc0000005 trying to open custom controls 0
export to xls 2
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Outlook Backup issues 0
Name of file opened, being viewed 2
VBA - exporting serial letters to single documents 0

Top