EViews.com

All,

I'm trying to write a short code to put out some data, with dates and titles out of EViews and on to and excel spread sheet. But i seem to hav hit a weird issue with the dates, instead of putting a single date into each cell. Each cell ends will a series of dates, starting with the correct date, and then running to the last observation in the file.

The VBA code is

Scommand = "Alpha ZZ_temp = @STRDATE(" & Chr(34) & " DD/MM/YYYY " & Chr(34) & " ) "
app.Run (Scommand)
Dates = app.Get("ZZ_temp")
rows = UBound(Dates, 1) - LBound(Dates, 1) + 1
WST_TV.Range(WST_TV.Cells(4, 1), WST_TV.Cells(3 + rows, 1)) = Dates

What am i doing wrong? I can look at ZZ_Temp and it looks like what I need, but it doesn't seem to be pulling through to excel correctly.

Is there a better way to pull dates out? It feels like i've missed a trick somewhere.

I'm currently using Eviews V7.2

Kind Regards

Sam

Unfortunately our resident COM expert, Steve, is on vacation this week. Might take a while to get an answer :(

OK, No worries.

In the last line of your VBA code, make it say:
WST_TV.Range(WST_TV.Cells(4, 1), WST_TV.Cells(3 + rows, 1)).Value = Dates

Steve

Sorry, but i still get the same issue.

Ok, I was able to confirm this is a bug. I'll let you know when we have a fix for this...

This bug has been fixed and will be in the next patch. Not sure when the patch is being released but it should be soon.

Steve

Ok, patch for this bug has been built and released. Look for Build Date of: April 16, 2013.

Steve