Xref: alice comp.databases.oracle.tools:37917
Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!news-MUC.ecrc.net!newsfeed.tli.de!newsfeed2.news.nl.uu.net!sun4nl!newsfeed0.news.nl.uu.net!not-for-mail
From: "Jurrian Kamp" <J.kamp@Oreade.nl>
Newsgroups: comp.databases.oracle.tools
Subject: Using Ole2 to open microsoft excel from forms 4.5
Date: Thu, 30 Dec 1999 10:38:14 +0100
Organization: Oreade
Lines: 36
Message-ID: <84i2km$cmg$1@porthos.nl.uu.net>
X-Trace: porthos.nl.uu.net 946638294 13008 193.79.43.195 (31 Dec 1999 11:04:54 GMT)
X-Complaints-To: abuse@nl.uu.net
NNTP-Posting-Date: 31 Dec 1999 11:04:54 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

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@Oreade.nl
Oracle Application Developer
Oreade Software
The Netherlands