Newest version of UFT for Feb. 10th 2019

14.51

Advertisements

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

MS Script Debugger missing – solved

When installing QTP/UFT you select to install Microsoft Script Debugger.

Now MS removed it from their site.

see here for solution (download and install it manually)

http://www.learnqtp.com/ms-script-debugger-error-uft/

the file name is scd10en.exe/zip so you can search for it yourself.