Home » Developer & Programmer » Forms » find & replace in csv file and how to set file as read only
find & replace in csv file and how to set file as read only [message #82851] Wed, 09 July 2003 06:51
Victoria
Messages: 152
Registered: July 2002
Senior Member
Hi,
I have saved my xls file using 'SaveAs' option as .csv file.I have done this in oracle form.But i am trying to to find and replace in the csv file.So i recorded a macro in the excel sheet and i have got the following code.But it is not replacing.

The code is:

args:=ole2.create_arglist;
ole2.add_arg(args,'ISLANDS');
ole2.add_arg(args,'IS');
ole2.add_arg(args,2);
ole2.add_arg(args,1);
ole2.add_arg(args,FALSE);
ole2.invoke(worksheet,'Replace',args);
ole2.destroy_arglist(args);

I have also wanted to save this file as read only and hidden file.How to achieve this?
Please guide me.
Thanks
~V~
Previous Topic: Unique constraint error
Next Topic: Cursor restriction...
Goto Forum:
  


Current Time: Sat Mar 02 20:59:44 CST 2024