calling a module

[chris2727272727]

how do you go about calling a module that is not in the workbook that you are using ie one that is in another book

 

[joelnichols]

If you open both workbooks you can see all the macros in each book. Were you going to make a button and assign the macro or simply call the macro in code?

 

[chris2727272727]

call

call the macro in code

 

[Norie]

Could you give us some more information?

 

[Jaafar Tribak]

Try the Run Method as follows :

Sub Source_Macro()
    Application.Run "TergetWB.xls!Target_Macro"
End Sub

Where TargetWB is the name of the WorkBook housing the called Macro.

 

[vane0326]

You could use a inputbox.

 Sub Module()
    Dim VBComp As VBIDE.VBComponent
    Dim Module As String
    On Error Resume Next
    Module = InputBox("Put Module Name")
    Application.ActiveWorkbook.VBProject.VBComponents.Import ("C:\Documents\" & Module & ".bas")
    If Err = "53" Then
        MsgBox "Module does not exist!"
    End If
     
End Sub