Jump to content

ActiveX component cannot create object


Recommended Posts

Posted

Hi,

I am getting a "ActiveX component cannot create object" error whenever I open Excel and Word 2003. When I click OK, I get the error "Run-time Error 91:Object variable or with block variable not set". In addition, we cannot use the Save As feature in Excel or Word once they are running. I should also say that we are running Windows Terminal Server on the machine, but this problem just recently started occuring. Here is a block of code from when I choose to debug the error in Excel:

Public WithEvents App As Application
Private Sub App_WindowDeactivate(ByVal Wb As Excel.Workbook, ByVal Wn As Excel.Window)
Dim lReturn As Long
If Application.Workbooks.Count = 1 And Not oIDMMacros Is Nothing Then
lReturn = oIDMMacros.CIDMMacroAPI_IDMUpdateMenu(APPLTYPE, Application, True)
End If
End Sub

Private Sub App_WorkbookActivate(ByVal Wb As Excel.Workbook)
Dim lReturn As Long
If oIDMMacros Is Nothing Then
Auto_open
End If
[u]lReturn = oIDMMacros.CIDMMacroAPI_IDMUpdateMenu(APPLTYPE, Application)[/u]
End Sub

The underlined code is where VB says the problem is, although it is probably not actually in that line.

I've looked around in lots of forums and have tried to register some DLLs per suggestions, but have not resolved the issue. I have also uninstalled and reinstalled Office 2003, but that did not fix the issue either. Any ideas?


Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...