Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
Some other library is missing. Go to Tools References in the VBE and check.
-- Tim Williams Palo Alto, CA "dolsen" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
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? "Tim Williams" wrote: Some other library is missing. Go to Tools References in the VBE and check. -- Tim Williams Palo Alto, CA "dolsen" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
Uncheck it. if you aren't using it. Use the browse button to find it on
that machine if your are. -- Regards, Tom Ogilvy "dolsen" wrote: 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? "Tim Williams" wrote: Some other library is missing. Go to Tools References in the VBE and check. -- Tim Williams Palo Alto, CA "dolsen" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
I was unable to find it so I unchecked it. However, I am still getting the
error. "Tom Ogilvy" wrote: Uncheck it. if you aren't using it. Use the browse button to find it on that machine if your are. -- Regards, Tom Ogilvy "dolsen" wrote: 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? "Tim Williams" wrote: Some other library is missing. Go to Tools References in the VBE and check. -- Tim Williams Palo Alto, CA "dolsen" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
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. -- Regards, Tom Ogilvy "dolsen" wrote: I was unable to find it so I unchecked it. However, I am still getting the error. "Tom Ogilvy" wrote: Uncheck it. if you aren't using it. Use the browse button to find it on that machine if your are. -- Regards, Tom Ogilvy "dolsen" wrote: 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? "Tim Williams" wrote: Some other library is missing. Go to Tools References in the VBE and check. -- Tim Williams Palo Alto, CA "dolsen" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Performance Difference - LCase vs UCase? | Excel Programming | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Can I get VBA script to read a word with both lcase and ucase lett | Excel Programming | |||
Get…UCase or LCase ??? | Excel Programming | |||
Get…UCase or LCase ??? | Excel Programming |