batch printing without VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Usually, directly in a folder in windows I select all my excel files, right
click and select "print". Then, all my files print out. The thing is that it
prints just the first sheet, and some files have more that one sheet. Is
there a way to print all of the sheets of all of the selected files without
opening every Excel files, because I have lots of them..

Thanks
 
No.

You will have to move or copy the other sheets to individual wotkbooks.
 
So then it's worst then before because I have to open every workbook and save
each sheet in another workbook, even if some sheets have relation between
them...

Ok finally I guess I prefer a VBA solution!
 
You must log in or register to reply here.

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
How can we convert OST to PDF file format? 1
PowerPoint Printing PPT to PDF without losing quality 1
Word want to batch print some specific pages in multiple word files 0
How do I right click and print an Excel sheet in landscape? 4
How do I set a print area for every sheet in the workbook? 2
Print Macro 5
printing a header in Excel 2

Back
Top