VBA Right function not working in only one workbook

[Intertwyne]

I have pieced together code from others that when a ‘submit’ button is clicked, is supposed to store a copy of a pdf in the Application.DefaultFilePath.

I have 1 user that the ‘right’ function errors as: “compile error: Can't find project or library”

The error ONLY happens on the workbook I send him, if he opens a new workbook and executes the ‘right’ command in the immediate window, it works.
All other users of the exact same workbook don’t have the problem.

    If Right(Application.DefaultFilePath, 1) <> "\" Then
        DefPath = Application.DefaultFilePath & "\"
    End If

We are all using the same version of Excel, 2010 and Window 7 Enterprise version 6.1
I have confirmed we have the same library’s checked and in the same order.

Thanks
Terry Reed

 

[DocAElstein]

Hi Terry "Intertwyne",
As you are using similar Versions and have similar Libraries I am puzzled. I can tell you I had a similar problem with a code written in Excel 2013. It worked in 2010 but not 2007.
I found that the problem was that in later versions of XL, functions like Right , Mid Left etc. Went by default to a library that was not available in earlier XL versions.
Range Dimensioning, Range and Value Referencing and Referring to Arrays [SOLVED] - Page 4

The solution to the problem which always worked was to be more explicit, referencing the VBA Library, - so always use

VBA.Left
VBA.Rigtht
VBA.Mid

In place of

Left
Right
Mid

Etc.

Alan