LCase function gives an error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an add-in in Excel that calls the LCase function. This add-in works
when I am using Windows XP and Office 2003. It also works if I use Windows XP
and Office 2007. However, when I use Windows Vista and Office 2007 I get the
following error:

"Compile error: Can't find project or library"

Does anyone know why this is happening? If I remove the LCase call then I
get the same error when it gets to the a call to ChrW.

I need to figure this out ASAP so any help is greatly appreciated.
 
after the error, go to the VBE, then tools=>References and you should see one
or more references marked as MISSING. You need to fix these.
 
In the References window there is one library that says missing:

"MISSING: Msie ActiveX Control module"

I haven't been able to find anything that show me how to fix this. Any ideas?
 
Uncheck it. if you aren't using it. Use the browse button to find it on
that machine if your are.
 
did you save and close the workbook after unchecking it, then when you opened
the workbook back up did you make sure it was gone. After the error did you
then check and make sure you had no other bad references.

If all that fails, you can qualify lcase with vba.lcase, but that
shouldn't be necessary and I would consider it a bandaid when surgery is
necessary.
 
The library showed up again. I went through the steps again and now I am
getting the following "Microsoft Visual Basic" error:

Method 'PasteFace' of object '_CommandBarButton' failed
 
That is probably another error in your code. Using the
application.Commandbars probably gets you past that error.

--
Regards,
Tom Ogilvy



dolsen said:
No, if I do that I get a type mismatch error.
Click to expand...
 
How will using application.Commandbars fix an error that is caused when I use
application.Commandbars?
 
Okay, I see, CommandBars not CommandBar. I am using Application.CommandBars.
I still get the following error:

Run-time error '-2147467259 (80004005)':
Method 'PasteFace' of object '_CommandBarButton' failed

Any other ideas for me?
 
Back
Top