excel vba saveas force overwrite

The solution for “excel vba saveas force overwrite” can be found here. The following code will assist you in solving the problem.

Set xls = CreateObject(“Excel.Application”)
xls.DisplayAlerts = False
Set wb = xls.Workbooks.Add
fullFilePath = importFolderPath & “\” & “MyFile.xlsx”
wb.SaveAs fullFilePath, AccessMode:=xlExclusive, _
wb.Close (True)

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts