VBA and Trim

[Jake]

When developing my macro I use a workstation with VB installed on it,
but when I send the macro to my boss without VB installed, he gets an
error on the trim function. Does anyone have any ideas on this? Or
seen it before?

Thanks,
Jake

 

[Tom Ogilvy]

On your Boss's machine, after the error, go into the vBE.

reset,
Then select you project in the project explorer so it is the active project

then go into Tools=>References. You should see at least one item listed as
MISSING

this means you have a reference in your workbook that your boss does not
have access to. IF you don't need this reference (or references marked as
MISSING), go back to your machine and unselect these references in your copy
of the workbook. Then save and send back to your boss.

If you do need them, you will need to install and register these items on
your boss's computer.