I am trying to search a directory at work (folders / sub-folders) for items listed in an excel workbook to see if those items are contained in any other excel file in the directory. Does anyone have a Macro that could do this? It would be great if the macro could return the path and file name...
I recently got upgraded to Excel 2010 and when I embed excel workbooks in other excel workbooks, they get thrown into the backgound as hidden. Is there a way to disable this feature?