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.
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.
VBA Code:
'***save file under specified name***
Set wkBk = Workbooks.Add
ThisWorkbook.Sheets("New Data").Copy
wkBk.SaveAs "H:\documents\SaveNewFolder\FUT_" & dTod & "." & "xls"""