I am seeking a macro or gui to gather multiple pdf files from multiple directories on a network drive. For example, I would like to run a macro that will read in a BOM (in some format-probably a csv file), then search several directories of a network drive for the corresponding pdf files (component number e.g. 12050-123) and copy the pdf's into a single directory. Then I would like the same macro, or a different macro if need be, to print the pdf files from that single directory.
I realize that this is not directly a SW post however it is a downstream process that is related to SW. Any help is greatly appreciated!