Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

MS Excell Macros; search document and print

I need to create a macros in excel that will search for a set of documents on various network shares and print those documents. Currently, I'm having to navigate to each document, open and print several copies of each.  I then make job packages by putting a copy of each into different stacks. I have to create dozens of job packages per day. This is very time consuming. I would like to click one button that will find and print all the document required for a job package, go to the printer and retrieve the entire bundle of documents for one job package. Click the button again for the next and so on. Is this possible?
1 Solution
It is possible but we have found that it can be inconsistent. There are two ways printing can be altered. In the document and by advanced options on the printer itself. We have found that converting to PDF gives consistent printing later but requires outputting to PDF first. This may not be feasible for you but I mention it as a possibility. If your documents are set up very consistently then it is possible.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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