Mansoor Ahmad
Registered User.
- Local time
- Today, 23:43
- Joined
- Jan 20, 2003
- Messages
- 140
Hello All
In my database I want certain data to be exported to excel spreadsheet. That spreadsheet is then further linked to another excel file. So basically each time when the query is run new set of data updates in to the linked sheet.
I want to use macro for this purpose. I have tried 'OutputTo' action in macros. It does export the data into specified excel file but when I run the macro 2nd time, it prompts that the excel sheet mentioned in output file argument already exist, do you want to replace it. If I click on yes, obviously it delects the file and if I have saved the linked sheet in the same excel spreadsheet, that would delete as well.
Is there a way that this macro only updates new data without deleting the destination file?
In my database I want certain data to be exported to excel spreadsheet. That spreadsheet is then further linked to another excel file. So basically each time when the query is run new set of data updates in to the linked sheet.
I want to use macro for this purpose. I have tried 'OutputTo' action in macros. It does export the data into specified excel file but when I run the macro 2nd time, it prompts that the excel sheet mentioned in output file argument already exist, do you want to replace it. If I click on yes, obviously it delects the file and if I have saved the linked sheet in the same excel spreadsheet, that would delete as well.
Is there a way that this macro only updates new data without deleting the destination file?