I have an excel file (2002) which contains a list of folder paths that may or may not match the actual folder paths on the hard drive. I need a macro which will take the listed paths (as a guide/starting point), search for the actual path and then return/output the actual path back into a cell on the spread sheet. It would need to do this for each listed path individually till the end of the list. I've searched for similar macros using wild cards Dir etc but haven't found anything that does this specifically. Any help would be much appreciated!
Bookmarks