wfsave or pagesave
Posted: Mon Oct 30, 2017 9:38 am
Hi, I have a simple question: is there a way to save an xlsx with wfsave or pagesave on the same workbook but on different sheets without having to write it down multiple times?
So far, I did something like this:
wfsave(type=xlsm, mode=update) "..." range="Sheet1" @keep series1
wfsave(type=xlsm, mode=update) "..." range="Sheet2" @keep series2
wfsave(type=xlsm, mode=update) "..." range="Sheet3" @keep series3
but it takes a lot because it has to open and close the Excel file everytime.
So far, I did something like this:
wfsave(type=xlsm, mode=update) "..." range="Sheet1" @keep series1
wfsave(type=xlsm, mode=update) "..." range="Sheet2" @keep series2
wfsave(type=xlsm, mode=update) "..." range="Sheet3" @keep series3
but it takes a lot because it has to open and close the Excel file everytime.