Saving workfile as workbook (containing specific groups)

[fboehlandt]

Hi everyone,

I am struggling a little with the syntax of saving a workfile as a .xlsm (or .xls) file:

I have a workfile with five groups called group01, group02, ...

I would like to save a workbook that contains the groups only (there are other series in the workfile). Ideally, I would like to have one group per worksheet. That probably won't work so I would like to have one workbook per group. Lastly, assume that the target directory is something like C:\afolder\

Thanks in advance for your input

Regards

Florian

[EViews Gareth]

Just use:

Code: Select all

wfsave myfile1.xls @keep group01 wfsave myfile2.xls @keep group02

etc...

[fboehlandt]

Okay, great. Thanks. I assume it's always the workfile that is currently open/active. Is there a way to specifiy a target destination instead of saving it to documents?

[EViews Gareth]

Yes, it is the current workfile.

Code: Select all

wfsave c:\myfolder\myfile.xls

[fboehlandt]

Thx, I thought as much. for some reason it doesn't like the desktop as destination but saving it to C: works just fine. great stuff!

[EViews Gareth]

As usual, if there are spaces in the directory path, you'll need to surround it in quotes:

Code: Select all

wfsave "c:\my documents\myfile.xls"