PDF file printing from Excel

Hi all,

I have a excel file, and the range G100 to G122 are the pdf file names. Those pdf files are in the same folder as the Excel file.
So is there anyway I could print all those PDF files at once? Any help would be greatly appreciated!!

Thanks ,
Michael

Perhaps something like this could be of help?

Please Login or Register  to view this content.

This assumes that the filename in range G100:G122 contains the full file name i.e. "whatever.pdf" and that you use adobe reader 8.0 to print the files and the path specified in the "Private Sub Print_PDF" is the correct one.

Alf