Hi all,
I’ve written a pass-through query and an autoexec macro that runs said query and exports it to excel on startup. Is there a way to export the query data to an existing excel file at the bottom of the existing data?
All I’ve been able to find is exporting it to a new file or a new sheet...
The end goal is to write a VBScript to open access and export into excel, then run an excel macro to organize the data how I want all by using task scheduler. The excel macros are written already.
I’ve written a pass-through query and an autoexec macro that runs said query and exports it to excel on startup. Is there a way to export the query data to an existing excel file at the bottom of the existing data?
All I’ve been able to find is exporting it to a new file or a new sheet...
The end goal is to write a VBScript to open access and export into excel, then run an excel macro to organize the data how I want all by using task scheduler. The excel macros are written already.