HTML Maker is giving errors

[webmeister]

Not sure if this is the right spot for my question. If it isn't, please let me know.

I'm running Windows XP and Excel 2003. I downloaded the HTML Maker program, and then opened a .CSV style data file, while having specified HTML Maker as an Excel add-in. When I go to open my .CSV file, I get the following error messages:

Error Number 91
Error Descrp: = Object variable or With block variable not set
You may have to manually set a reference to the [VBIDE = VBE6EXT.OLB]

What does this translate to mean? Have any of you folks encountered this, and what should I do to stop the error?

If anyone has an idea or two (or three....), please let me know. Thanks in advance!!

 

[Von Pookie]

Not sure if this is the right spot for my question. If it isn't, please let me know.

It wasn't, but I moved it to the correct spot

As to the error: it's covered in the FAQ. See the link under my name below:

 

[webmeister]

Thanks for your help!! That got rid of that error 91. However, I can't see the menu items specified...... what do I do at this point??

 

[Richard Schollar]

Hi Webmeister

What menu items are you referring to?

Richard

 

[Von Pookie]

Thanks for your help!! That got rid of that error 91. However, I can't see the menu items specified...... what do I do at this point??

The first questions I usually ask in this situation, just to get them out of the way/double-check:

1) Did you download the correct addin?

Usually when someone messages me saying they can't find the menus, they have downloaded something other than the HTML Maker. The most common issue is that they have downloaded the VB HTML Maker, which is something completely different. That is for use in the Visual Basic Editor (to display macro code (with formatting) in posts) and will not display any menus like what I describe in the FAQ. I have also seen cases where it was determined that people downloaded the "TableIt" addin from Colo's site, which is for use on a different forum.

What you should use here is just plain old HTML Maker (either Light or 2.42 or some other version number)--not VB or TableIt.

2) Is the add-in turned on/activated? (Tools\Add-ins\select HTML Maker from list)

 

[webmeister]

Hi, RichardSchollar,

I'm referring to the menus that were discussed in the FAQs for HTML Maker:

"Known Issues & Errors

I installed the HTML Maker add-in, but the "HTML" menu you say should appear on the menu bar is not there. "

Hi, again, Von Pookie.... I'll double check, but I swear I downloaded the right program.....

Thanks to the both of you for repltying so quickly!

 

[Von Pookie]

Another thought--though I haven't tested it or anything: if you are using a computer with multiple profiles (administrator/your username/etc.) did you put the .xla file in the Addins folder of the correct profile?

 

[webmeister]

Hmmmm.......

I'll check it out.....although I think so, since I can see it, so to speak.

Thanks!

 

[webmeister]

Hi, Kristy,

That fixed that problem!! Interesting, eh wot? Now I'll "play" with the menu options and see what comes of it.

Thanks for your suggestions and help!

 

[webmeister]

Hi, once more, Kristy....

Just posting a small piece of my Excel file, to make sure everything is working.....

676-2965-002_rev_AD__bom_Report.csv
	A	B	C	D	E	F	G	H	I	J	K	L
1	Level	F/N	Ref Des	Component Location	Name	Rev	Type	Description	State	Qty	U of M	Usage
2	1	1			600-2010-198	B	Migrated Part	PRINTED WIRING BOARD,BACKLIGHT	Manufacturing Release	1	EA - Each
3	1	2			243-0045-010	L	Component Part	ADHESIVES, EPOXY	Release	1	EA - Each	AR
4	1	3			005-2790-010	H	Component Part	ADHESIVE, SURFACE MOUNT	Release	1	EA - Each	AR
5	1	4			014-1450-010	F	Component Part	TAPE, THERMALLY CONDUCTIVE	Manufacturing Release	9
6	1	5	C12		184-0401-030	AM	Component Part	CAPACITOR, CHIP, TANTALUM	Release	1	EA - Each
7	1	6	C1,C2,C3,C4,C5,C10,C14,C79,C80,C81,C82,C83,C84,C93		184-0401-230	AM	Component Part	CAPACITOR, CHIP, TANTALUM	Release	14	EA - Each
8	1	7	Q6,Q9,Q10,Q12,Q13,Q14,Q15,Q16		204-0112-010	A	Migrated Part	SEMICONDUCTORDEVICE,TRANSISTOR	Manufacturing Release	8	EA - Each
676-2965-002_rev_AD__bom_Report