How to open Excel Application from Mac
TobiasMay 13 2008 — edited May 13 2008Hi!
We use following code for opening Excel on windows (forms 10GR2).
Found note: 361798.1 on metalink.
MAC OS does not use .dlls so any webutil functionality that relies on d2kwut60.dll, Jacob.dll will not work on MAC. Primarily this affects the OLE functionality.
Is it possible to get it to work on Mac, or any suggustions how to open an excel-document on mac in Forms.
PROCEDURE open_document(p_document IN VARCHAR2) IS
application Client_OLE2.Obj_Type;
workbooks Client_OLE2.Obj_Type;
args Client_OLE2.List_Type;
BEGIN
application := Client_OLE2.create_obj('Excel.Application');
Client_OLE2.SET_PROPERTY(application, 'Visible', 1);
workbooks := Client_OLE2.Get_Obj_Property(application, 'Workbooks');
args := Client_OLE2.Create_Arglist;
Client_OLE2.Add_Arg(args,p_document);
Client_OLE2.Invoke(workbooks, 'Open', args);
Client_OLE2.Destroy_Arglist(args);
Client_OLE2.Release_Obj(workbooks);
Client_OLE2.Release_Obj(application);
END;
Regards
Tobias