Reading Excel data in multiple worksheets

[Dirk]

Hi all,

I have a very basic question. I need a program to read monthly data into a "monthly" worksheet and quarterly data into a "quarterly" worksheet. Then I want the progam to copy the quarterly data into the monthly worksheet to achieve an automatic frequency conversion. Can anyone tell me how to program this?

Or is there a better way to convert quarterly to monthly data with an Eviews code?

Many thanks
D.

[EViews Gareth]

Use the wfopen command to open up the first sheet, then use the pageload command to open up the rest of the sheets, then use the copy command to copy from one to the other.

Or, you could just use the import command to import directly from the quarterly Excel sheet into the monthly EViews page, doing frequency conversion on the fly.

[Dirk]

Many thanks, I'll try this.