EViews.com

Hi

At our institute (NIER, http://www.konj.se) we are now changing from Aremos to Eviews for calculations of macroeconomic forecasts. Very often we combine heavier computation with excel files that sometimes are a better interface. We have therefore a great need to export data to existing excel files.

As we have noted previously it works fine to load data into existing excel file via VBA. But it requires a relatively good knowledge of VBA coding.

As an alternative, it would be highly desirable to be able to export data directly from a workfile to an existing Excel file via code in Eviews.

Are there any plans for this? Thanks in advance.

Johan

It is extremely high up our list.

Great!

It is extremely high up our list.

What about this issue?

It is still extremely high on our list, and should be implemented in the next version of EViews.

Do you by "next version" mean EViews 7.3 or EViews 8?

8

Is that already possible on Eviews 8 Beta?

Thanks

Yes

Using EViews 8 Beta, I am trying to export data from a workfile to an exisiting Excel file using the following commands:
However when I run it I am getting an Error Message that says:

Syntax error: unexpected character '.' in file option settings in "WFSAVE(TYPE=EXCELXML, MODE=UPDATE) RANGE="SHEET1!D54" BYROW POPM.XLSM @KEEP P0TO4MZ1M"

Any idea why this may be happening?

Excel file name goes before the Range= statement.

Ok thanks. But just so you guys are aware, in the EViews 8 Beta Documentation examples under "wfsave", it is the other way around. The example is provided like this:

Yep, that's a mistake. I'll make sure it gets fixed.

Please note that the example provided by davey87 was not updated in the documentation that comes with EViews 8. Is it possible for you to update it in when you release patches?