Been following the OLE2 Excel threads hoping for help with a similar problem involving manipulating an OLE2 embedded spreadsheet.
Trying to insert values in an embedded excel spreadsheet with an excel chart. Once one gets a handle to the OLE2 automation object, the GET_OBJECT_PROPERTY call for handles to the Workbooks, or other lower properties all fail.
Starting with:
obj_hnd := get_interface_pointer('graph01');
activate_server('graph01');
with graph01 being the ole2 container name, a handle value seems to be returned but using it in a statement like:
workbooks := OLE2.GET_OBJ_PROPERTY obj_hnd, 'workbooks');
just fails.
Docs state that obj_hnd should be a valid ole2.ole_type handle to the spreadsheet embedded in the chart01 ole container but behavior indicates perhaps otherwise?
Glad for any help.
Trying to insert values in an embedded excel spreadsheet with an excel chart. Once one gets a handle to the OLE2 automation object, the GET_OBJECT_PROPERTY call for handles to the Workbooks, or other lower properties all fail.
Starting with:
obj_hnd := get_interface_pointer('graph01');
activate_server('graph01');
with graph01 being the ole2 container name, a handle value seems to be returned but using it in a statement like:
workbooks := OLE2.GET_OBJ_PROPERTY obj_hnd, 'workbooks');
just fails.
Docs state that obj_hnd should be a valid ole2.ole_type handle to the spreadsheet embedded in the chart01 ole container but behavior indicates perhaps otherwise?
Glad for any help.