find & replace in csv file and how to set file as read only

From: Manikandan <member12054_at_dbforums.com>
Date: Wed, 09 Jul 2003 10:30:58 +0000
Message-ID: <3089750.1057746658_at_dbforums.com>


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 file.How to achieve this?
Please guide me.
Thanks
~V~

--
Posted via http://dbforums.com
Received on Wed Jul 09 2003 - 12:30:58 CEST

Original text of this message