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?

PHP 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 
Thanks for your precious help