EViews.com

I'm in need to create some Excels enviroments, but I need to call a couple of eviews routines.
Therefore, the final user should only run the program in excel and not require additional program runs.

I've seen Eviews COM may work for me, but I only have Eviews 6. Is there a way to run prgs from vba while with EViews6?

Thanks!

You can execute the EViews executable, passing in the name of an EViews program as an argument to the executable, which will tell EViews to run that program upon launch.

Thank you for your prompt reply...

shell ("C:\Program Files (x86)\EViews6\Eviews6.exe")

The basic command would be like that, wouldn't it?
How can I call the .prg then?
Where do I tell the arguments (like the route where the .prg is saved) to call the routine?

Like this I suppose?
Shell ("C:\Program Files (x86)\EViews6\Eviews6.exe \\FERRERE8\Economia\Sistema Financiero\Informe Sistema Financiero\Insumos Excel\Cap 1\Estimaciones\pred_creditos.prg")

Yep, although you might need quotes around the full path if you have spaces in it.

Thanks!

a USER posted this command for excel VBA

Shell ("C:\Program Files (x86)\EViews6\Eviews6.exe \\FERRERE8\Economia\Sistema Financiero\Informe Sistema Financiero\Insumos Excel\Cap 1\Estimaciones\pred_creditos.prg")

sschaffrath

--------------------------------------------------------------------------------

Report this postReply with quoteRe: VBA calling EViews prgs - is it possible on E6?
by EViews Gareth on Mon May 21, 2012 4:35 pm

Yep, although you might need quotes around the full path if you have spaces in it.


On the answer above-- where exactly would the extra quotes go if your full path to the eviews program had spaces in it?

thanks.