Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
spawn a vba program from with VBA
I wish to spawn a workbook (which contains auto macros) from within a VBA
program and allow the first VBA progrma to ontinue to exeuite. All help is greatly appreciated, thanks Olie H |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
spawn a vba program from with VBA
Hi Olie,
To create the workbook, try: Workbooks.Add To add the required code, see Chip Pearson's page on programming in the VBE: http://www.cpearson.com/excel/vbe.aspx --- Regards. Norman "OlieH" wrote in message ... I wish to spawn a workbook (which contains auto macros) from within a VBA program and allow the first VBA progrma to ontinue to exeuite. All help is greatly appreciated, thanks Olie H |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
spawn a vba program from with VBA
Norman, thanks for the response. I have already created both workbooks, each of which have macros in them. I envoke the second workbook from the first. The focus goes to the second WB only; I want to continue execution of both WBs at the same time. Thanks for all help. "Norman Jones" wrote: Hi Olie, To create the workbook, try: Workbooks.Add To add the required code, see Chip Pearson's page on programming in the VBE: http://www.cpearson.com/excel/vbe.aspx --- Regards. Norman "OlieH" wrote in message ... I wish to spawn a workbook (which contains auto macros) from within a VBA program and allow the first VBA progrma to ontinue to exeuite. All help is greatly appreciated, thanks Olie H |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
spawn a vba program from with VBA
Hi Olie,
============ I have already created both workbooks, each of which have macros in them. I envoke the second workbook from the first. The focus goes to the second WB only; I want to continue execution of both WBs at the same time. ============ If both workbooks exist and are open, I do not see your problem: VBA can happily operate on any open workbook. What, specifically, do you wish to do, and what problems are you experiencing? --- Regards. Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
My Program | Charts and Charting in Excel | |||
Spawn Add Printer Wizard from Hyperlink | Excel Programming | |||
Program to add a row? | Excel Programming | |||
merging excel program with tdc finance program | Excel Programming |