VBA Lookup and @date
Posted: Sun Feb 02, 2014 2:16 pm
Hello,
I'm using EViews 7 and Excel 2010.
This command work just fine :
matData = app.GetGroup("@date v41691903_SA", sampleData, NATypeAsExcelNA)
However, the following command does not produce the expected result :
vecNameSeries = app.Lookup("@date v41691903_SA", "series", LookupReturnMatrixAsColumns)
v41691903_SA appears twice in the vecNameSeries, while I was expecting @date (or something close to it) and v41691903_SA.
Can anyone see what I'm doing wrong?
Thanks!
I'm using EViews 7 and Excel 2010.
This command work just fine :
matData = app.GetGroup("@date v41691903_SA", sampleData, NATypeAsExcelNA)
However, the following command does not produce the expected result :
vecNameSeries = app.Lookup("@date v41691903_SA", "series", LookupReturnMatrixAsColumns)
v41691903_SA appears twice in the vecNameSeries, while I was expecting @date (or something close to it) and v41691903_SA.
Can anyone see what I'm doing wrong?
Thanks!