VBA calling EViews prgs - is it possible on E6?

[sschaffrath]

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!

[EViews Gareth]

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.

[sschaffrath]

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?

[sschaffrath]

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")

[EViews Gareth]

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

[sschaffrath]

Thanks!

[Silvana]

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.