Re: The way to create a Excel file from form runtime

Hiya,

Its a known Oracle bug, you should get an oracle error ORA-305500 with your current code.
You may want to use the following instead.

workbooks := OLE2.GET_OBJ_PROPERTY(APPLICATION, 'WORKBOOKS');

Check MetaLink at www.oracle.com in the support section for more details.

HTH, M

nthai_ks_at_yahoo.com (nthai) wrote in message news:<1010982932.634479_at_proxy.storm.co.za>...
> Please tell me the way to create a Excel and transfer data from Form
> runtime to Excel file. I user to OLE2 object:
>
> application:= ole2.create_obj('Excel.Application');
> workbooks := ole2.invoke_obj(application, 'Workbooks');
>
> -- Open the required workbook
> args:= ole2.create_arglist;
> ole2.add_arg(args, 'C:\EXAMPLE.XLS');
> workbook := ole2.invoke_obj(workbooks, 'Open', args);
> ole2.destroy_arglist(args);
>
>
> But it always diplay error at command:
> workbooks := ole2.invoke_obj(application, 'Workbooks');
>
> My Form is Form 6ir2 and my Excel is XP.
>
> Thanh you very much.
>
> Posted via www.orafocus.com - Focusing on the World of Oracle
Received on Tue Jan 15 2002 - 10:04:52 CET