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

Here's an idea....

Forget the ole stuff for excel and simply write a .CSV file. Excel will read it in directly as it's a builtin association and a lot less hassle.

"nthai" <nthai_ks_at_yahoo.com> 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 Fri Feb 01 2002 - 03:37:44 CET