MS Excell Macros; search document and print

Posted on 2011-10-19
Last Modified: 2012-05-12
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?
Question by:PxP
    1 Comment
    LVL 10

    Accepted 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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now