wfopen - 2 Excel files, 1 workfile

[cap]

Hello,

Is there a way to use wfopen to get open two Excel files into one Eviews workfile? Using wfopen for a 2nd time just creates a 2nd workfile...


Thanks,
-cap

[EViews Gareth]

Pageload

[cap]

Sorry, I should have stated that I wanted the series from multiple Excel files to be in the same page, not just the same workfile.

So, is there a way to get all of the series from different pages onto the same page? It appears having the series on different pages will not allow you to use them simultaneously (eg, @cor(series1, series2) does not work if the series are on different pages)

[EViews Gareth]

You can use the READ command to read Excel data into an existing workfile page.

Possibly easier is to use the PAGELOAD command to open the Excel file into a new page, then use the COPY command to copy the series you want into your current page.