Thread: VBA References
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
barnabel barnabel is offline
external usenet poster
 
Posts: 119
Default VBA References



"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