Copy Bot Killer Notes tests. ByVal ByRef Application.Run.OnTime Multiple Variable Arguments ByRef ByVal

[DocAElstein]

An answer I had difficulty posting here: http://www.vbaexpress.com/forum/show...141#post426141

---

Hi
Another possibility.

Download both files, - put them anywhere as long as they are in the same place.
Just open FileToRunMacroInOtherFile.xls ( leave OtherFileWithSubMakeFinalVendorsInIt.xls closed )

Now run this macro which is in FileToRunMacroInOtherFile.xls

 Sub AppRunSubMakeFinalVendorsInOtherFile() ' http://www.vbaexpress.com/forum/showthread.php?72087-Error-while-trying-to-run-a-macro-using-a-selected-workbook
 Application.Run macro:="'" & ThisWorkbook.Path & "\" & "OtherFileWithSubMakeFinalVendorsInIt.xls" & "'" & "!'Modul1.MakeFinalVendors'"
End Sub 

That should cause the other file to open, and the macro in it , Sub MakeFinalVendors() , should run

( If you had both files open, the effect would be the same – running Sub AppRunSubMakeFinalVendorsInOtherFile() should make Sub MakeFinalVendors() run )

Alan