have you tried to prefix the method with the name of the library? I remember having to do that a couple of time in a previous life!

strPath = VBA.Left(strFile, intLeft)

>I'm getting a compilation error in an Access app:
>
>

>---------------------------
>Microsoft Visual Basic
>---------------------------
>Compile error:
>
>Can't find project or library
>---------------------------
>OK   Help   
>---------------------------
>

>
>The word 'Left' on this line is highlighted:
>
>

>strPath = Left(strFile, intLeft)
>

>
>When I click OK, the References dialog comes up with "Microsoft OLE DB provider for for OLAP services connection dialog" highlighted. The location of the DLL is correct - the file is there.
>
>Anyone know what this is all about?