Loop through folder and print all files in folder

MsLady

Traumatized by Access
Local time
Today, 04:20
Joined
Jun 14, 2004
Messages
438
I would like a command button, when clicked 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 :D

thanks :)
 
Searching the forum is a great way to discover and learn the answers to your questions.

You could use the ShellExecute method to print a listing of the files. My Browse [Find a directory or file] sample will show you how to grab a table listing of files for a specific directory and it also has the ShellExecute method.

Search the forum if you do not know how to perform a loop to print each found file.
 
Last edited:
ghudson said:
Searching the forum is a great way to discover and learn the answers to your questions.

You could use the ShellExecute method to print a listing of the files. My Browse [Find a directory or file] sample will show you how to grab a table listing of files for a specific directory and it also has the ShellExecute method.

Search the forum if you do not know how to perform a loop to print each found file.
LOL..Thanks for your info and concern.
I always search before i ask any question around here.
I have done that and couldn't get anything helpful ;)

Anyways...thanks again.
 
aarrrggggggggggghhhh

*bursts into tears
 
M'Lady, someone can help but you've got to give us a clue. That link from gh has some good stuff in it!
 
Can someone post the updated link that Ghudson posted earlier? It's dead.

~Andrew
 
To achieve what you are trying to accomplish you will need to use the File System Object and the DIR function. Are you familar with them?
 

Users who are viewing this thread

Back
Top Bottom