DF-19, Win-10
I'm using cmdExcel.pkg and EXCEL12.pkg, both provided here by Matt Davidian. I'm creating and populating a spreadsheet and that part works fine.
During the population of the spreadsheet I'm doing the following and the line "Set SetBold of hoExcel True" throws the error shown below because phDispatchDriver = 0.
Code:
Send InitializeExcel to hoExcel ""
Send NewSpreadSheet of hoExcel
Move (SizeOfArray(saResults)) to iMaxRows
Move (SizeOfArray(saResults[1])) to iMaxCols
Move 7 to iCounter
Move 1 to iStartRow
// excel body
For iRow from iStartRow to iMaxRows
For iCol from 1 to (iMaxCols - iStartingColumn)
Set Cell of hoExcel iRow iCol to saResults[(iRow-iStartRow)][(iCol-1 + iStartingColumn)]
If (iRow = iStartRow) Send SetBold of hoExcel True // errors
Loop
Loop
Send SaveSpreadSheetAs of hoExcel sFilename C_XLSX_FORMAT
Send DeInitializeExcel to hoExcel
The line that blows up is here, "Set comProperty..."
Any ideas as to why phDispatchDriver is 0?
Code:
Procedure Set ComBold Boolean value
Set ComProperty of (phDispatchDriver(Self)) 3 OLE_VT_BOOL to value
End_Procedure
Invalid message. SET_COMPROPERTY
Error: 98
SET_COMBOLD (9887) - oObject (180) - at address 70877
MSG_SETBOLD (14239) - oExcelExport (156) - at address 118142
MSG_EXPORT_TO_EXCEL (15424) - oClientArea (145) - at address 134365
MSG_EXPORT_TO_EXCEL (15424) - oReportTelemetry (157) - in native code