Excel Report and VBA
Hello!
We built a new Excel file with some macro instruction using VBA.
We would like to create a new file each time a value changes.
No problem in the scheduling structure:
- schedule with an expression in the scheduling definition aspect
- link to our report template xls file in the action aspect
But how can we keep the last file created? An empty one is made each time and we want to have an incrementation in the new file (export paths...?)
Hope is it clear...
Thank you very much in advance!
Regards
Answers
I guess you will have to write some macro/VBA code that append the results to an external file and let the regular result be just a log of the last triggering/execution.
To solve my problem, do you know if it is possible just to launch a file (my excel file for example) with the scheduling structure directly? In the job action aspect I can not execute a file, just make a report.
Tank you
Add new comment