Re: OLE2 & Excel

Hi,

Don't know if you're interested but I've coded an app the other way around. Embed Oracle into Excel. I've even written an article about it so you can read how you can do something like this.

Please have a look at Oraxcel - my Oracle to Excel bridge - at

http://members.aol.com/gjlinker

Regards, Gerrit-Jan

plant.eng_at_lund.mail.telia.com wrote in message [Quoted] <374C3FF6.80BC7639_at_lund.mail.telia.com>...
>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
>
>
>
Received on Sun Jun 13 1999 - 14:52:48 CEST