troubleshooting Question

access macro - can i automate parameter input for multiple transfer spreadsheet export lines in a macro?

Avatar of rustyroo
rustyrooFlag for Australia asked on
Microsoft AccessVB ScriptSQL
2 Comments1 Solution659 ViewsLast Modified:

I have a series of queries that I export to an excel document via a macro that runs multiple transferspreadsheet commands.  All of the queries that it pulls however have a parameter to imput, all are the same parameter with identical name ( it is a date).  Currently I have to input this date for as many times as I have transferspreadsheet commands.  Is there a way to set this parameter as part of the macro whether it be via vba code run or whatever??

Thanks for any advice.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros