This is more of an Excel VBA question. I have exported the BOM list from PDM and I have written a Macro that deletes all unimportant information from that file.
I end up with a list of only the part numbers I need:
I need the macro to search for each row the corresponding pdf file (solidworks drawing) in folder "Released Drawings" and then copy/paste them all in folder B. (best is if that folder is being created in a certain location with the value of the FM row)
The pdf files have the following names: (for example)
So it needs to look for the latest version of a file (when a file ends with _D, there is also a _C variant. It needs to select the D variant. it will also have the newest date)
Update 1, made the create folder myself with (in a loop):
If InStr(StrConv(ActiveCell, vbUpperCase), "FM") = 1 Then
Fldr_name = "D:\Spare Part Generator\MRD Final\" & ActiveCell