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.