Export string objects to Excel
Posted: Thu Mar 09, 2017 1:19 pm
Hey guys,
I was wondering if/how you can export a string object from eviews to excel. I was trying something along these lines. Pagesave works for the regular series obviously, but it doesn't seem to recognize it if it's a string object. I've exported a string object to eviews before using the COM automation Get() in a VBA macro, but I'm sure there must be a way to do it from within eviews solely? Let me know, thanks!
current code:
I was wondering if/how you can export a string object from eviews to excel. I was trying something along these lines. Pagesave works for the regular series obviously, but it doesn't seem to recognize it if it's a string object. I've exported a string object to eviews before using the COM automation Get() in a VBA macro, but I'm sure there must be a way to do it from within eviews solely? Let me know, thanks!
current code:
Code: Select all
for %y {clientall}
Metnames.add ee{%y}
Metnames.add mhinc{%y}
Metnames.add sfepm{%y}
next
for !i=1 to Metnames.@count
%name= Metnames.@seriesname(!i)
string s{%name} = {%name}.@remarks
next
%d = @wcross("smhinc", clientall)
%e= @wcross("see", clientall)
%f= @wcross("ssfepm", clientall)
pagesave(t=excel, mode=update) C:\test1.xls range="Q_MHINC!F4" byrow @keep mhinc**
pagesave(t=excel, mode=update) C:\test1.xls range="Q_MHINC!IA4" @keep {%d}