HTML Maker error

[chaz_mac]

Xindows XP SP2
Excel 2003 SP2

Added HTMLmaker 2.4.2. Now I get a message box titled:

Error referencing [VBIDE = VBE6EXT.OLB]

with text:

Error Number:=91
Error Discrp:= Object variable or With block variable not set

You may have to manually set a reference to the [VBIDE = VBE6EXT.OLB]

and then an OK button and a Help button.

What gives??

Chaz

 

[Joe Was]

In the VBA Editor Toolbar: Tools - References

Look for a reference that is flaged as Missing, if any are un-check them.
Replace any that are Missing with a more current one in the DropDown list.
Look for the reference indicated by your error in the list, CheckBox it, close and you should be good to go.

 

[Scott Huish]

From the FAQ:

Error: "Error Number: 91, Object Variable or with Block variable not set..."
Click OK to close the dialog box with the error and go to Tools->Macros->Security. Click the Trusted Sources tab and check the box next to "trust access to Visual Basic Project," and click OK.

 

[chaz_mac]

Sorry - forgot to mention.

This happens on file open, even before it asks whether i want to allow macros or not.

Then, when the workbook is open, things appear to work fine, with the one time i tried HTML maker.

Still ??

Chaz

 

[Smitty]

Check out the HTML Maker FAQ.

Specifically:

Error: "Error Number: 91, Object Variable or with Block variable not set..."
Click OK to close the dialog box with the error and go to Tools->Macros->Security. Click the Trusted Sources tab and check the box next to "trust access to Visual Basic Project," and click OK.

HTH,

Smitty

 

[chaz_mac]

Thanks HOTPEPPER, the security setting did the trick.

 

[Bradlee_S]

was digging for a while to find this.

in 2007 look in the following:

Office Button
Excel Options
Trust Center
Trust Center Settings
Macro Settings
Developer Macro Settings / Check "Trust access to the VBA project object model"

 

[Von Pookie]

Oh, cool. I'll add that to the FAQ, thanks Bradlee

 

[krehkop]

I've checked that, all is okay, the correct add-in is selected, I get the "enable macros" message and select okay, still, no html munu item... Note: I'm running Office 2007

 

[schielrn]

Did you look on the Add-Ins Ribbon? It doesn't have its own Ribbon.