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
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. |
#4
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. |
#5
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. |
#6
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. |
#7
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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
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 "Tom Ogilvy" wrote: 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. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
is commandbars qualified with Application
Application.CommandBars . . . -- Regards, Tom Ogilvy "dolsen" wrote: 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 "Tom Ogilvy" wrote: 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. |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
No, if I do that I get a type mismatch error.
"Tom Ogilvy" wrote: is commandbars qualified with Application Application.CommandBars . . . -- Regards, Tom Ogilvy |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
That is probably another error in your code. Using the
application.Commandbars probably gets you past that error. -- Regards, Tom Ogilvy "dolsen" wrote in message ... No, if I do that I get a type mismatch error. "Tom Ogilvy" wrote: is commandbars qualified with Application Application.CommandBars . . . -- Regards, Tom Ogilvy |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
How will using application.Commandbars fix an error that is caused when I use
application.Commandbars? |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
Application.CommandBars doesn't cause a type mismatch error.
-- Regards, Tom Ogilvy "dolsen" wrote in message ... How will using application.Commandbars fix an error that is caused when I use application.Commandbars? |
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
LCase function gives an error
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? "Tom Ogilvy" wrote: Application.CommandBars doesn't cause a type mismatch error. -- Regards, Tom Ogilvy "dolsen" wrote in message ... How will using application.Commandbars fix an error that is caused when I use application.Commandbars? |
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 |