multiple find and replace macro (clased file)

[pixel34]

Please Login or Register  to view this content.

Hi
I'm very much like the format of the code above.
I would like a new code with the same format.
Change Find new code files will be closed.
(Files in a folder)
I'm sorry for the English.
I am writing with Google translate.

[patel45]

Please Login or Register  to view this content.

[pixel34]

Hi patel45
You are very kind.
Thank you.
Please look at my example file.

[patel45]

I'm sorry but I did not understand your goal

[pixel34]

Hi patel45

I would like added to the following code.
The following code is making a single change.
I would like to make changes at the same time 8 or 10.

Please Login or Register  to view this content.

[pixel34]

..................
double posts

[HaHoBe]

Hi, pixel34,

maybe like this (I changed the range from the whole sheet to the range mentioned in the opening post), code is untested:

Please Login or Register  to view this content.

Ciao,
Holger

[pixel34]

Hi HaHoBe,
Great find and replace operation.
Thank you very much.

I want to get a great macro.
Find and replace if it was successful. >>> Column H cell "x"
Find and replace if it is not successful. >>> Column H cell " " (empty)

[HaHoBe]

Hi, pixel34,

when you use Replace as a normal function you get a feedback of how many times the replacement has taken place. If you use the command via VBA use must maybe take WorksheetFunction.CountIf before replacing and after in order to decide whether the action was successful. And since you replace in a lot of files: any single file in a new column, any single sheet of each workbook?

Ciao,
Holger

[pixel34]

Hi Dear HaHoBe,
applied to the macro in the workbook page. So the "Change Page"

I do not want the action to closed files.

Edit: I is concerned. Entries she understood exactly.
We hope that in the sample can be determined.

[HaHoBe]

Hi, pixel34,

sorry but as I donīt know the structure of the files where the replacement shall take place I find it hard to predict whether any change is successfull or not. And again: what shold be indicated: if any one change was successfull in any worksheet or if the replacement was successfull in all worksheets in all workbooks?

I do not want the action to closed files.

The line for closing is

Please Login or Register  to view this content.

If you add ' or the text REM in front of that line VBA will mark it as a comment and it will be passed. You may delete that line if you feel like (again: I donīt know how many files are in the given folder).

Ciao,
Holger

[pixel34]

Hi HaHoBe,
I think I got better.
Thank you very much.