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
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
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" <[email protected]> wrote in message
news:[email protected]...
>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
look in VBA help at the RUN command.
--
Regards,
Tom Ogilvy
"MVM" <[email protected]> wrote in message
news:[email protected]...
> 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
Use Application.Run
Application.Run "'another book2.xls'!test_msgbox"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"MVM" <[email protected]> wrote in message
news:[email protected]...
> 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
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks