B
billy
Hi,
I have a macro in book1 (just a test macro)
sub test()
Sheets("Sheet1").Range("A1") = "this is a test"
End Sub
But I want to run this macro from book2. Here is what I
tried that did not work from book2
Sub runMacro()
Dim bk As Workbook
Set bk = Workbooks.Open(ThisWorkbook.Path & "\book1.xls")
bk.Application.Run "Test"
End Sub
I get the error message that it can't find "Test". Could
someone share the correct syntax for this?
Thanks
I have a macro in book1 (just a test macro)
sub test()
Sheets("Sheet1").Range("A1") = "this is a test"
End Sub
But I want to run this macro from book2. Here is what I
tried that did not work from book2
Sub runMacro()
Dim bk As Workbook
Set bk = Workbooks.Open(ThisWorkbook.Path & "\book1.xls")
bk.Application.Run "Test"
End Sub
I get the error message that it can't find "Test". Could
someone share the correct syntax for this?
Thanks