When I choose to add a reference to VBA code (ie: ADO 2.7 library, etc.),
does that reference stick with the macro as it is opened on other machines?
Is it like the "include" statement at the top of a C program?
--
Adios,
Clay Harryman

"Clayman" wrote:

When I choose to add a reference to VBA code (ie: ADO 2.7 library, etc.),
does that reference stick with the macro as it is opened on other machines?
Is it like the "include" statement at the top of a C program?

It stays with the workbook. There is nothing visibly added to the macro
like an include so you can't select all the text and paste it into another
workbook and have the reference automatically transfer.

Peter