Skip to Main Content

SQL Developer

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!

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

User_50L5NApr 11 2021 — edited Apr 11 2021

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 ?
image.png

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 9 2021
Added on Apr 11 2021
3 comments
1,211 views