The way to create a Excel file from form runtime

From: nthai <nthai_ks_at_yahoo.com>
Date: 14 Jan 2002 04:35:32 GMT
Message-ID: <1010982932.634479_at_proxy.storm.co.za>

[Quoted] 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 Mon Jan 14 2002 - 05:35:32 CET