How to open excel file from D2K application

Hi,

1) Can someone help me to open excel file from D2K Application. Need open the file and need to populate details into table.
2) How to include excel template in D2K application.

Thanks
Santosh

Hi,

If you want to open another application from Oracle forms you can use DDE.App_Begin function. The function will open the application with the parameters passed. To open a word document, use the function as
app_id := DDE.App_Begin('C:\Program Files\Microsoft Office\Office10\WINWORD.EXE C:\test_doc.doc',DDE.APP_MODE_NORMAL);
where 'C:\Program Files\Microsoft Office\Office10\WINWORD.EXE' is the location where MS Word is installed and "C:\test_doc.doc" is the name of the file to be opened. The second parameter "DDE.APP_MODE_NORMAL" specifies the initial window mode. Similarly you can open an Excel file also

Hi,

In 6i it is ok. But in WEB application it won't work.

Thanks,
santosh.