Printing Excel File From Code

  • Thread starter Thread starter Joe Williams
  • Start date Start date
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
 
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
 
Back
Top