Thread: can we call a Sub in another opened vbaproject?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default can we call a Sub in another opened vbaproject?
You can use Application.Run to do this. E.g,

Application.Run "Book1.xls!MacroName"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"MVM" wrote in message
...
I have a workbook. Program copies one sheet and creates another
workbook.
this second workbook need to use a Sub in the module of the
parent book. Is
it possible? If it is, how?
Thanks
MVM


Reply With QuoteReply With Quote