I am using this spreadsheet that picks up a filename- full path (variable) with whatever is in column A of my spreadsheet, and then runs the macros in the subsequent columns and re-saves the file. Before running this, I wanted to include a macro that would check all of the filenames in column A to make sure they are valid file paths/filenames.. if not, highlight the cells that are bad paths. Does anyone know of a way to do, if even possible?
Thanks all for any suggestions!!