ExcelBanter - View Single Post - Transferring control from macro in one workbook to macro in anothe

Andyjim

Thanks Nigel. That worked!

"Nigel" wrote:

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

--

Regards,
Nigel

"Andyjim" wrote in message
...
I am including the entire macro, but it is the last 3 lines that I am
concerned about. Basically, by the time the macro gets to that point, 2
workbooks are open. I am running the macro from the User workbook. But I
want to go to the module in the Dev workbook and use the Update3 macro in.

When I now run the macro, the error states that it can't find Update3
(which
is in the Dev file.

How do I tell Excel to go the the module in Dev file that has Update3?

Thanks much.