search words in a excel file

[Aarthi_Arvindh]

Hi Gaurav,

   As you told i have checked that replace string option. It works as you told.

It is not matching exact occurance.

Also this function will search in active sheet only, but we can select worksheet by Excel Get Worksheet function

and then we can search.I have checked it.

[Gak]

@ Aarathi: Thanks for informing.

[kazakiebo]

and how can i do to search, change and save but in other place, not automatically the overwrite the original excel??i change the workbook but i can't save...

i am alan4 partner

[Gak]

Instead of "Save" invoke method, use "Save As".

[kazakiebo]

yes but automatically if i put saveas there is a dialog that appears and whati want is to put a direction and save it...

[Gak]

Post your code

[kazakiebo]

thats your code trial1, you have attached in the third page...

[Gak]

If you do not want the Dialog box, give input to "Filename" (Intended path).

[kazakiebo]

hi!!

i have one question, in stead of doing new file..can i do something that doesn't save nothing, like virutal or temporary file??

whati want is to read an original excel change something, and read the file i have change...

do you understand??

[Gak]

NO