View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default Transferring control from macro in one workbook to macro in anothe

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.