find and replace in vb6

Associate
Joined
1 Mar 2006
Posts
425
ok ill explain this in as little words as possible

i have an excel sheet at c:/excel.xls

it has 5000 rows and 10 collumms full of data number and text


at button click i want to load this entire excel sheet into a multiline textbox

once loaded i want to use some kind of find and replace funtion

find "hi" replace with "hello" for example


once it has update the text in textbox1 i want it to overwrite excel.xls

that is all...can anyone help?
 
Back
Top Bottom