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>
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.comReceived on Wed Jul 09 2003 - 12:30:58 CEST