Serious_Sam Posted September 22, 2008 Posted September 22, 2008 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 ApplicationPrivate 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 IfEnd SubPrivate 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 SubThe 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?
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now