Page 1 of 1

wfsave or pagesave

Posted: Mon Oct 30, 2017 9:38 am
by pgrign
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.

Re: wfsave or pagesave

Posted: Mon Oct 30, 2017 9:45 am
by EViews Gareth
No.