Hi guys welcome back to my channel f Shake Excel master I hope you guys are doing great today and today's session is really exciting then we are going to see how to print multiple PDF files by one single click yes this is possible by macros we usually come across a situation where you have a multiple PDF files kept in your desktop and you like to print them on one go this works in an excellent way to being raised by one of my subscriber mr. Khan where is he has a set of 10,000 files but we need to search and print only 200 files where these file names will be available in the list and we need to render so I have written this code and this code will be available on my Facebook group page and you can download this macro file as well from the page for training and educational purpose and but today we are going to see the logic behind this how it is inside so friends let us quickly see how are we going to print this document but the document and understand how are we going to use this file so once you select the printer and you open the file it will be as a default printer print and you can select the printer which you like to get so in my case I have selected black text or print a PDF and get the list of the PDF files to get the lip of the PDF files we need to keep this macro file in that folder where you want to get that PDF file so if you place it in the desktop you can receive all the documents which are you PDF on the desktop if you keep it in my documents then it will pick up all the documents which are available in the middle so in my case I have selected on C Drive and aspirated a test folder so it should read all these three documents and then it should print it so and select the printer by default printer get a PDF file here I have the PDF files and then me and as soon as I select print PDF ready to print PDF yes as you can see with opening PDF file has been printed and done with my picture printer now if I go to my Mac desktop which as it sure to you this is my Mac desktop and as you can see this document is already been printed over here women one two one two three Eve all these documents have been printed on my Mac tech so once it is been printed the status is automatically changed we're done so let us understand the logic and very one important thing which I like to share it with you before you proceed this file that from the object file library it will check in to the.