wfsave or pagesave

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

Posts: 11
Joined: Fri Mar 03, 2017 2:59 am

wfsave or pagesave

Postby pgrign » 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.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11908
Joined: Tue Sep 16, 2008 5:38 pm

Re: wfsave or pagesave

Postby EViews Gareth » Mon Oct 30, 2017 9:45 am

Follow us on Twitter @IHSEViews

Return to “Programming”

Who is online

Users browsing this forum: No registered users and 10 guests