EViews.com

I'm trying to switch to excel 2010 with .xlsx extension to store data for Eviews.
Is it possible to fetch data with WFOPEN in existing working file?
I mean, I want to fetch 3 excel sheets in one workfile. At the moment Eviews creates every new working file per excel sheet.

Use the "import" command.

Is it possible to import vectors (matrices) with IMPORT function? and transposed data (obs. in columns, variables in rows)?

No to either.