ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA References (https://www.excelbanter.com/excel-programming/393600-vba-references.html)

Clayman

VBA References
 
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

barnabel

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


All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com