Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a reference programatically
I create a new workbook simply by copying a worksheet, i.e.
ActiveSheet.copy. The problen is that the sheet has subroutines that require the ADODB and so the new workbook needs to reference the Microsoft ActiveX Data Objects Library. I know I can add that reference to the new workbook using Tools:References from the main menu but how can I add that reference to the new workbook programmatically. Thanks for any help, Fred |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding VB code to worksheet programatically | Excel Programming | |||
Adding a Control programatically | Excel Programming | |||
default references or adding programatically | Excel Programming | |||
Programatically adding worksheets to a spreadsheet | Excel Programming | |||
Adding components to multipage programatically | Excel Programming |