Hi,

I'm new to Excel programming and I would need some help with one issue.
I have found a very useful multi find and replace code which can be found here:
https://www.extendoffice.com/documen...t-once.html#a1

The code is as follows:

Sub MultiFindNReplace()
'Update 20140722
Dim Rng As Range
Dim InputRng As Range, ReplaceRng As Range
xTitleId = "KutoolsforExcel"
Set InputRng = Application.Selection
Set InputRng = Application.InputBox("Original Range ", xTitleId, InputRng.Address, Type:=8)
Set ReplaceRng = Application.InputBox("Replace Range :", xTitleId, Type:=8)
Application.ScreenUpdating = False
For Each Rng In ReplaceRng.Columns(1).Cells
    InputRng.Replace what:=Rng.Value, replacement:=Rng.Offset(0, 1).Value
Next
Application.ScreenUpdating = True
End Sub
So the code is simply a find-replace function but with multiple attributes at once.

I would like to modify the code so that I would have a dedicated attribute excel which would contain this code and the find-replace-attributes and the search-range would be in a different folder. And the code should also work in a way that it scans through all the sheets in a file. That way the code would be as powerful as possible.

I believe that it shouldnt be that hard to do but I'm not familiar with excel programming so for me it is impossible.

In a nutshell:
1) C:/FIND_REPLACE/ would contain the search document. Lets call it Find_replace_attributes.xls
2) Find_replace_attributes.xls is a file which contain the attributes and the search algorithm. Column A would contain all the "find" attributes and column B would contain the "replace" attributes.
3)Code would automatically scan through all the column A cells which contain an attribute. (the code scales itself)
4)Code scans through a particular folder, for example C:/Find_replace/Files/
5)Code scans through every single excel file and its all contents (not affecting the text sizes, fonts etc.)
6)Code also produces a report about what it has done (what changes were made on fileN.xls on sheet3 on row 844
The report could be placed in the same folder as the attribute file.

Is it even possible to modify external excel files with a macro/excel programming?

The very first question is still, how to modify the range to cover multiple sheets at once?

Thanks in advance!

Kalle