Excel Report and VBA
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!