EViews.com

Hey There.

I work with EViews 7 and now have a problem with importing date from a Excel 2010 .xlsm file. Up to now I worked with Excel 2003, and i used the read command like
read(t,b2,s=TY) estimdat.xls 8
read(t,b2,s=VS) estimdat.xls 5
read(t,b2,s=ES) estimdat.xls 10
read(t,b2,s=TC) estimdat.xls 3
which imported for all defined Sheets in the Excelfile the number of series spezified. The series are in rows (see the attached file)

Now I have Excel 2010 (.xlsm) and I tried to change the code to
read(t,b2,s=TY) estimdat.xlsm 8
But this did not work.

Now my questions:
1. Does the read command support .xlsx/.xlsm documents
2. If not, does the read command in EViews 8 support .xlsx/.xlsm files
3. If not, Is there a way to use the import command with Excelfiles (.xlsx/.xlsm) when the series are in rows

Thanks for help!
Reto

READ does not support .XLSX/XLSM files.

IMPORT supports by row in EViews 8, but not in EViews 7.