View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andyjim Andyjim is offline
external usenet poster
 
Posts: 70
Default Transferring control from macro in one workbook to macro in an

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.