• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Printing External PDF Files From Excel With Continuous Page Numbers

ExcelLearner

New Member
Hi Folks,

I am trying to build a system for my department by using an excel macro. This excel file will have 3 sheets first two sheets will have my process data, and third sheet in "A" column which contains a list of pdf file names along with their paths. What I want to achieve is, when I run this macro it should print my two sheets, after which it should print pdf files one by one. The most important is, we want to see the page numbers at the bottom in the format ("Page 1 of 13"). What we see as a challenge here is , printing the pdf files located in a particular path secondly assigning the page numbers even the pdf sheets.

It would be of great help for us if you could give us the solution.

Example file is also attached for your reference.
 

Attachments

  • Example File.xlsx
    12.3 KB · Views: 5
Back
Top