Export data to existing excel file

[johansamuelsson]

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

[EViews Gareth]

It is extremely high up our list.

[johansamuelsson]

Great!

[johansamuelsson]

It is extremely high up our list.

What about this issue?

[EViews Gareth]

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

[paues]

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

[EViews Gareth]

8

[victor.alves]

Is that already possible on Eviews 8 Beta?

Thanks

[EViews Gareth]

Yes

[davey87]

Using EViews 8 Beta, I am trying to export data from a workfile to an exisiting Excel file using the following commands:

Code: Select all

for %a 0to4 5to9 10to14 15to19 20to24 25to29 30to34 35to39 40to44 45to49 50to54 55to59 60to64 65to69 70to74 75to79 80to84 85to89 90plus
wfsave(type=excelxml, mode=update) range="Sheet1!d54" byrow popm.xlsm @keep p{%a}mz1m
next

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?

[EViews Gareth]

Excel file name goes before the Range= statement.

[davey87]

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:

Code: Select all

wfsave(type=excelxml, mode=update) range=”Sheet2!a1” byrow
macro.xlsm @keep gdp unemp

[EViews Gareth]

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

[paues]

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?