Creating individual folders containing selected files that meet a condition

[technik]

Hi

Have become unstuck so it's back to the board. Quite new to Excel VBA so am hoping this problem is fairly easy for someone else?


I have some selected papers that are PRINTED out if a candidate scores <=50% (on that topic). Each candidate receives (the 1st) 5 <=50% topic papers on the candidate sheet.

I am trying to, instead of printing (due to printer problems), to SAVE the 5 topic papers along with the candidate template sheet (which is an excel sheet not a pdf file), in individual folders. Each folder would simply be named as the candidate's name. Each candidate folder should contain 5 pdf topic files with the candidate sheet. Ideally I would want the candidate sheet as a pdf file as well. The alternative here would be to create just one folder with all the candidate files but this would have to be sorted so that I know which files belong to which candidate.


I am not sure, as I am new to VBA, whether I could tweak the code below (thanks to muad) to "save" instead of "print".

Call apiShellExecute(Application.hwnd, "print", cell.Value, vbNullString, vbNullString, 0)


Or should I be looking at looping through with something like

MkDir "C:\" & Range("F1").Value

Any help would be greatly appreciated. Files attached.

[technik]

Can anyone help?