Eviews COM Automation - User defined type not defined
Posted: Wed Aug 27, 2014 5:32 am
Hello,
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
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.
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.