How to use Excel workbook.saveas with automatic overwrite

excelObject.DisplayAlerts = False

Set excelObject = CreateObject("Excel.Application")    
excelObject.DisplayAlerts = False
Set wb = excelObject.Workbooks.Add
fullFilePath = importFolderPath & "\" & "A.xlsx"

wb.SaveAs fullFilePath, AccessMode:=xlExclusive,ConflictResolution:=Excel.XlSaveConflictResolution.xlLocalSessionChanges    
wb.Close (True)

 

 

 

https://stackoverflow.com/questions/14634453/how-to-use-workbook-saveas-with-automatic-overwrite

Advertisements

Insight Object tips

simple differences in the image like colored pixels or lines may make a difference. Add/Set the “similarity” property and set the value to 60 for example this will ignore minor differences.

https://community.softwaregrp.com/t5/Unified-Functional-Testing-User/lt-UFT-Support-Tip-gt-How-to-Reuse-an-Insight-Object/td-p/555354