I would like for my script to have an option to choose to export to 1 excel file with multiple sheets or to multiple excel files.
(For the export I would still like to copy from an existing file since we will make this a template containing a header with our office logo etc…)
I know I have to search for string and do an if/condition but I don’t know how to continue with the different export options…
A should be export to 1 file, B export to multiple files
(I also still need to fix the sheetnames to the schedulenames and also the filenames to the schedulenames… Any suggestions on how to do this in a ‘clean’ way are welcome)
Also the excel-file always opens automatically after export… Is there a way to turn this off?
Multiple Schedules to excel.dyn (121.3 KB)