Commondialog1.Flags = & H2 If the dialog box is saved, it will give the user prompt file already
If it is determined whether the user clicks cancel, there are two ways. One is to enable cancellation errors!
Second, CommonDialog1.FileName = ""
Each time it is used
Filter Filter = "Excel file | * .xls"