With all the experts in this forum I expected somebody to help me with
my problem. No one has so far. My code, which uses string  functions
like LEFT cannot run on other people's machines in my office.

I finally found  a solution -- I simply changed "Left" to
"Strings.Left" and the code  worked.

Now maybe someone can explain why my machine  knows that Left is part
of VBA.Strings and the other machines in the office  have to be told
specifically that Left is found in Strings?