By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Save filepath when using create object macro

P: 5
Windows XP
Access 2003

G'Day

I am using the built in create object macro to save a query to file in an excel format. I have left the "Output File" field blank so that the user can specify where to save the file.

Is there a way to save the filepath selected by the user in the save object dialog box so it can be used later on in my code?

Thanks

Mike D
Sep 10 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
Windows XP
Access 2003

G'Day

I am using the built in create object macro to save a query to file in an excel format. I have left the "Output File" field blank so that the user can specify where to save the file.

Is there a way to save the filepath selected by the user in the save object dialog box so it can be used later on in my code?

Thanks

Mike D

Not in that way. What you can do is use a common dialog box to capture a path and or filename prior to executing the command, and passing it into the command as a variable.
You can then do anything you want with the variable.

This link describes the Common Dialog use. Let us know if you have any problems
http://support.microsoft.com/default...;en-us;q303066
J
Sep 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.