runtime error 5 in HtmlMaker20101230

[ask2tsp]

installed add-in and then every time it produces this error
----------
Sub CleanUp()
Dim cbc As CommandBarControl
On Error Resume Next
Set cbc = Application.CommandBars("Worksheet Menu Bar").Controls("MrExcelHtml")

result: runtime error 5 invalid procedure call or invalid argument
----------
using windows 8.1, excel 2013 (language Netherlands)

any idea what's going on?

 

[Peter_SSs]

Since the HTML Maker works for me in Excel 2013 (English) and Windows 7, I'm wondering if it relates to Windows 8 or the different language version of Excel. I don't have either of those so am unable to investigate.
Did you try Excel jeanie? It's my preference in most case anyway as it enables showing more things like Conditional Formatting Rules, Data Validation etc

 

[ask2tsp]

Peter, I was digging a bit further in this matter and discovered that this error is raised if the control (MrExcelHtml) does not exists. One would expect another error number. This error 5 is probably not rerouted by 'on error' logic.
I'll try Excel jeanie.

 

[RoryA]

It should be suppressed by the On Error statement - I suspect you have your VBE set to break on all errors.

 

[ask2tsp]

that saved the day! thanks RoryA

 

[ask2tsp]

But now, although HTMLmaker works, I cannot properly debug vba code anymore!
Maybe one of these days I'll dig into the HTMLmaker code to see if this can be solved without using on error resume next.

 

[RoryA]

You should not need that setting on to debug code. (I've never had it set to that - I always use break in class module.)

 

[ask2tsp]

I always use break in class module

That's the one. Now I'm happy