Overwrite Warning Not Showing Up

Demni009

New Member
Joined
Mar 5, 2014
Messages
22
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!

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
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,100,138
Messages
5,472,742
Members
406,834
Latest member
RahafKh

This Week's Hot Topics

Top