Fastest way to search 5000 Excel Files in a directory
I have 5000 Excel files in a directory. I need to go through all of them and search for some text and change a cell if the text is found. I'm looking for an alternative to my current method of Automation, where I open, search and close each file. Openning and closing each file takes to long.