Hi!

What is the code for adding a new workbook with one worksheet having a
particular name? (I want the user to save the workbook with the name of choice, but the sheet must be named by the macro).

The new workbook will subsequently be used to copy data from the workbook the user currently has opened.

I'm guessing this is really easy, just can get my head around it!

-M-