Hi all,

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:

Example:

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

          FSO.CreateFolder (Fldr_name)