How can I delete a recently created excel sheet using VBA

[Cmack]

I have struggled to generate a form that can be updated with a button click.
The program generates a DateTime stamp then copies the sheet to a file
My issue is that I want to delete the sheet once saved to file and return to the original but I keep getting errors (no matter which method I try).
Any advice or information pertaining to a solution is greatly appreciated.
Cheers in advance,
Cmack.

Private Sub CommandButton2_Click()
Application.CalculateFull 'sets the clock
Application.ScreenUpdating = True 'updates the screen
Dim FName As String 'declares file name

ActiveSheet.Copy 'copies original
With ActiveSheet.Range("A1") ' correct date and time
.Copy
.PasteSpecial xlValues
.PasteSpecial xlFormats

Application.CutCopyMode = False
Application.ScreenUpdating = False
End With
Application.DisplayAlerts = False 'no alerts

FName = "C:\Users\cmack\OneDrive\Desktop\Testing\" & Format(Range("A1"), "hh-MM--ss-mmm-d-yyyy") & ".xlsm"
ActiveWorkbook.SaveAs Filename:=FName, FileFormat:=xlOpenXMLWorkbookMacroEnabled 'saves the new copy (date stamped title) into folder


??????????? How to delete the newly copied sheet?????????
End Sub

 

[rlv01]

??????????? How to delete the newly copied sheet?????????

What about instead of deleting a worksheet, you close the new workbook by adding this line at the end of the sub:

ActiveWorkbook.SaveAs Filename:=FName, FileFormat:=xlOpenXMLWorkbookMacroEnabled 'saves the new copy (date stamped title) into folder
ActiveWorkbook.Close False  '<-- new line
End Sub

(Tip: For future posts , you should try to use code tags like I did above when posting your code. It makes it easier to read.)

How to Post Your VBA Code

Post your VBA code.

www.mrexcel.com

 

[Cmack]

What about instead of deleting a worksheet, you close the new workbook by adding this line at the end of the sub:

ActiveWorkbook.SaveAs Filename:=FName, FileFormat:=xlOpenXMLWorkbookMacroEnabled 'saves the new copy (date stamped title) into folder
ActiveWorkbook.Close False  '<-- new line
End Sub

(Tip: For future posts , you should try to use code tags like I did above when posting your code. It makes it easier to read.)

How to Post Your VBA Code

Post your VBA code.

www.mrexcel.com

Thank you for your support, great idea, so simple and it worked immediately, nil issues. This was my first question, not sure what a code tag is yet but I hope to get there.
Thank you for your time my friend.
Cmack

 

[Cmack]

Lol, I clicked my own reply as a solution hahahaha