String manipulation error
String manipulation error
(OP)
Hello,
I am having trouble with a string manipulation. I know this works on my computer but when I bring it to another computer to perform the string manipulation it displays an error message. Here is the callout
bufferin2 = Left(Right(bufferin1, 8), 6)
Here is the error message:
Compile Error
Can't find project or library.
Ant recommendations
I am having trouble with a string manipulation. I know this works on my computer but when I bring it to another computer to perform the string manipulation it displays an error message. Here is the callout
bufferin2 = Left(Right(bufferin1, 8), 6)
Here is the error message:
Compile Error
Can't find project or library.
Ant recommendations





RE: String manipulation error
In the VBE, select Tools|References. In the dialog that displays you should see something like the following libraries checked (these are the minimum libraries that should be present):
Visual Basic For Applications
Microsoft Excel x.x Object Library
OLE Automation
Microsoft Office x.x Object Library
where x.x depends on the versions of Office & Excel (for Office 2000 this is 9.0).
The Left & Right string functions are in the Visual Basic For Applications library.
Look specifically for any library that is prefaced with the word MISSING
Hope this helps,
Mike
RE: String manipulation error