Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to open Excel Application from Mac

TobiasMay 13 2008 — edited May 13 2008
Hi!

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2008
Added on May 13 2008
1 comment
427 views