HTML Maker error

chaz_mac

chaz_mac

Board Regular
Joined
Mar 9, 2007
Messages
76
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
 
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.
 
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.
Click to expand...
 
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
 
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.
Click to expand...

HTH,

Smitty
 
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"
 
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
 
Did you look on the Add-Ins Ribbon? It doesn't have its own Ribbon.
 
You must log in or register to reply here.

Forum statistics

Threads
1,223,894
Messages
6,175,252
Members
452,623
Latest member
Techenthusiast

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top