I am trying to write a VBA program to select all the files (without listing each file) in a directory and print them . The number of files can vary month to month. In Excel, you can highlight all the files and using the Tool Button, you can click Print and it will print all the files.