I have created a macro that uses the key word "Right" as in right("123456789",6) to return the right six characters of a string. The example above would return 456789.

This macro runs fine on my workstation, but when I give it to a co-worker, who has the identical setup, it fails saying it can't find a function or library.

What can I do?

Thanks in advance.

Rich

richard.mogy wrote:

I have created a macro that uses the key word "Right" as in
right("123456789",6) to return the right six characters of a string. The
example above would return 456789.

This macro runs fine on my workstation, but when I give it to a
co-worker, who has the identical setup, it fails saying it can't find a
function or library.

What can I do?

Something's wrong with your co-worker's machine -- Right (or RIGHT$) has been
in the language for at least 30 years. Reinstalling on that machine may or
may not fix it.

--
Here you go America -- you are free to do what we tell you!
You are free to do what we tell you!
-- Bill Hicks

On Wednesday, August 15, 2012 1:17:50 PM UTC-7, (unknown) wrote:
I have created a macro that uses the key word "Right" as in right("123456789",6) to return the right six characters of a string. The example above would return 456789.



This macro runs fine on my workstation, but when I give it to a co-worker, who has the identical setup, it fails saying it can't find a function or library.



What can I do?



Thanks in advance.



Rich

Your co-worker is missing one or more of the workbooks references -
remove the unknown references from the workbook on your co-workers PC,
and everything should work fine again :-)

VBE - Tools - References...


CE



Den 15.08.2012 22:17, skrev:
I have created a macro that uses the key word "Right" as in right("123456789",6) to return the right six characters of a string. The example above would return 456789.

This macro runs fine on my workstation, but when I give it to a co-worker, who has the identical setup, it fails saying it can't find a function or library.

What can I do?

Thanks in advance.

Rich