HTMLMaker error: Compile Error Can't find project or library

M

MPastor

Board Regular

Joined

Apr 8, 2004

Messages

136

• Sep 23, 2004

• #1

I've read and attempted to use the FAQ info about HTMLmaker, but the steps to fix MISSING references don't seem to "fit" my problem.

When I select the CONVERT SHEET TO HTML menu option under the add-in's HTML menu option, I get the message:

Code:

Compile Error Can't find project or library

and it highlights the LEFT function in the statement that appears below.

Code:

Set rngSelection = Application.InputBox(strMsg1, Left(strMsg2, 46), Selection.Address, Type:=8)

I can't seem to find any solutions for this problem.

Any ideas or suggestions??

 

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Sep 23, 2004

• #2

Re: HTMLMaker error: Compile Error Can't find project or lib

Uncheck the Outlook library reference in the HTML maker, it should be denoted as 'missing.' You should be all set.

 

Von Pookie

MrExcel MVP

Joined

Feb 17, 2002

Messages

13,686

• Sep 23, 2004

• #3

Hey Nate!

Do you happen to have any specific reasoning for that problem? I never ran into that one and don't recall anyone really mentioning it before...

Basically, I'm just thinking that if someone can explain to me what/why something with Outlook is causing the problem, I can add it to the FAQ

 

M

MPastor

Board Regular

Joined

Apr 8, 2004

Messages

136

• Sep 23, 2004

• #4

Re: HTMLMaker error: Compile Error Can't find project or lib

Nate, that fixed it. Thanks. By the way, there was nothing that I could find that said "Missing" anywhere in the References list...but, that doesn't matter now. THANKS LOTS!!!

...Mike

 

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Sep 23, 2004

• #5

Re: HTMLMaker error: Compile Error Can't find project or lib

Howdy Pook, it's not outlook specific, any bad reference will muck this up. Why, not sure. But I noted this here:

http://mrexcel.com/board2/viewtopic.php?t=92788&start=19

Here's a related (albeit Access) KB:

http://support.microsoft.com:80/support/kb/articles/q160/8/70.asp

Note, the level is moderate.

In any case, not sure what the issue is, but left() can indeed fail in VBA with missing references.

The HTML maker ships with a reference to Outlook XP (10.0) I believe, which can be a problem for folks.

Mike, you are welcome.

 

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Sep 24, 2004

• #6

Re: HTMLMaker error: Compile Error Can't find project or lib

Well, It's always left, so my theory is that VBA might be trying to access the Left property of the broken app ? you know, the Left that tells you the left position of the window ? there's not "Right" property so that one always works...

 

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Sep 24, 2004

• #7

Re: HTMLMaker error: Compile Error Can't find project or lib

Juan, I think you've hit the nail on the head somehow... Okay, so I take the following:

And without fixing the reference, I attempt to run:

MsgBox Left$("test", 1)

And it fails. However, if I run:

MsgBox VBA.Left$("test", 1)

And it works just fine.

So, it seems that is looking in the wrong place.

 

XL-Dennis

Well-known Member

Joined

Jul 27, 2002

Messages

1,920

• Sep 24, 2004

• #8

Re: HTMLMaker error: Compile Error Can't find project or lib

Hi guys,

In my experience we can get really weird behaviour due to missing references...

Recently I shipped a solution where I used third-part controls. The solution involved some easy stuff like Date and UCase and Excel was not able to resolve it. Removing the missing reference restored everything - well almost except for my own errors

 

G

gg

Well-known Member

Joined

Nov 18, 2003

Messages

560

• Jan 19, 2005

• #9

Re: HTMLMaker error: Compile Error Can't find project or lib

Nate -

I am not sure what mine is doing? It seems to be a similar issue.
However it is a little different....

When I open the VBA script editor and try and "uncheck" the out look reference it is not there...

However,
If I "un-check" the Add in in Excell for htmlmaker and close excel
I get the error reference again

then....
When I open excel and "re-Check" the Addin for htmlmaker then the Check box appeard with the Missing Outlook reference...When I uncheck it...
Everytihing is OK...Until I close excel and re-open it...then the cycle starts over?

any ideas?

 

NateO

Legend

Joined

Feb 17, 2002

Messages

9,700

• Jan 19, 2005

• #10

Re: HTMLMaker error: Compile Error Can't find project or lib

Hello again,

Uncheck the reference, then hit the save button (Or File->Save) in the VBE. Close and retry.