Copy Range from one worksheet;Paste into new workbook

Can anyone help me with the code below?

My goal here is to copy a worksheet and paste it into a new workbook. Subsequently I would like a save as dialogue box to pop up where I name the file and save as a CSV. I'm just not sure how to go about creating the new workbook and then pasting my data into it.

When I use workbooks.add, can I name the workbook and then refer it?

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Look at the worksheet.move method instead of trying to copy and paste everything.