Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
right right$ left left$ mid mid$
If you change the code to:
nameR = VBA.Strings.left(nameL,5) Does it work? If so, try unregistering the refference to "Visual Basic for Applications" in Tools | Refferences and then re-registering it. P "Craig Mitchell" wrote in message ... I have an application I've built with excel that generates an error Cannot find project or library on the code nameR = left(nameL,5) it also generates the same error on Left$, Right, Right$, Mid and Mid$ I have correcteed this error by moving string manipulation to a seperate function (lefty etc) contained in a seperate module. this was the only fix. Any ideas why this has happened? Craig |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
right right$ left left$ mid mid$
Everything suggested here works fine on my system - in
fact the original code caused no errors on mine, its just when I distribute it and suddenly others in my team have this error. I tried removing the library in order to re-add it but excel claims its in use and won't allow me to uncheck the box. Getting rather confused now. any more ideas? In Hope. Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LEFT function-all to left of a comma? | Excel Worksheet Functions | |||
when inserting new worksheets they read right to left not left to. | Setting up and Configuration of Excel | |||
My Excel view is Right to Left instead of Left to Right !!! | Excel Discussion (Misc queries) | |||
Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) |