run-time error '5' iexplorer

[gcole]

I am sorry that I couldn't find this information with search. It keeps returning information from all forums.
Anyway, I am opening an XLS spread sheet in Internet Explorer. When I close it, I run the following:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("File").Controls.Item("save").Enabled = True
Application.CommandBars("File").Controls.Item("save as...").Enabled = True
If Val(Application.Version) > 8 Then
Application.CommandBars("File").Controls.Item("Save as Web Pa&ge...").Enabled = True
End If
Application.CommandBars("File").Controls.Item("Save &Workspace...").Enabled = True
Application.CommandBars("Tools").Controls.Item("Protection").Enabled = True
Application.CommandBars("Tools").Controls.Item("Macro").Enabled = True

End Sub


I get a run time error 5 on the first command. This doesn't happen in an other versions of Excel (97,2000,2003). Any ideas?

 

[gcole]

Any ideas?

 

[chopsuey2]

Found your thread on a search for a solution for my own problem.

Have you checked the reference libraries? I have encountered a similar problem when running access 2000 code under access 2003 and its looks like the access object 11.0 library might be the culprit.