Loop through folder and print all files in folder

Ladybug · Oct 18th 2005

I want to have a command button on my sheet where i can click on to loop through a folder, and send each file (could be word, pdf, xls) to the printer to be printed.

What is the best way to achieve this?
Any ideas, tips, code, curses are welcome

thanks

Kieran · Oct 18th 2005

Re: Loop through folder and print all files in folder

Ladybug,

I open the folder in explorer, select all the files and then choose print from the right click menu of the mouse.
Note the pritn option only appears when all the files selected support printing form this pop-up menu. If the option does not appear, you have a file selected that does not have a default print method.

HIH

Ladybug · Oct 18th 2005

Re: Loop through folder and print all files in folder

Thanks Kieran,
I have tried that in the past, and even though all the files are selected, aloto f the files don't make it to the printer. For some reason, files do get skipped. So i was looking for a way to do this via VBA code, where you can click on a button an it opens each file and prints individually

Ladybug · Oct 18th 2005

Re: Loop through folder and print all files in folder

*bump

Loop through folder and print all files in folder

Participate now!

Share