Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and Trim
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and Trim
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. -- Regards, Tom Ogilvy "Jake" wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim | Excel Worksheet Functions | |||
TRIM Help ! | Excel Discussion (Misc queries) | |||
Trim help please | New Users to Excel | |||
VBA Trim and Application.worksheetfunction.Trim | Excel Programming | |||
Trim like worksheet Trim | Excel Programming |