| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right Function Doesn't Exists in Excel 2003?
Hi
in VBA you may check the references (Tools - References). Make sure the Excel/Office object library is checked -- Regards Frank Kabel Frankfurt, Germany Sworkhard wrote: I have a string that is, for example, January2004 with no spaces in it. I extracted the month using the Left Function but when I try to use the Right Function to extract 2004, I get the following error. Compile Error: Can't find project or library If anyone know how to get around this error, thier feedback would be appreciated. The Right Function is documented in the VBE Help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Right Function Doesn't Exists in Excel 2003?
It is checked. However, I have several other checked as well. I will see if there is a conflict and disable most of them.
Sworkhard "Frank Kabel" wrote: Hi in VBA you may check the references (Tools - References). Make sure the Excel/Office object library is checked -- Regards Frank Kabel Frankfurt, Germany Sworkhard wrote: I have a string that is, for example, January2004 with no spaces in it. I extracted the month using the Left Function but when I try to use the Right Function to extract 2004, I get the following error. Compile Error: Can't find project or library If anyone know how to get around this error, thier feedback would be appreciated. The Right Function is documented in the VBE Help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Right Function Doesn't Exists in Excel 2003?
That is not the problem. What may be causing it, however, is that there is a conflict between two object models. a couple were shown as missing and the newer versions not selected as well. I'll work with this and see if I can get it working. I did get an error saying there was a conflict so that is probably the prolem.
Thanks "Frank Kabel" wrote: Hi in VBA you may check the references (Tools - References). Make sure the Excel/Office object library is checked -- Regards Frank Kabel Frankfurt, Germany Sworkhard wrote: I have a string that is, for example, January2004 with no spaces in it. I extracted the month using the Left Function but when I try to use the Right Function to extract 2004, I get the following error. Compile Error: Can't find project or library If anyone know how to get around this error, thier feedback would be appreciated. The Right Function is documented in the VBE Help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why doesn't "Replace" function find value I know exists? | Excel Worksheet Functions | |||
| Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY? | Excel Worksheet Functions | |||
| Lookup function when 'lookup_value' does not always exists | Excel Discussion (Misc queries) | |||
| Add-ins function in Excel 2003 | Excel Worksheet Functions | |||
| Need help with a function I'm not sure exists | Excel Worksheet Functions | |||
Hybrid Mode
