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
|