can we call a Sub in another opened vbaproject?
Tom, Chip, Bob that is a great help. Thank you
"Bob Phillips" wrote:
Use Application.Run
Application.Run "'another book2.xls'!test_msgbox"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|