Forum Discussion
ASV
12 years agoContributor
This code is in VBScript. If you use Sys.OleObject("Excel.Application") write in this way
Set objExcel = Sys.OleObject("Excel.Application")
objExcel.Workbooks.Open(strPathExcel)
.............................................................................
objExcel.DisplayAlerts = False
objExcel.ActiveWorkbook.SaveAs(strPathExcel)
objExcel.Quit
Set objExcel = Nothing
If you use DDT.ExcelDriver
Set excelData = DDT.ExcelDriver(strPathExcel, sheetname)
..........................................................................................
DDT.CloseDriver(excelData.Name)
Set objExcel = Sys.OleObject("Excel.Application")
objExcel.Workbooks.Open(strPathExcel)
.............................................................................
objExcel.DisplayAlerts = False
objExcel.ActiveWorkbook.SaveAs(strPathExcel)
objExcel.Quit
Set objExcel = Nothing
If you use DDT.ExcelDriver
Set excelData = DDT.ExcelDriver(strPathExcel, sheetname)
..........................................................................................
DDT.CloseDriver(excelData.Name)