Exporting after cell IV in Excel

[FCIQ]

Hi !

I am trying to export sevral series that I grouped to the same Excel sheet but there is an error message that tells me that table "quarterly!ME6" does not exist. Is it because eviews cannot export to excel after column IV ?

Here is the code I use. Please let me know how I can export all that series to the same excel sheet

'Exporting quarterly_data to Chronologis_réelles.xlsx
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!B6" @keep PRO_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!AG6" @keep GAT_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!BL6" @keep MTL_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!IP6" @keep QUE_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!ME6" @keep SAG_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!NJ6" @keep SHE_Reelles_Quarterly
pagesave(t=excelxml, mode=update, noid) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="quarterly!OO6" @keep TRS_Reelles_Quarterly

[EViews Gareth]

I cannot replicate what you are seeing. I created a file called "Chronologis_reelles.xlsm" in c:\temp, then ran the following code:

Code: Select all

create q 1990 2000 series pro_reelles_quarterly = rnd series gat_reelles_quarterly = rnd series mtl_reelles_quarterly = rnd series que_reelles_quarterly = rnd series sag_reelles_quarterly = rnd series she_reelles_quarterly = rnd series trs_reelles_quarterly=rnd pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!B6" @keep PRO_Reelles_Quarterly pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!AG6" @keep GAT_Reelles_Quarterly pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!BL6" @keep MTL_Reelles_Quarterly pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!IP6" @keep QUE_Reelles_Quarterly pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!ME6" @keep SAG_Reelles_Quarterly pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!NJ6" @keep SHE_Reelles_Quarterly pagesave(t=excelxml, mode=update, noid) "c:\temp\Chronologis_reelles.xlsm" range="quarterly!OO6" @keep TRS_Reelles_Quarterly

And it worked perfectly.

[FCIQ]

Thanks for the quick reply.

I think my problem is that the group I want to export contains 435 series with monthly observations starting in 2002 that I want to export on the same excel sheet. Here is a little bit more of the code that I have before saving to the excel file:

wfselect actual_data_monthly
'Province
group Reelles_Monthly PRO00VENRES_MR PRO00VENUNI_MR .... (and the all the other series in the group, 435 in total)

'Exporting monthly_data to Chronologis_réelles.xlsx
pagesave(t=excelxml, mode=update) "W:\FCIQ\SAMARCHE\Demandes clients\Chronologis_reelles.xlsm" range="monthly!A6" @keep reelles_monthly

Still it doesn't work and I have the error message I attached in the doc file.