[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • 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.


Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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