| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can we call a Sub in another opened vbaproject?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can we call a Sub in another opened vbaproject?
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| stop excel file opened as read only if already opened by another u | Excel Programming | |||
| Event to call before a opened workbook is recalculated | Excel Programming | |||
| Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
| How to see if the opened workbook is opened by another user ? | Excel Programming | |||
Linear Mode
