Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Question Unanswered: Opening Excel file from Oracle Forms

    How can I set up an Oracle forms 6.0.5 in order to open an Excel file within it?

    Thank you very much.

  2. #2
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: Opening Excel file from Oracle Forms

    Originally posted by garlotto
    How can I set up an Oracle forms 6.0.5 in order to open an Excel file within it?

    Thank you very much.

    Hi,
    To launch an Excel file from Oracle Forms, you have to
    use DDE (Dynamic Data Exchange) package in forms.
    Look into the Documentation and it has methods and
    examples to work on.
    nn

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    Use this code in your Forms trigger:

    declare
    obj_excel OLE2.OBJ_TYPE;;
    obj_workbooks OLE2.OBJ_TYPE;;
    arg_sheets OLE2.LIST_TYPE;;

    begin
    obj_excel := OLE2.CREATE_OBJ('Excel.Application');;
    arg_sheets := OLE2.CREATE_ARGLIST;;
    OLE2.ADD_ARG(arg_sheets, :control.filespec);;
    obj_workbooks := OLE2.INVOKE_OBJ(obj_excel, 'Workbooks');
    OLE2.INVOKE(obj_workbooks, 'Open', arg_sheets);;
    :global.obj_excel := to_char(obj_excel);;
    end;


    Hope that helps,

    clio_usa - OCP - DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •