I have created a VBA script that uses the Eviews COM object and it runs fine on my machine. However, when another user tries to run it they get the error: User defined type not defined and the debugger highlights the Dim mgr as New Eviews.Manager line of the following snippet
Code: Select all
Dim mgr As New EViews.Manager
Dim app As EViews.Application
Set app = mgr.GetApplication(ExistingOnly)
Their machine has the COM object registered (I checked regcomponents) and is running the correct Reference (Eviews Type 8.0).
I googled it and MS gives some suggestions regarding something called the DAO but after enabling that reference too the same error appears. Also MS seems to think this is a 2003 problem whereas we are using Excel 2010 and later versions. Any ideas would be greatly appreciated! Thank you in advance.