Macro to Print a list of pdf's in Excel

L

leep20

I have a list of file path's in Excel, for example:

K:\TIA\project1.pdf
K:\TIA\map.pdf

I would like a code to go through each adobe file and print it. If anyone
could help, that would be great
 
A

ANONYMOUS

You don't need a macro to do exactly what you want to do. I suggest
launch your Windows Explorer, sort the files by "TYPE", then select all
the pdf files by highlighting them (select the first pdf file then press
shift key and down-arrow key), now go to file, print. VOILA you have
done it.

Hope this helps.
 
L

leep20

The problem with that is, not all the pdf's in the directory need to be
printed. The ones that need to be printed change every time. I only want
the ones in my excel list printed.
 
Top