Folks,
I wrote some VBA code to save files with a certain naming convention. However, the overwrite warning is not showing up and I would like it to. Below is my code. Thanks!
I wrote some VBA code to save files with a certain naming convention. However, the overwrite warning is not showing up and I would like it to. Below is my code. Thanks!
Code:
'save as dialog
Dim fname As String
fname = "Wafer " & WID & ".Ellpis." & ReadType & "." & Format(Date, "yyyy.mm.dd")
Application.DisplayAlerts = True
Application.Dialogs(xlDialogSaveAs).Show "\\ccesdtwo\Wafer Processing\Ellipsometer - Reports\" & fname & ".xlsx"
ActiveWorkbook.Close