saveas java,如何使用自动覆盖的workbook.saveas

In this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?"

Application.DisplayAlerts = False

Set xls = CreateObject("Excel.Application")

Set wb = xls.Workbooks.Add

fullFilePath = importFolderPath & "\" & "A.xlsx"

wb.SaveAs fullFilePath, AccessMode:=xlExclusive, ConflictResolution:=True

wb.Close(True)

Why does db.SaveAs always prompt me to overwrite existing file if I have DisplayAlerts = False ?

Thanks in advance!

解决方案

To not see the prompt set xls.DisplayAlerts = False

ConflictResolution is not a true or false property, it should be xlLocalSessionChanges - note that this has nothing to do with displaying the Overwrite prompt though!

Set xls = CreateObject("Excel.Application")

xls.DisplayAlerts = False

Set wb = xls.Workbooks.Add

fullFilePath = importFolderPath & "\" & "A.xlsx"

wb.SaveAs fullFilePath, AccessMode:=xlExclusive,ConflictResolution:=Excel.XlSaveConflictResolution.xlLocalSessionChanges

wb.Close (True)