Hello,
I have a problem to find a solution on that point.
I would like to have all my macro on file1 and to execute them on file2, so I use Application.Run, it works fine with 1 macro, but if I put a second one it's not working.
What could be wrong with the following code?
Thanks for your precious helpPHP Code:
Sub ExternalCall()
Dim strFile As String
strFile = "P:\Office\Excel\tests excel\test.xlsx"
Workbooks.Open strFile
Application.Run "'macro open file.xlsm'!Lowercase"
Application.Run "'macro open file.xlsm'!DeleteRowCriteria"
Application.Workbooks("test.xlsx").Save
Application.Workbooks("test.xlsx").Close
End Sub
Bookmarks