I have created a workbook which is 2 sheets a template worksheet and then some
parameters and a vba button.

I have been able to create the copy and customising of a each new sheet based on
a template successfully.

The next step I am unsure of how I can control (ie the correct vba commands) I
now wish to do the same task but create a new workbook (which i have done).

1) How do I refer to the new workbook via the vba code?
2) How do I copy between the first workbook and the new workbook?

This is to ensure that the new workbook doesn't have the macros and code in it
and thus will not will require certificate or anything special for users to use
it.

It's more a lack of syntax than a programming issue so hopefully someone can
point me in the right direction.