Is it possible to open an excel file in oracle forms?

User_50L5N

Hello everyone,

I'm trying to open a specific excel file in oracle forms by creating a button with a when pressed button trigger, so I learned about one of the method to do that by the following query:

DECLARE

AppID PLS_INTEGER;

BEGIN

AppID := DDE.App_Begin('C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE );

END;

but the problem is this query is opening a new empty excel sheet, so I tried to modify the query to open the specific excel file that I want and I came with this query:

DECLARE

AppID PLS_INTEGER;

BEGIN

AppID := DDE.App_Begin('C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE D:\Spools\data.xlsx',DDE.APP_MODE_MINIMIZED);

END;

but unfortunately I'm facing this message after pressing the button.

Any suggestion please ?

Jim Smith

This question is probably better suited to the forms community.

https://community.oracle.com/tech/developers/categories/forms

It is likely that wherever your form is actually running doesn't know about your D: drive.

cormaco

I'm assuming here your file is located in the D: on the server and not on the client. Of course the client can't access a file on the server.

Possible solutions are placing the file in a shared drive the client can see or transferring the file to the client using webutil.

User_50L5N

https://community.oracle.com/tech/developers/discussion/comment/16791810#Comment_16791810

Thank you sir for you reply, I tried to place both files in a shared drive but still I have the same issue.

DECLARE

AppID PLS_INTEGER;

BEGIN

AppID := DDE.App_Begin('C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE C:\forms2\data1.xlsx',DDE.APP_MODE_MINIMIZED);

END;