Page 1 of 1

wfopen - 2 Excel files, 1 workfile

Posted: Wed Jul 29, 2009 9:45 am
by 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

Re: wfopen - 2 Excel files, 1 workfile

Posted: Wed Jul 29, 2009 11:31 am
by EViews Gareth
Pageload

Re: wfopen - 2 Excel files, 1 workfile

Posted: Wed Jul 29, 2009 12:13 pm
by 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)

Re: wfopen - 2 Excel files, 1 workfile

Posted: Wed Jul 29, 2009 12:44 pm
by 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.