VBA to loop through list of filenames and print

[PATSYS50]

Hi all,

In range A1:A10, I have a list of the path and the filenames of pdf files e.g.

D:\PATSYS50\Desktop\2024\File1.pdf
D:\PATSYS50\Desktop\2024\File2.pdf
D:\PATSYS50\Desktop\2024\File3.pdf

And so on.

Can VBA loop through each of the files and print to the default printer?

Thanks in advance

 

[Micron]

Answer to your question is yes.
This is a very common topic with perhaps hundreds of thousands of questions and answers with posted code. Rather than recreating the wheel from scratch here, maybe look for something that you could try to adapt to your situation?