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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

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,197 views