I have been trying to figure out the most effective way to read in data to Excel with VBA code using eviews. I have been looking through a few references and can't seem to find exactly how to implement what I need.(examples below) I just need some VBA code that grabs a series from a specified databank over a certain sample period. I'm sure this is ridiculously simple, but any hints would be much appreciated.
Thanks!
http://www.eviews.com/download/whitepap ... _AddIn.pdf
http://www.eviews.com/download/whitepap ... Driver.pdf
http://www.eviews.com/download/whitepap ... mation.pdf
Read in Data to Excel from database in VBA
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13306
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Read in Data to Excel from database in VBA
Look at the application.getseries example in the last of those whitepapers.
Follow us on Twitter @IHSEViews
Re: Read in Data to Excel from database in VBA
Thanks for quick response.
I thought that was the closest to what I was after. Where do you specify the database you want? Do I have to individually open it within a workfile for that interface to work?
I thought that was the closest to what I was after. Where do you specify the database you want? Do I have to individually open it within a workfile for that interface to work?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13306
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Read in Data to Excel from database in VBA
Following up on this-- I have everything working beautifully in terms of importing from Eviews using the VBA, but is there a way to ensure that the data label is also imported? ( I guess technically "description" in eviews)
Re: Read in Data to Excel from database in VBA
Does the app.Get below work with string objects? It doesn't seem to recognize them?
Never mind, I got it to work. Forgot the quotes on the S.....
Code: Select all
Range(rng10).FormulaR1C1 = app.Get(S & emp & State, NATypeAsExcelNA)
Never mind, I got it to work. Forgot the quotes on the S.....
Who is online
Users browsing this forum: No registered users and 19 guests