MS Excel- Find and Replace multiple values

[jjautoit]

I am a newbie and need some scripting help.

I am workin on a big excel spreadsheet and I need a script for finding and replacing multiple values.

Basically what I need to do is:

1. I have two array values that needs to be added/replaced.

2. The script looks for a cell that contains the first value in an array1.

3. If finds the first array value on a given row.

4. Inserts a new row below.

5. Adds the first value from array2.

6. Repeat until all array2 values are inserted (inserting a new row for each array2 value).

7. Repeat 2-7.

I know the Find/Replace function in excel only finds/replaces a single value. There must an easier way using AutoIt since I have some 1200+ rows to work with.

If anyone has worked with AutoIt and Excel please give me some pointers. I really appreciated it.

[therks]

From what I've been hearing around the forum, AutoIt can't work with Excel. Something about COM support.

[Blue_Drache]

I am a newbie and need some scripting help.

I am workin on a big excel spreadsheet and I need a script for finding and replacing multiple values.

Basically what I need to do is:

1. I have two array values that needs to be added/replaced.

2. The script looks for a cell that contains the first value in an array1.

3. If finds the first array value on a given row.

4. Inserts a new row below.

5. Adds the first value from array2.

6. Repeat until all array2 values are inserted (inserting a new row for each array2 value).

7. Repeat 2-7.

I know the Find/Replace function in excel only finds/replaces a single value.  There must an easier way using AutoIt since I have some 1200+ rows to work with.

If anyone has worked with AutoIt and Excel please give me some pointers.  I really appreciated it.

<{POST_SNAPBACK}>

Until COM goes in, the only way is to write a VB script.