Hi
I've tried this code which some experts suggested me but it's run the new file with specific path.
but new file is contain all sheet ("button" & "data")which actually, i want to split only "data" sheet and to save as new file name for "data" sheet.
Please suggest that i'm wrong for which code.
Sub SaveSheets() LValue = Format(Date, "dd-mm-yyyy") Sheets("data").Select Sheets("data").Copy ActiveWorkbook.SaveAs Filename:="D:\test\" & "NAME_" & LValue & ".xlsx", _ FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False End Sub
Bookmarks