| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import a CodeModule then call its method in Workbook_Open()
I have a Module called "CodeFile.bas" which i Share amongst several
workbooks - It has a method called KickStart() I want to do something like the following: Private Sub Workbook_Open() Me.VBProject.VBComponents.import "c:\CodeFile.bas" Call KickStart() End Sub i.e. Import the code file and then subsequently call one of its methods. Any ideas how I could achieve this effect. Dickster |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I call up the Text Import Wizard via a macro. | Excel Worksheet Functions | |||
| call multiple macros in workbook_open? | Excel Programming | |||
| GetObject method not work after Call Shell Method | Excel Programming | |||
| How do I call a method in VB from Excel with JUST code? | Excel Programming | |||
| How do I call a method in VB from Excel with JUST code? | Excel Programming | |||
Threaded Mode
