Xref: alice comp.databases.oracle.tools:25487
Path: alice!news-feed.fnsi.net!netnews.com!news-peer-europe.sprintlink.net!news.sprintlink.net!news.algonet.se!algonet!masternews.telia.net!newsb.telia.net.POSTED!not-for-mail
Message-ID: <374C3FF6.80BC7639@lund.mail.telia.com>
From: plant.eng@lund.mail.telia.com
X-Mailer: Mozilla 4.04 [en] (Win95; I)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: OLE2 & Excel
References: <37440B3B.8353C6C7@boeing.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 32
Date: Wed, 26 May 1999 18:39:39 GMT
X-Complaints-To: abuse@telia.com
X-Trace: newsb.telia.net 927743979 195.67.194.132 (Wed, 26 May 1999 20:39:39 CEST)
NNTP-Posting-Date: Wed, 26 May 1999 20:39:39 CEST
Organization: Telia Internet

Hi.
Can you tell me how did you get Excel working at all?
I am fighting with getting Excel visible from Forms 5 using the code from:
WIN:OLE AUTOMATION GUIDE-ORACLE FORMS TO MICROSOFT EXCEL

DECLARE
 application OLE2.OBJ_TYPE;
BEGIN
 application:=OLE2.CREATE_OBJ('Excel.Application');
 OLE2.SET_PROPERTY(application, 'Visible', 'True');
END;

At this stage the spreadsheet should be visible, but it is not.

Any help apretiated.

Regards Tony.

Howard Porter wrote:

> I seem unable to get Excel columns to automatically format based on the
> width of the data passed from Oracle.  I have tried various combinations
> of Range and AutoFit and nothing works.
>
> Any ideas?
>
> Thanks.
>
> Howard