Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
permanently add reference to ADO library
Hi there
I find it a bit irritating that, every time I create a new procedure in a new workbook, I need to add a reference to the ADO object library. Is there any way that I can have this reference added permanently? Best regards Loane |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
permanently add reference to ADO library
This is not possible, because references are handled per workbook.
I would suggest the following workaround: Create a new workbook, add all your references, and save as a template to your template folder. Now create a new workbook based on your new template Dm Unseen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
permanently add reference to ADO library
Create an addin that does it for you... following will setup an application event monitor and add the reference when a NewWorkbook event is detected. '<<code for THISWORKBOOK module Option Explicit Dim WithEvents xlApp As Application Private Sub Workbook_Open() Set xlApp = Application End Sub Private Sub xlApp_NewWorkbook(ByVal wb As Workbook) Call AddAdoReference(wb) End Sub Sub AddAdoReference(ByVal wb As Workbook) wb.VBProject.References.AddFromFile _ "C:\Program Files\Common Files\System\ado\msado15.dll" End Sub -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Loane Sharp wrote : Hi there I find it a bit irritating that, every time I create a new procedure in a new workbook, I need to add a reference to the ADO object library. Is there any way that I can have this reference added permanently? Best regards Loane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to check Solver and Forms 2.0 Object Library permanently? | Excel Discussion (Misc queries) | |||
VBA Reference Library ADO 2.7 | Excel Programming | |||
Add-ins and Reference library | Excel Programming | |||
Reference Library - Missing Library in a lower version. | Excel Programming | |||
Reference Library | Excel Programming |