View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default can we call a Sub in another opened vbaproject?

look in VBA help at the RUN command.

--
Regards,
Tom Ogilvy

"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