Michael Katz
asked on
ODBC driven Excel report to Static Data Excel Report.
Good evening,
I have an Excel report that when 'Refresh All' is clicked it runs and updates accordingly.. What I would like to happen is that after the excel spreadsheet is updated that it automatically creates a Static version of the report in the same drive but with a timestamp and does not have the ODBC connection.. How can this be accomplished using Task Scheduler so that it happens automatically?? Loaded question but it is fairly important
I have an Excel report that when 'Refresh All' is clicked it runs and updates accordingly.. What I would like to happen is that after the excel spreadsheet is updated that it automatically creates a Static version of the report in the same drive but with a timestamp and does not have the ODBC connection.. How can this be accomplished using Task Scheduler so that it happens automatically?? Loaded question but it is fairly important
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've requested that this question be closed as follows:
Accepted answer: 500 points for strive4peace's comment #a41261311
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 500 points for strive4peace's comment #a41261311
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Open in new window
assumption is that what you want to copy is the active sheet when this is runif so, then we can discuss scheduling it