EViews.com

Hi Team

I am dveloping models in Eviews and automate the same. Below is the code that I am using:

wfopen "<pathname>"

smpl 01/01/2010 11/30/2012
equation eq_a1.ls d(a1) C AR(1) AR(2) AR(3) AR(4) AR(5) AR(6) AR(7) AR(8) AR(9)
equation eq_a2.ls d(a2) C AR(1) AR(2) AR(3) AR(4) MA(1)
equation eq_a3.ls d(a3) C AR(1) AR(2) AR(3) AR(4) AR(5) MA(1)
equation eq_a4.ls d(a4) C AR(1) AR(2) AR(3) AR(4) AR(5) MA(1)

smpl 12/01/2012 12/31/2012
do eq_a1.forecast eq_a1_f
do eq_a2.forecast eq_a2_f
do eq_a3.forecast eq_a3_f
do eq_a4.forecast eq_a4_f

wfsave(type=txt) "<pathname>" @keep eq* @smpl 12/01/2012 12/31/2012

As a next step I would like to develop an Excel based interface to be able to change the path names and time bracket (time period) on the Excel file and be able to control the model exceution in Eviews from Excel itself. The software version that I am using is Eviews 8 Enterprise edition which is compatible to connect to the ODBC connections. Can you help me establish the same.

Thanks!!! A quick help would be highly appreciated.