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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
command button to save result of search in report form 1
printing multiple part labels 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Bar Code Scanner - Insert Tab Character 1
stLinkCriteria 3
Access Print Files from Query Results 0
Run code from another workbook 7

Back
Top