Hi

New to Excel VBA so pardon my ignorance.

Can anyone tell me whether it's possible to call apiShellExecute to copy files from one folder and paste to another folder?

I know you can use it to print pdf files

E.g. Call apiShellExecute(Application.hwnd, "open", cell.Value, vbNullString, vbNullString, 0)

cell.Value points to the filepath where the pdf file sits.

But I need to loop through and move different pdf files (that meet a criteria) and paste them to another folder.