Using Ole2 to open microsoft excel from forms 4.5
From: Jurrian Kamp <J.kamp_at_Oreade.nl>
Date: Thu, 30 Dec 1999 10:38:14 +0100
Message-ID: <84i2km$cmg$1_at_porthos.nl.uu.net>
Hi there,
Date: Thu, 30 Dec 1999 10:38:14 +0100
Message-ID: <84i2km$cmg$1_at_porthos.nl.uu.net>
Hi there,
I have a problem using ole2 to open microsoft excel. I use the following (simple) code from a button on a form.
declare
xl ole2.obj_type;
wrkbks ole2.obj_type;
begin
xl:=ole2.create_obj('Excel.Application');
OLE2.SET_PROPERTY(xl, 'Visible', 'True');
- Return object handle to the Workbooks collection wrkbks:=OLE2.GET_OBJ_PROPERTY(xl, 'Workbooks'); wrkbk := ole2.get_obj_property(wrkbks, 'Workbook'); OLE2.RELEASE_OBJ(wrkbk); OLE2.RELEASE_OBJ(wrkbks); OLE2.RELEASE_OBJ(xl); end;
The problem is that however i release all object handles, an excel proces continues to be running after i close excel (which is started because of the commands). I cannot seem te figure out how to kill this proces. I am using Windows 98, but the problem also occurs on NT.
Please give me a clue !!
Grt,
Jurrian Kamp
J.Kamp_at_Oreade.nl
Oracle Application Developer
Oreade Software
The Netherlands
Received on Thu Dec 30 1999 - 10:38:14 CET