Page 1 of 1

Saving workfile as workbook (containing specific groups)

Posted: Thu Jul 19, 2012 3:49 am
by 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

Re: Saving workfile as workbook (containing specific groups)

Posted: Thu Jul 19, 2012 7:53 am
by EViews Gareth
Just use:

Code: Select all

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

Re: Saving workfile as workbook (containing specific groups)

Posted: Thu Jul 19, 2012 8:42 am
by 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?

Re: Saving workfile as workbook (containing specific groups)

Posted: Thu Jul 19, 2012 8:43 am
by EViews Gareth
Yes, it is the current workfile.

Code: Select all

wfsave c:\myfolder\myfile.xls

Re: Saving workfile as workbook (containing specific groups)

Posted: Thu Jul 19, 2012 9:06 am
by 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!

Re: Saving workfile as workbook (containing specific groups)

Posted: Thu Jul 19, 2012 9:13 am
by 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"