Is it possible to call a workbook2 sub from workbook1 in EXCEL VBA?

[vladk]

If it is possible then how?

Thanks

 

[VBArt]

Vladk,
Yes it is possible. Define your sub as public in book2:
Public Sub msg()
MsgBox ("This is Book2&quot
End Sub

Then call it from your other workbook like this:
Public Sub test()
Call Workbooks("book2.xls&quot.msg
End Sub

VBArt

 

[vladk]

VBArt;
Thank you very much for your responce. I will use your way in my workbooks.

I found alternative approach to do this. If you are interested in please take a look:

The following Sub procedure assumes that the workbook ExcelFile.xls contains a macro called "TestMacro."

Sub XLTest()
Dim XL as Object

Set XL = CreateObject("Excel.Application&quot

XL.Workbooks.Open "C:\My Documents\ExcelFile.xls"

' If there is more than one macro called TestMacro,
' the module name would be required as in
'
' XL.Run "Module1.TestMacro"
'
' to differentiate which routine is being called.
'
XL.Run "TestMacro"

End Sub

Thank you again

Vlad