String manipulation error

[wlaflamme]

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

 

[msmith]

I'll give you the "standard" answer but this may or may not be the problem.

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

 

[wlaflamme]

Thanks. That was it!!!