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