VBA to search for PDF file based on cell value- then turn row red if it doesnt exist
This should help a bit - MSDN - FileSystemObject You can loop through subfolders in a file, and then nest a further loop, to loop through files in that subfolder. As far as the filename part, try using either the Mid() or InStr() functions to grab the par...