Home » Developer & Programmer » Forms » how to open a excel file on web by using DDE (applictaion server10G,Forms10G)
how to open a excel file on web by using DDE [message #338579] Tue, 05 August 2008 06:58 Go to next message
jebesh_s
Messages: 34
Registered: August 2007
Location: Chennai
Member
Dear all,

I need to open a excel file on web by using DDL (forms10G)
i have written a code like below it is working fine in local meachine but not in web please help me to do this

Declare
M_APP_ID pls_integer;
M_CONV_ID pls_integer;
begin
M_APP_ID:=DDE.App_Begin('C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE F:\Bin\ORION\DORN106\upload\UPLOAD_FC_1.xls',DDE.APP_MODE_NORMAL);

M_CONV_ID:=DDE.Initiate('EXCEL', 'F:\Bin\ORION\DORN106\upload\UPLOAD_FC_1.xls');

EXCEPTION
WHEN DDE.DMLERR_NO_CONV_ESTABLISHED THEN
--M_CONV_ESTABLISHED:=FALSE;
DDE.TERMINATE(M_CONV_ID);
DDE.APP_END(M_APP_ID);
END;

if the above coding is wrong please suggest me to write in a proper way.

Advance thanks

Thanks,
Antony

[Updated on: Tue, 05 August 2008 07:51]

Report message to a moderator

Re: how to open a excel file on web by using DDE [message #338860 is a reply to message #338579] Wed, 06 August 2008 02:30 Go to previous messageGo to next message
jebesh_s
Messages: 34
Registered: August 2007
Location: Chennai
Member
please giveme a suggestion to open a excel file on web using DDE
Re: how to open a excel file on web by using DDE [message #338865 is a reply to message #338860] Wed, 06 August 2008 02:33 Go to previous messageGo to next message
sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member
Hi Jebesh,

There is a lot of posts regarding this.
Please search the form with excel

Regards
Sasi..
Re: how to open a excel file on web by using DDE [message #338869 is a reply to message #338865] Wed, 06 August 2008 02:39 Go to previous messageGo to next message
jebesh_s
Messages: 34
Registered: August 2007
Location: Chennai
Member
i searched lot but could not find the right solution .please suggest me if u have solution
i can not run excel on web by using dde.app_begin
Re: how to open a excel file on web by using DDE [message #339619 is a reply to message #338869] Thu, 07 August 2008 23:43 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What message are you receiving?

David
Re: how to open a excel file on web by using DDE [message #339667 is a reply to message #339619] Fri, 08 August 2008 02:00 Go to previous messageGo to next message
jebesh_s
Messages: 34
Registered: August 2007
Location: Chennai
Member
Hi david ,

I am receiving ORA-106553 error
even i could not open a excel file by giving this
DDE.App_Begin('C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE F:\Bin\ORION\DORN106\upload\UPLOAD_FC_1.xls',DDE.APP_MODE_NORMAL);

can you please make sure whether DDE will support for web or not
waiting for your update.
advance thanks
Thanks,
Jebesh S

[Updated on: Fri, 08 August 2008 02:15]

Report message to a moderator

Re: how to open a excel file on web by using DDE [message #341196 is a reply to message #339667] Sun, 17 August 2008 19:35 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do you have to use 'DDE'.

Look at http://www.orafaq.com/forum/m/312409/67467/?srch=dde+web#msg_312409 it would appear that 'web.show_document' would solve your problem.

David
Previous Topic: Flash
Next Topic: Relate From clause block and Database block
Goto Forum:
  


Current Time: Sun Feb 09 23:54:20 CST 2025