The syntax of both are given below

Worksheets.Add
expression.Add(Before, After, Count, Type)

Workbooks.Add
expression.Add(Template)

'You will need to loop
Dim intTemp as Integer
For intTemp = 1 to 5
Workbooks.Add
Next

If this post helps click Yes
---------------
Jacob Skaria


"Ted M H" wrote:

I'm trying to figure out the syntax / arguments to add more than one workbook
to the collection of open workbooks. Conceptually it seems this is similar
to adding multiple worksheets to a workbook where worksheets.add count:= 5
would add five worksheets. Is there any way to accomplish the same thing
with workbooks?