EViews.com

Hi Steve,

The Wfsave funtion exports dates in the dd/mm/yyyy format. Is there a way to change this to yyyyqq format?

Thanks.

Thanks Steve. This worked: wfsave(type=excel, mode=update) tracking.xls range=weights!a2 @keep wt_gmfm_us_t @smpl 2014Q3 2017Q2

Can you give me an example? I tried the following but E-views dosen't like it:

wfsave(type=excel, mode=update) tracking.xls range=weights!a2 @keep @smpl 2014Q3 2017Q2 wt_gmfm_us_t

Thanks.

Thanks Steve. When one uses the Wfsave function it seems to dump all values in a series. However, I only want to dump non-NA values in the series into excel. For instance, the following code would dump the entire series including all the NAs. Is there something I can do about it? May be assign a sam...

Another question - I'm trying to use wfsave to save data in different tabs of an excel spreadsheet. But I can't seem to do that in one go. Instead e-views will close the excel file and open it again every time which takes a lot of time. Is there a way around this? Thanks so much. Using the following...

Figured out what the problem was. My path was pointing to the wrong folder. Sorry for the trouble.

Still no luck. However, seems to work for my colleague here. Even the write function is not working for me. So strange.

No I don't have the file open. Also, I have a feeling that the "write" command is now obsolete. Is that true? If yes, what do you suggest we use?

I tried the following code. It didn't populate anything.

wfsave(type=excel, mode=update) test.xls range="Sheet1!a1" byrow @keep au_gdpr

Thanks.

Is there a way to export data from E-views workfile to an existing excel spreadsheet?

Thanks.

I want to run loops in commands that use quotations but am unable to do so. For example, if I try to use a loop to assign various dates in the command below, it would give me an error message.

scalar us_2014Q3 = @elem(us_dlgdpr_0n2014Q3, "08/28/2014 ")

Please help.

Thanks.

Updated to September 2015 version but still no luck.

Aug 18 2015

Using E-views 8.1 at the moment. Have put in an order for E-views 9 so should be getting it soon.

Wondering why I am getting the "Match merge is only available when copying between workfile pages" when I run: copy {%y} judgement weights::daily\{%y} Full code is this: wfopen (wf=%name, page can) "C:\file.xlsx" string orig_name = @wlookup("q*") for %x {orig_name} %y =...