MrGoodwill:
The Excel Add In that is provided by EViews 7 is a small add-in that was written using Visual Basic for Applications (VBA). It was written as an example of how you can use our OLEDB driver to access data, and as such, the source code is not hidden or protected at all. If you press Alt-F11 within Excel, it will bring up the VBA editor which will allow you to see our source code and even make changes.
Now as to your error, it would be difficult for me to guess what could be causing your error without known the version of Excel you are running it on, your version of Windows, and also the build date of EViews 7 that you have installed. Since you are getting a specific error, you could have even provided the name of the VBA module or class that the error is occurring in and also the line number (or at least the name of the method or sub). In the future, when you are asking for help, you should provide these kinds of details.
Now, my guess is that you are using Office 2010, which wasn't readily available when we originally released our add-in. I've noticed that VBA seems to run with a bit more restrictions under 2010 than it did in the past. The problem I've seen is that any code that uses ActiveSheet or ActiveWorkbook directly in a "For Each" loop can cause this the Type Mismatch error.
So anywhere in the code that looks like this:
Code: Select all
Dim qt As QueryTable
For Each qt In ActiveSheet.QueryTables
has to be broken up into a few more lines like this:
Code: Select all
Dim qt As QueryTable
Dim wrk As Worksheet
Set wrk = ActiveSheet
Dim qts As QueryTables
Set qts = wrk.QueryTables
For Each qt In qts
which in effect is exactly the same as before but with the For Each call using an explicit Worksheet and QueryTables object instead of ActiveSheet directly.
In any case, there are a few of these in the VBA code. You can make the changes yourself, or you can download this file that I've modified:
http://eviews.com/Forum_support/EViews%20Add%20In.xla
To install this new version, the easiest thing to do is to copy the "Excel Add In.xla" file into your EViews7 subdirectory (there should already be one there, just overwrite it), then run EViews 7 and type in "REGCOMPONENTS", then click Yes to re-register everything and this should re-copy the new add-in file to your Office Add Ins folder.
If this doesn't fix your problem, please provide the details I asked for above...
Steve