How to use workbook.saveas with automatic Overwrite

by

To hide 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)

More Related Contents:

  1. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  2. filter out multiple criteria using excel vba
  3. Cannot VBA write data to cells in Excel 2007/2010 within a function
  4. Excel error 1004 “Unable to get …. property of WorksheetFunction class” appearing inconsistently
  5. Find last row in range
  6. Excel: the Incredible Shrinking and Expanding Controls [closed]
  7. Excel VBA Run-time error ’13’ Type mismatch
  8. VBA Excel – IFERROR & VLOOKUP error
  9. How does one restore default case to a variable in VBA (Excel 2010)?
  10. Excel VBA Run-time Error ‘32809’ – Trying to Understand it
  11. Print function selecting wrong Type of Change option excel vba
  12. Format Cell Contents
  13. Excel formula checklist in employees
  14. How do I put double quotes in a string in vba?
  15. What is the difference between .text, .value, and .value2?
  16. How can I URL encode a string in Excel VBA?
  17. VBA rounding problem
  18. How to call a macro from a button and pass arguments
  19. Obtain attribute names from XML using VBA
  20. Paste Excel range in Outlook
  21. VBa conditional delete loop not working
  22. Update excel sheet based on outlook mail [closed]
  23. Export chart as image – with click of a button
  24. Error13 in Excel VBA in data file
  25. Excel cell from which a Function is called [duplicate]
  26. How to extract text within a string of text
  27. Application.WorksheetFunction.Match method
  28. Excel Hide/Show all tabs on Ribbon except custom tab
  29. Macros Not Showing Up in Macro Table
  30. Excel telling me my blank cells aren’t blank

Leave a Comment