Help on VBA & disabling an error message

ADS318

New Member
Joined
Sep 22, 2002
Messages
8
Using Win2k and Office XP...
I contacted Ivan Moala after having problems installing the HtmlMaker 2.20 He instructed me to download the ietimer.ocx from MS, which I did and that part works fine now. I am still getting a Reference error message when I open Excel. Ivan wrote and told me the Reference error may be due to using Office XP, he doesn't use it so he wasn't sure. He said that if I had experience with VBA that I could disable the error message. Unfortunately, I do not have any experience with VBA. Is there anyone here that could help me disable the error message? You can view it at: http://w3.ime.net/~cordman/error.html

The image at the bottom is the one I am concerned with. TIA
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
After you install it in Excel, go to the VBA (Alt F11), select the HTLMMaker file on the project explorer (Control R if you can't see it), and go to Tools | References. You should see a missing reference in there, which one is it ? I HAVE used it in XP without problems, so, that shouldn't be it.
 
Upvote 0
On 2002-09-24 07:15, Juan Pablo G. wrote:
After you install it in Excel, go to the VBA (Alt F11), select the HTLMMaker file on the project explorer (Control R if you can't see it), and go to Tools | References. You should see a missing reference in there, which one is it ? I HAVE used it in XP without problems, so, that shouldn't be it.

There are eight references that are checked and over two-hundred that are not checked, but I don't see any that are labeled missing. Any suggestions? TIA
 
Upvote 0
Ok, open the VBA editor (Alt F11), and open one of the modules of the HTML Maker. Go to Debug | Compile. You should be taken to the problem line, which one is it ?
 
Upvote 0
Well, believe it or not, upon compiling absolutely nothing happened, no error or anything. It appeared to compile OK. I even closed Excel, reopened and tried it again, still nothing :sad:
 
Upvote 0
No, the error is still there. I am quite certain that it is related to HtmlMaker because I never got the error prior to installing HtmlMaker. Further, if I go into Excel -> Tools -> and Add-ins and uncheck HtmlMaker I do not get the error on Excel startup.
 
Upvote 0

Forum statistics

Threads
1,226,225
Messages
6,189,735
Members
453,566
Latest member
ariestattle

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