delete old file and create new file vba

[pakilprogramador]

how do you can delete the old workbook excel and create a new one with their latest amendments with macro.vba

 

[Abhiishek]

Hi Pakil,

To delete old workbook . use it

Sub dltfile()
Kill "C:\Users\Amit\Desktop\Sample-File.xlsm"
End Sub

but last line to create a new one is not clear. what amendments . do you want all sheets to be copied in new workbook. please give more details

Thanks,
Abhishek Srivastav