Qs about OLE automation (MS excel)

From: Steve Cormier <scormier_at_idirect.com>
Date: Wed, 8 Sep 1999 10:45:14 -0400
Message-ID: <6GuB3.19062$m7.282786_at_quark.idirect.com>

I create OLE container spreadsheet in the Form 5.0. In the OLE container, I insert MS excel worksheet object. into container, I try to access cells in the excel spread sheet. I always get the error message which raises unhandled exeception ORA- 305500. Does anybody have any idea? Any suggestion is appreciated!

Enclosed is my code.

Thanks!

---

Katherine

Kweng_at_yahoo.com

   declare

      d     ole2.obj_type;
      c     ole2.obj_type;
      n     number;
      lst   ole2.list_type;

   BEGIN
      if not forms_ole.server_active('spreadsheet') then
         formS_ole.activate_server('spreadsheet');
         obj_hnd := forms_ole.get_interface_pointer('spreadsheet');
      end if;

      lst := ole2.create_arglist;
      ole2.add_arg(lst, trow);
      ole2.add_arg(lst, col);

      c := ole2.invoke_obj(d, 'Cells', lst);
      ......

   END; Received on Wed Sep 08 1999 - 16:45:14 CEST