EViews.com

Hi Gareth,

Thanks for the inputs, will remember the first point regarding consolidation in single worksheet.

Regarding complete automation, tomorrow will try the function and program and get back to the forum in case if I need further handholding.

Cheers
Gunjan

Thanks Gareth, will check on your directions :) thanks again!

Now, I'm exploring the possibility of using odbc connectivity option of the wfopen command to connect directly to Bloomberg API's and fetch the relevent data to create the workfile instead of using COM interface and VBA with Excel as an intermediary between Bloomberg and EViews. Is it possible? I've...

Looks like too much experimentation without proper direction takes one nowhere - so thanks a lot! Amazing simplicity and great solution :) This thread can be closed.. For future users, I've used what jthodge suggested above and finalized with a wfsave command. Thanks again..

Cheers,
Gunjan

A little errata: '----------------------------------------------------------------------------------------------------- ' Step 2 - Read the individual worksheets of the excel files you are inerested ' Here, if the frequency of the data is not same, additional parms should ' be specified so that the ...

Hi folks, I'm new to EViews and leaning my way slowly on version 8. One problem statement that I'm trying to solve as a first task is to automate loading and conversion of muti-worksheet excel files to a single EViews workfile (.wf1) with multiple worksheets as corresponding multiple pages within th...