Eviews 7 Excel Add-in

[lihughes]

I am using the Office 2010 64-bit beta on a Win7 64-bit machine. When I try to launch the Eviews 7 Excel Add-in, I get a bunch of VBA errors.

Specifically, and this error occurs three times:

Compile Error;

The code in this project mut be updated for use on 64-bit systems.
Please review and update Declare statments and them mark them with
the PtrSave Attribute

After which, there is no indication of the Eviews Add-in in the "Add-ins" ribbon.

Thank you,

L...

[EViews Steve]

Actually, we were already aware that our OLEDB driver does not work with Office 2010 Beta.

We've made some attempts at rectifying this but it seems Microsoft's own OLEDB driver examples fail to work with Office 2010 beta so we've decided to hold off until they release a Release Candidate version.

Now about the VBA errors, fixing them at this point will be pointless because our OLEDB driver will still not work (the add-in uses OLEDB to access EViews data) with Office 2010. As a side note, it seems rather dangerous on Microsoft's part to not allow older 32-bit Excel Add-Ins to work with Office 2010 64-bit. I'm assuming a lot of add-in writers will have to go back to the drawing board if Office 2010 is officially released with this problem.

Please be patient with us until we can release a newer version of the Excel Add In designed specifically for Office 2010.

Steve

[lihughes]

I will see what I can find out at this end... I can speak to the Excel development team (maybe, no promises)

[dmontford]

This is why Microsoft recommends installing 32-bit Office 2010 by default, even on a 64-bit OS.

[EViews Steve]

Actually, our original OLEDB driver didn't work with Office 2010 32-bit either. We've made a fix to that with the help of Microsoft so our latest version does work. However, it'll be a while before we release a 64-bit version for Office 2010 64-bit.

[lihughes]

Hey folks, do you guys have the Office2010 Excel add-in yet?

[EViews Steve]

If you get the latest EViews 7 patch, the 32-bit version of the add in will now work properly in Office 2010 64-bit and 32-bit. It is still a 32-bit add-in, so you're still constrained with 32-bit memory limits, but it should work fine with 64-bit office.

[lihughes]

I did apply the patch, but the add-in does not appear to be updated. Did I do something wrong, or is there something more I need to do.

BTW, the error is different this time, "Provider cannot be found. It may not be properly installed"

[EViews Steve]

Run EViews, then type in "REGCOMPONENTS". Click Yes to re-register everything. Then try Office again.

[lihughes]

Still getting the same error. The add-in appears to have been updated, though.

[EViews Steve]

Oops, my mistake. The reason it works on my machine is because I have some unreleased 64-bit (development) code installed. The updated version of the Add-In only lets you use the 32-bit version of Office 2010 with our add-in (which was a different problem). Sorry.

Since you were integral in helping us getting this 64-bit version of our OLEDB driver working, I'll send you a small zip file that contains the 64-bit version of our OLEDB driver so that it will work with your 64-bit Office. Because it's still in development I can't vouch for how well it will work but in my routine testing it seems to work fine for me.

I'll go over the details on how to install it on your system in the email. Expect to see it in the next few minutes...

Steve

[FICS]

I've been having the same problem with the Eviews Excel Addin for Excel 2010 64bit. Is there any way you could send us the patch so we can fix this problem?
When can we expect an official solution to this problem?

Thank you in advance

[EViews Steve]

The official 64-bit version won't be released (most likely) until we release version 8 sometime later this year.

To be clear, the current version of our Excel Add In for EViews 7 will work with Office 2010, but only the 32-bit version.

Steve

[EViews Glenn]

"Sometime later this year" is not accurate as we do not yet have a time frame for release.

[viniciussousa]

Hi Steve, I'm having the same problem ("Provider cannot be found. It may not be properly installed") in my Excel 2010 64-bit. Is there any way you could send me the small zip file that contains the 64-bit version of your OLEDB driver so that it will work with my 64-bit Office?

Thanks a lot.