So I'm using Eviews 9.5 and I've had a VBA macro that has worked for the last 2 years. Suddenly I attempted to run the macro yesterday and I was no longer able to. The macro just breaks and says some mumbo jumbo like "Automation Error -2147417848 The object invoked has disconnected from its clients." The only thing that I've noticed is, normally if you have Eviews open and run the VBA macro Eviews will generate the workfile and do all of the data imports/actions so I can see it as it goes through. It appears VBA is having trouble creating the workfile within Eviews. Even something as simple as the code below no longer creates the workfile like I've come to expect. Was there a change made? I'm using Excel 2010, btw.
Code: Select all
Sub Test()
Dim mgr As New EViews.Manager
Dim app As EViews.Application
Set app = mgr.GetApplication(ExistingOrNew)
app.Run "wfcreate(wf=C:\test\temp1) a 1975 2046"
End Sub