Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Newsgroup
My macro creates *.xls reports as it grinds through its iterative calculations. Unfortunately, now that it has finished, each of the 120 output files has an incorrect text entry in cell D2. Instead of saying "Hello" in D2 I want to replace it with "Goodbye." How can I replace "Hello" with "Goodbye" in each of the 120 files without opening them individually. Is there an easy way to search and replace for all files within a directory? Thank you W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Serach for multiple words in one cell | Excel Discussion (Misc queries) | |||
serach of dat | Excel Discussion (Misc queries) | |||
Macro Involving Find & Replace In Two Different Files | Excel Discussion (Misc queries) | |||
How to find/replace all of the names of files in EXCEL workbook. | Excel Discussion (Misc queries) | |||
Copy over files/replace (complete question) | New Users to Excel |