Sign in to follow this  
Followers 0
jjautoit

MS Excel- Find and Replace multiple values

3 posts in this topic

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.

Share this post


Link to post
Share on other sites



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

Share this post


Link to post
Share on other sites

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.

Lofting the cyberwinds on teknoleather wings, I am...The Blue Drache

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0