OraFAQ Forum: Forms » find & replace in csv file and how to set file as read only

Home » Developer & Programmer » Forms » find & replace in csv file and how to set file as read only

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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~

Report message to a moderator

Previous Topic:	Unique constraint error
Next Topic:	Cursor restriction...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:15:38 CDT 2024