Hello to all.
I would like to ask you if you find someone who can help me with these two macros that work very well but for certain things. So because I do not understand many will not explain what the problem is:
The first is made so that the popup window to search for a word in countless workbooks, it does but only in the open sheet of the workbook. So you can be less that the revised starting from the first workbook, going through all the Sheets then goes to the second sheet and check all the way to the end?
Please Login or Register  to view this content.
My second problem:
This macro also works perfectly: I open a new workbook (book1), I put my macro button to call after his appearance, immediately began to seek how many workbooks are in a folder where it is located (book1). For example, in a folder Trii / 10 I excel file that shows them to me in column A: A (book1), then in the box izkochiliyat I wanted to write about what I want to look and how to replace it - this is the same as standard option in excel (Find and Replace) but looking in all workbooks and the problem here is that the macro is designed to look at specific cells and truly replaces words.
So the problem is whether you less to fix it to look absolutely all cells in all worksheets.
I believe that is a matter of minor fixes somewhere in the code, but because they do not understand, I do not know where to Complete the thing.
Please Login or Register  to view this content.