From: nazar@msn.com (Kipitin)
Subject: Q! OLE2 Automation and MS Excel.
Date: 1996/12/20
Message-ID: <59eocs$b66@clark.zippo.com>#1/1
followup-to: comp.databases.oracle.misc
organization: OITC
reply-to: nazar@msn.com
newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools




Hello all,


I've been trying, with no success, to start up Excel from whithin a Forms 4.5 
PL/SQL application. Oracle's Online Books and Help offer little help.

What I basically want is to startup Excel and Insert a few rows of data. 
Online help offers a few sketchy examples. I've tryied
        
        declaration
                xl OLE2.OBJ_TYPE;
        begin
                xl := OLE2.ACTIVATE_OBJECT('Excel.Application.5');
                ....

and all that. Anybody know of how to make Excel visible? Has anybody come 
accross any refrences on how to translate Excel's Visual Basic into PL/SQL?

Any help would be greatly appreciated and I thank all in advance.  



Naz.