EViews com automation for Excel

[Fiham]

Hi, I've recently updated me EViews to 8 version from the 7 I was using until now. I had several macros written for excel, that were connecting with EViews through the old COM library. After updating I changed the reference in excel (as the old one was missing) to EViews 8.0 Type Library. However one I'm trying to run my programmes through excel, it doesnt work, it seems that the application is not properly recognized, below is the code I use to call EViews:

Dim mgr As New EViews.Manager
Dim app As EViews.Application
Set app = mgr.GetApplication
app.Show

In one of the files there is no action doen, where in the other I get error, which stops the macro at "Set app = mgr.GetApplication" point:
Run-time error '48':
Error in loading DLL

Do you have any ideas what i can try to do? When this didnt work I tried to run eviews with /register parameter, as it was done in the old version, but this didnt help at all. I also tried to add the NewInstance in mgr.GetApplication, but result was same as without the parameter. I'm a bit stuck at this point, as I have no idea, how to get things running.

[EViews Steve]

Actually, I think it's a problem with Excel. I would try just reboot your machine and try again. If that doesn't work, try running the EViews command: REGCOMPONENTS from within EViews 8. Click Yes (All) to re-register everything. Wait for the success message to appear. Then, restart Excel and try your VBA code again.

Steve

[Fiham]

I tried all these steps, but still get the same error with loading dll. Any other ideas what I can try to do?

[Fiham]

Ok, new problem! :)

I was able to through the step described earlier, i had to register this dll in my system by typing:
regsvr32 "C:\Program Files\EViews 8\EViewsMgr.dll"

But now there is different problem I face.
EviewsMgr is currently not licensed for use by a DCOM client. Please contact IGS to obtain authorization.

NOTE: If you are running locally without DCOM, make sure you are using EViewsMgr from a 32-bit process.


So I think problem is caused beause I have excel executable in my 32 bit folder and EViews in 64 bit folder. Now it is impossible for me to run the 64 bit version of excel (and wouldn't be for quite some time). I didnt find and EviewsMgr.dll for 32 bit in my EViews folder. Is there anything I can do from here?

[EViews Steve]

We made a change to this policy a few patches ago. Update your copy of EViews 8 to the latest patch and you will be able to run EViews 64-bit from Excel 32-bit.

By the way, running REGCOMPONENTS does several things, including calling regsvr32 with the path to the EViewsMgr.dll.

Steve