View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
OlieH OlieH is offline
external usenet poster
 
Posts: 39
Default 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