Hi there
I have an excel spread sheet containing a table like so:
<tbody> </tbody>
where A, B, C, D, E represent any letter, and 00001/000001 represent any number. The strings will always be either the length of the first or second cells in the left column. The replace column contains the strings formatted to appear as a hyperlink.
I also have a folder of excel documents, each containing multiple worksheets, with these strings located in cells all over the workbooks. The strings only exist in one cell each; that is, the strings may appear multiple times, but the cell in which they appear contain only 1 string.
I want to be able to do a mass find and replace using vba (or any other automated solution) across this whole folder, using the values in the original spreadsheet containing the find and replace table.
Is this possible? If I can't do it for the whole folder, is it possible to run something that would achieve this for each excel document separately?
Many thanks
rmk911
I have an excel spread sheet containing a table like so:
| Find | Replace |
| AAA.BBBB.CCCC.00001 |
HTML:
|
| AAA.DDDD.EEEE.000001 |
HTML:
|
<tbody> </tbody>
where A, B, C, D, E represent any letter, and 00001/000001 represent any number. The strings will always be either the length of the first or second cells in the left column. The replace column contains the strings formatted to appear as a hyperlink.
I also have a folder of excel documents, each containing multiple worksheets, with these strings located in cells all over the workbooks. The strings only exist in one cell each; that is, the strings may appear multiple times, but the cell in which they appear contain only 1 string.
I want to be able to do a mass find and replace using vba (or any other automated solution) across this whole folder, using the values in the original spreadsheet containing the find and replace table.
Is this possible? If I can't do it for the whole folder, is it possible to run something that would achieve this for each excel document separately?
Many thanks
rmk911
