| DDE.Execute [message #87852] |
Thu, 17 February 2005 03:31  |
richa
Messages: 7
Registered: January 2000
|
Junior Member |
|
|
I want to save the applicaion in excel from forms i can issue command from dde.ececute package but i dont know command for saving doc in excel i tryed it with typing
DDE.Execute(ConvID, 'SAVE', 1000);
DDE.Execute(ConvID, 'FILESAVE', 1000);
but it is not working???
Thanks In Advance
|
|
|
|
| Re: DDE.Execute [message #87854 is a reply to message #87852] |
Thu, 17 February 2005 07:22  |
ÇÊ
Messages: 15
Registered: September 2002
|
Junior Member |
|
|
You can use:
DDE.EXECUTE(ConvID, '[[SAVE]]',99999);
It's the same as what you typed before except for the [[ ]] around SAVE. I also bumped the timeout as with the default 1000, I usually end up having problems.
|
|
|
|
| Re: DDE.Execute [message #87857 is a reply to message #87854] |
Thu, 17 February 2005 20:04 |
richa
Messages: 7
Registered: January 2000
|
Junior Member |
|
|
Thanks It is working.But my problem is still existing.
I am creating New Excel file using Text_IO Package. After that using DDE.Poke and DDE.Execute I am formatting and writing the data in Excel which is working fine.But when I am Saving the file, as it is a text format file so message from excel is flashed.So can u pls help me out with saveas or New/Open command syntax in DDE.Execute
|
|
|
|
| Re: DDE.Execute [message #87863 is a reply to message #87857] |
Fri, 18 February 2005 00:49 |
a
Messages: 22
Registered: March 2002
|
Junior Member |
|
|
hi Richa
i cant understand if u are using text_io pkg then why dont u directly put data by using text_io. use SYLK file for more info u will get redymade formating code.
repy if u r not able to use it.
|
|
|
|
|
|
|
|
| Re: DDE.Execute [message #118092 is a reply to message #118062] |
Tue, 03 May 2005 00:59 |
Shyamsundar Patel
Messages: 5
Registered: December 2004
|
Junior Member |
|
|
Hello Mr. David,
Thanks For replying on my Query...I Have used Text.IO and DDE.POKE to Create and Write Data in Excel Sheet.
Currently I M able to Write And Save data in Excel, and Even I can Close file using "DDE.EXECUTE(ConvID, '[QUIT]',99999)" or "DDE.EXECUTE(ConvID, '[EXIT]',99999)" Commands. Both command are showing Errors but they r working.They Quits the Excel File. Now The Only Problem is to generate Excel File thru' forms. I M Using TEXT.IO for that which cause error regarding FORMAT TYPE while saving...How Can I generate Excel File without using TEXT.IO Command???
I Have not used Utl_file Package. I Have not idea about this package.Can U Give me an Example to create , write Data & Close after saving the Data thru' this Package??
My Works are pending b'coz of this Problem.Pls. guide me.
Thanks to ALL.
Shyamsundar Patel.
|
|
|
|
|
|
| Re: DDE.Execute [message #118441 is a reply to message #118101] |
Thu, 05 May 2005 05:04 |
Shyamsundar Patel
Messages: 5
Registered: December 2004
|
Junior Member |
|
|
Hi David,
Thanks. I have gone thru' the links u have suggested. I got an Example also for usage of utl_file :
create or replace procedure utl_file_test_write (
path in varchar2,
filename in varchar2,
firstline in varchar2,
secondline in varchar2)
is
output_file utl_file.file_type;
begin
output_file := utl_file.fopen (path,filename, 'W');
utl_file.put_line (output_file, firstline);
utl_file.put_line (output_file, secondline);
utl_file.fclose(output_file);
end;
I M Trying to use this code in form. but when form execute 1st line
"output_file := utl_file.fopen (path,filename, 'W');"
Error occurs "User-Defined Exception ???????? & Can I able to write no. of raws in no.of columns using this pacage???
- Shyam.
|
|
|
|
| Re: DDE.Execute [message #118562 is a reply to message #87852] |
Thu, 05 May 2005 20:09 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Check the documentation again. You have to define a path containing the directory where you intend to write the file.
If you want to write raws into cells then you had better look at ora_ffi. Do a search of this forum for my previous posts on ora_ffi.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
