Printing Excel File From Code

J

Joe Williams

How can I code a form such that the user enters a part number, then presses
a button and the sytem then scans a directory for a file named with that
part number and an .xls extension, then opens, prints that workbook, and
then closes again?

Thanks

Joe
 
J

Joe Williams

Hi, I saw a post below that referred to opening Excel sheets and I used this
code. HOWEVER, I want to just print the workbook without the user seeing it.
Is there any way to modify the code tina listed below so that is just prints
versus opening the file?

Thanks

Joe
 
Top