• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

Batch print


I have a list of excel files and a check box next to them, the user can select the files he want to take print out and when the user click the "Print Selected" button I want to print the selected files one by one.

Thanks in advance.

1 Solution
I don't think any of your script can initiate the print.  You'll notice that many sites offer a "printer friendly version" but none offer "Print this page now"

You could launch each one in a new window so the user can click print, close, print, close, etc

Or perhaps you could merge the selected worksheets into one workbook first, then open it for the user to only print once.  This is probably the most doable and get your closet to offering convienence for the user.

It'll be a bit of coding and perhaps a learning experience but you should be able to use the Excel API from ASP to open a masterwork book, remove all the sheets that were NOT selected, then save it with a unique name and redirect the user to that.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now