Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to create a set of VB statements that will set the object references
required for my VBA code, such as, for the following, Visual basic for applications Microsoft Excel 11.0 Object Library OLE Automation Microsoft Office 11.0 Object Library Microsoft Project 11.0 Object Library Microsoft ActiveX Data Objects 2.8 Library Microsoft ActiveX Data Objects Recordset 2.7 Library Have them compiled to .exe and then call it at the start of my VBA code. This is to create the references without the user having to do it themselves. I suppose it would be necessary to check whether the refernces are already set, if so then skip this step. Can someone please show me a few lines of, how to do this. Thanks, -- Sajit |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell references in excel vba code | Excel Discussion (Misc queries) | |||
Help with VBA code - passing references to sheets? | Excel Programming | |||
Line of Code to set references | Excel Programming | |||
Code that references the name of a cell | Excel Programming | |||
Code to change references | Excel Programming |