Saving specific sheet as new workbook

[Adar123]

Hi all,

I am trying to save the sheet "New Data" (not an active sheet) in an active workbook as a new workbook and clear the sheet "New Data" after that.

The code I wrote clearly does not work. Tried a few methods...appreciate help. Thank you.

'***save file under specified name***
    Set wkBk = Workbooks.Add
    ThisWorkbook.Sheets("New Data").Copy 
    wkBk.SaveAs "H:\documents\SaveNewFolder\FUT_" & dTod & "." & "xls"""

 

[Fluff]

You're welcome & thanks for the feedback.