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.
wfsave or pagesave
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13305
- Joined: Tue Sep 16, 2008 5:38 pm
Who is online
Users browsing this forum: No registered users and 33 guests