Saving group to excel file

[moll]

Im trying to save a group to an excel file inside of a loop. programmatically, it is not allowing me to save to a file at all. my inner loop looks something like this:

Code: Select all

import(mode=o) my_file.xlsx range=Sheet1 colhead=1 na="#N/A" @id @date(ds) @smpl @all
group g *
for !i=1 to g.@count
%name = g.@seriesname(!i)
series {%name}_new = {%name}*100
next
group g_new *_new

wfsave (type=excelxml) B:\test_file.xlsx @keep g_new


i get the error:
Unable to open file C:\(type=excelxml).wf1.
My workfile is not even located in my C drive...

i have tried using the pagesave function as well but to no avail. i can save manually through the drop downs, but that doesnt work for my use case.

any help is greatly appreciated!

[EViews Gareth]

You have a space between the wfsave command and its options.

[moll]

wow.. silly mistake... thanks!