This is what I have and keep gettin a runtime 1004 error.
Application.Run ("G:\Receiving\Hot Containers.xls!teresa")

"Jim Thomlinson" wrote:

Application.Run ("yourfilename.xls!yourmacroname")

--
HTH...

Jim Thomlinson


"Rpettis31" wrote:

Is there a way to activate macros from different workbooks. I have several
workbooks I update in the am and was wondering if there was a way to have an
update workbook so to speak and update all the other workbooks from the main
workbook.

Thanks