Run code from another workbook
I was unable to copy the macro from the site so I typed it in here and I made a typo.
This is NOT the typo I mentioned in previous post.
Sub CallCodeFromAnotherWorkbook()
Application.Run "AnotherWorkbook.xls"!OtherMacro
End Sub
Miss placed the second "
Sub CallCodeFromAnotherWorkbook()
Application.Run "AnotherWorkbook.xls!OtherMacro"
End Sub
Howard
|