Exporting data to a specific excel sheet using "pagesave"
Posted: Tue May 31, 2011 12:56 pm
Hi there,
I am try to send some data to an excel sheet using the command pagesave.
Here is my complete code:
Once the code runs, all but one excel sheet disapears. The only one remaining is named "source_modeles_structurel" (as the file name) instead of
"facmod_v2" and "facmod_v1" as I intend to do (these 2 sheets were created prior to runing the code).
How can I refer to a specific excel sheet using the pagesave command? Is there a better command?
I use Eviews 7.
Thanks a lot,
Mara
I am try to send some data to an excel sheet using the command pagesave.
Here is my complete code:
Code: Select all
'excel file holding signals - IT CANNOT BE A "xlsx"
%xlsfile = "X:\Equi_Val_Exc_G10\source_modeles_structurel.xls"
pagesave(t=excel) %xlsfile range=facmod_v1!A1 @keep sig_* @smpl 1990m01 @last
pagesave(t=excel) %xlsfile range=facmod_v2!A1 @keep sig_* @smpl 1990m01 @last "facmod_v2" and "facmod_v1" as I intend to do (these 2 sheets were created prior to runing the code).
How can I refer to a specific excel sheet using the pagesave command? Is there a better command?
I use Eviews 7.
Thanks a lot,
Mara