Hi there,
I was wondering if there is a way to get a group of series presented in row formatfrom an Eviews Workfile or EDB to Excel, using the Automated COM. I went through the white paper published in your website and it seems that is possible by using the GetGroupEx function, by using the transposse function. I have only managed to get a column with all the headers but the data is still being extracted by rows. Could you please give me a brief example of how to do that?
Cheers,
Fede
Get series transposed - Automated COM Excel VBA
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
Re: Get series transposed - Automated COM Excel VBA
I just found a workaround...to transpose the output from GetGroupEx directly in VBA. Is there any better solution?
-
- EViews Developer
- Posts: 798
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Get series transposed - Automated COM Excel VBA
That's probably your best bet. Though once you have the data from any of our Get methods, it's easy to transpose the data manually or have Excel do it for you -- I'm guessing there's a lot of tranpose options within Excel.
Who is online
Users browsing this forum: No registered users and 19 guests