View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gdick@kerrhenderson.com is offline
external usenet poster
 
Posts: 3
Default 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