OLE2 question in Forms....

From: Stephen <c6635500_at_comp.polyu.edu.hk>
Date: 1997/10/31
Message-ID: <345AE0A9.5792@comp.polyu.edu.hk>#1/1

Hello all,

I want to use OLE2 to get cell values from Excel 5.0 to Form4.5 on Win3.1. Here is the code: (:global.application_id has already been declared)

   appl_name varchar(255) := 'EXCEL.APPLICATION.5';    application_id pls_integer;
   arg_list ole2.list_type;
   return_value varchar2;

:global.application_id := ole2.create_obj(appl_name); application_id := to_number(:global.application_id); arg_list := ole2.create_arglist;

   ole2.add_arg(arg_list, 'c:\excel\temp.xls');
   ole2.invoke(application_id, 'FileOpen', arg_list);
   ole2.destroy_arglist(arg_list);

The above codes are OK. However, when I appended the following codes at the end:

arg_list := ole2.create_arglist;
return_value := ole2.invoke_char(application_id, 'cell("contents",A3)', arg_list); ole2.destroy_arglist(arg_list);

It's failed. Could anyone help me how to get cell values from Excel 5.0? (I don't want to use DDL since it's more difficult to control).

Thanks,
Stephen Received on Fri Oct 31 1997 - 00:00:00 CST