View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default LCase function gives an error

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.

--
Regards,
Tom Ogilvy


"dolsen" wrote:

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.