VBA Lookup and @date : take 2

[DBel2012]

Good morning,

I'm using EViews 7 and Excel 2010.

I did not get any reply to the first version of this topic posted earlier this week, so I will restate my question :

The commmand app.GetGroup("@date v41691903_SA", sampleData, NATypeAsExcelNA) imports the series v41691903_SA along with the date labels, as expected.

Since I need to identify what I will be importing (name of the series) in my Excel file, I use the following command :
vecNameSeries = app.Lookup("@date v41691903_SA", "series", LookupReturnMatrixAsColumns)

I would expect that command to provide me with a name for @date and a name for the series I'm importing. However, the name for the series «v41691903_SA» appears twice in the vecNameSeries.

Is there something I'm doing wrong?

Thanks!

[EViews Gareth]

@date is not a series in the workfile. So lookup won't be able to find it.

[DBel2012]

Hi Gareth,

I see. So the idea would be to provide a name myself for @date.

Thanks!

[EViews Gareth]

Yes. If you have a series in the workfile called "date", then lookup would be able to find it.