Thread: Calling a sub from a different workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default Calling a sub from a different workbook
application.run "Myotherworkbook.xls!Mymacro"

assumes the other workbook is open.

--
Regards,
Tom Ogilvy



"jdcox1999" wrote:

How can I call a subroutine that is in another workbook, without using
a menu option?


Reply With QuoteReply With Quote