Colo's HTML Maker Addin Problem

[gnaga]

Hi,

After I installed Colo's HTML maker I am getting the following errors when the excel starts

1. Could not load an object because it is not available on this machine.

Subsequently after the first error

2. Err No:=91
Err Discrp:= Object variable or With
Block variable not set

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

Any suggestion to overcome this error?

Thanks

GNaga

 

[Ivan F Moala]

Open the VBA editor to the Addin.
Do a search for the Sub I gave above.

<META content=Excel.Sheet name=ProgId><META content="Microsoft Excel 9" name=Generator><LINK href="./sht_files/filelist.xml" rel=File-List><STYLE id=AAA_Instructions_VBAEnter_7344_Styles></STYLE>  <DIV id=AAA_Instructions_VBAEnter_7344 align=center xublishsource="Excel"><TABLE style="TABLE-LAYOUT: fixed; WIDTH: 481pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=640 border=0 x:str><COLGROUP><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1097" width=30><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 338pt; mso-width-source: userset; mso-width-alt: 16493" width=451><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 914" width=25><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl247344 style="WIDTH: 23pt; HEIGHT: 13.5pt" width=30 height=18> </TD><TD class=xl247344 style="WIDTH: 53pt" width=70> </TD><TD class=xl247344 style="WIDTH: 338pt" width=451> </TD><TD class=xl247344 style="WIDTH: 48pt" width=64> </TD><TD class=xl247344 style="WIDTH: 19pt" width=25> </TD></TR><TR style="HEIGHT: 24.75pt" height=33><TD class=xl247344 style="HEIGHT: 24.75pt" height=33> </TD><TD class=xl467344 style="BORDER-RIGHT: white 2pt double" colSpan=3>Error Correction - Fast Fix</TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 24pt" height=32><TD class=xl247344 style="HEIGHT: 24pt" height=32> </TD><TD class=xl347344> </TD><TD class=xl347344> </TD><TD class=xl347344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 23.25pt" height=31><TD class=xl247344 style="HEIGHT: 23.25pt" height=31> </TD><TD class=xl287344>STEP</TD><TD class=xl337344 x:str="'' HOW J">' <FONT class=font77344>HOW<SPAN style="mso-spacerun: yes">  </SPAN></FONT><FONT class=font87344>J</FONT></TD><TD class=xl287344>OK</TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl367344>1)</TD><TD class=xl317344 style="BORDER-LEFT: medium none; WIDTH: 338pt" width=451><SPAN style="mso-spacerun: yes"> </SPAN>Press <FONT class=font67344>Alt-F11 </FONT><FONT class=font57344>to display the Visual Basic editor (VBE).</FONT></TD><TD class=xl407344 style="BORDER-LEFT: medium none">þ</TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl397344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl247344 style="HEIGHT: 25.5pt" height=34> </TD><TD class=xl367344>2)</TD><TD class=xl317344 style="BORDER-LEFT: medium none; WIDTH: 338pt" width=451><SPAN style="mso-spacerun: yes"> </SPAN>In the <FONT class=font67344>Project Explorer window</FONT><FONT class=font57344>, find the </FONT><FONT class=font67344>Addin</FONT><FONT class=font57344> object. If you don't see the </FONT><FONT class=font67344>Project Explorer window,</FONT><FONT class=font57344> press</FONT><FONT class=font67344> Ctrl-R.</FONT></TD><TD class=xl407344 style="BORDER-LEFT: medium none">þ</TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl397344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl367344>3)</TD><TD class=xl317344 style="BORDER-LEFT: medium none; WIDTH: 338pt" width=451><SPAN style="mso-spacerun: yes"> </SPAN><FONT class=font67344>Double-click</FONT><FONT class=font57344> the </FONT><FONT class=font67344>Addin</FONT><FONT class=font57344> object in the </FONT><FONT class=font67344>Project Explorer window</FONT><FONT class=font57344>.</FONT></TD><TD class=xl407344 style="BORDER-LEFT: medium none">þ</TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl397344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl247344 style="HEIGHT: 25.5pt" height=34> </TD><TD class=xl367344>4)</TD><TD class=xl317344 style="BORDER-LEFT: medium none; WIDTH: 338pt" width=451><SPAN style="mso-spacerun: yes"> </SPAN><FONT class=font67344>Double-click</FONT><FONT class=font57344> the </FONT><FONT class=font67344>Modules</FONT><FONT class=font57344> object in the </FONT><FONT class=font67344>Project Explorer window</FONT><FONT class=font57344>. Select ANY Module and double click this</FONT></TD><TD class=xl407344 style="BORDER-LEFT: medium none">þ</TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl397344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD class=xl247344 style="HEIGHT: 25.5pt" height=34> </TD><TD class=xl367344>5)</TD><TD class=xl317344 style="BORDER-LEFT: medium none; WIDTH: 338pt" width=451>Now Press Ctrl + F (Find) and type in your seach string = <FONT class=font67344>CreateReferences</FONT></TD><TD class=xl407344 style="BORDER-LEFT: medium none">þ</TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl397344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl367344>6)</TD><TD class=xl457344 style="BORDER-LEFT: medium none; WIDTH: 338pt" width=451>Save<FONT class=font57344> the Addin before closing</FONT></TD><TD class=xl407344 style="BORDER-LEFT: medium none"> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl257344><U style="VISIBILITY: hidden; mso-ignore: visibility"> </U></TD><TD class=xl397344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl247344 style="HEIGHT: 15pt" height=20> </TD><TD class=xl367344>7)</TD><TD class=xl327344 style="WIDTH: 338pt" width=451>Test and get back with ANY Errors</TD><TD class=xl407344 style="BORDER-LEFT: medium none"> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl247344 style="HEIGHT: 12.75pt" height=17> </TD><TD class=xl237344> </TD><TD class=xl227344 style="WIDTH: 338pt" width=451> </TD><TD class=xl297344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl247344 style="HEIGHT: 12.75pt" height=17> </TD><TD class=xl267344> </TD><TD class=xl277344 style="WIDTH: 338pt" width=451> </TD><TD class=xl307344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl247344 style="HEIGHT: 18.75pt" height=25> </TD><TD class=xl387344 style="BORDER-TOP: medium none"> </TD><TD class=xl377344 style="BORDER-LEFT: medium none; WIDTH: 338pt" width=451> </TD><TD class=xl297344> </TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 32.25pt; mso-height-source: userset" height=43><TD class=xl247344 style="HEIGHT: 32.25pt" height=43> </TD><TD class=xl417344 style="BORDER-TOP: medium none">a</TD><TD class=xl357344 style="BORDER-LEFT: medium none; WIDTH: 338pt" width=451><SUP>µ</SUP><FONT class=font107344> HTH - Ivan F Moala </FONT><FONT class=font97344><SUP>µ</SUP></FONT></TD><TD class=xl427344>[</TD><TD class=xl247344> </TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl247344 style="HEIGHT: 13.5pt" height=18> </TD><TD class=xl447344 style="BORDER-TOP: medium none"> </TD><TD class=xl247344> </TD><TD class=xl437344 style="BORDER-TOP: medium none"> </TD><TD class=xl247344> </TD></TR></TBODY></TABLE></DIV>

 

[XL-Dennis]

plettieri,

Yes, I can understand that You are a little bit disappointed that the utility does not work properly.

Today there exist a lot of different windows-operatingsystem (95/98/ME/NT/2000/XP) and also some versions of XL (97 / 2000 / XP with Service Packs etc).

Now add also that some of us on the board also use different language-version of above softwares (spanish / danish / finish / german / swedish etc....)

This complicate things, i e for Colo & Ivan it would required that they had all the versions available to assure that the tool works properly on all plattforms and with all versions of XL.

Upto this date the utility, as far as I know, has "only" been fully tested for XL 2000 on different plattforms, i e no focus on XP-version of XL.

Why? I guess that the average visitor of the list not yet have updated their XL-version to the latest, i e running both 97 & 2000.

That said - Clarification how to find "CreateReferences".

1. Alter to the VB-editor, locate the HTML-maker project in the project-window and make sure it activated.

2. Choose the command Edit | Find and enter the word "CreateReferences" - Make sure that You have checked the option Current Project.

3. Insert following in this procedure as follows:

Sub CreateReferences()
Exit Sub
....here comes the existing code


good luck and kind regards,
Dennis

 

[Yogi Anand]

On 2002-10-05 07:58, plettieri wrote:

in part

I have asked the question to the one of the authors (Mr Colo) on that question and the additional issue that i have of not being able to paste into the message box (see my prev threads) on none of my three machines. He said that he will check into it.....We three or four people who responded can't be the only ones that have this issue... Maybe the others just ignore it. It would be interesting to see how many actually have the problem and just accept it as it is or found work arounds....I would hope that Mr. Colo will come to be with a suggestion or preferably a revised download ... I will post the answer to this thread when he does.

Thanks for looking...until then...

pll

I am using HtmlMaker2.20 with Excel97 on Windows 98, and I can not get to copy the code to the clip board to eventually paste into the post either -- so what I do is VIEW the SOURCE code from the browser, copy it and then paste it into the post. If you are not able to VIEW the SOURCE code from the browser, then

you have to go to the MOD_HTML module of HtmlMaker2.20 and comment out the following line

Kill sFilePath

If it works for you -- then you can save the changes made and you will have a workaround.

Regards!

Yogi

 

[Ekim]

Hi Guys,

Using Excel 97 under Windows 95 (yeah, I know ancient).

After frigging around with this Html utility for some time it finally works after following Yogi's advice on View Source Code/Copy and commenting out Kill sFilePath.

Thanks to Gnaga for being so persistent.

I have just put a test pattern in the Test Forum. If I can get it to work with my configuration, it should work with any system.

Regards,

Mike
This message was edited by Ekim on 2002-10-05 15:59

 

[plettieri]

Thankx to Mr. Ivan, Mr. Yogi, and Mr XL-Dennis I have now the capability to post up worksheets to the board. Following your suggestions on the earlier posts I was able to get rid of the error messages but like Mr.Yogi I still have to perform his work a round to paste. Maybe Mr. Colo will soon come up with a revised edition so that future users may not have to deal with these issues and can focus on "Excelling". Hope this post will give some relief to those who have come accross this problem.

Tks again.
pll

 

[gnaga]

Book1
	A	B	C	D	E	F	G
1	Hi,Iamsolatetoreplyforthis.
2	YesIgetridoftheseconderrorbychangingtheCreatereferencesroutine
3	ThankstoIvanandeveryone.
4
5	JusttotesttheHTMLagainIamreplyinginworksheet.
6
7	Thanks
8	Gnaga
9
Sheet1

 

[gareth]

I think the problem is where you are selecting less than thirty(30) rows and x amount of columns.If you pick less you will get that error.

There your problem is fixed

 

[Colo]

Hi All,

I looked into how to solved clip board problem, but it's not solved so far.
So I add View Source function as compromise proposal.
Please give it a try, version 2.30.

 

[RichardS]

I had been getting that error about an object not being on the machine ever since I loaded Colo's utility. After going back through some of the other threads, especially the ones for non-techo's like me, I now look like I finally have the utility working properly, with no messages. Thanks all.

Richard