Hi all,
I have a piece of VBA code which searches through all the .xls files in a folder and looks for a particular word then pulls out other info in the same row if it finds it. It as working great until some "useful" person on my team decided they wanted to reorder the folders and create a...