Printing PDFs file with Excel Sheets With Page Numbers

[reachharry]

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.

[nathansav]

Do it as a macro, then look at the code, this is on the Save As PDF.

[reachharry]

Sorry, If I have not listed my requirement properly. I do not want to convert the excel sheets to pdf. I want to print first two sheets of my excel normally and third sheet contains the names of pdf files which I want to print. Is it possible to print an external pdf file from excel. If so, can it print with page number at the bottom of each page?

[nathansav]

Oh i see, so you'll want to add something to the PDFs that you open, like a watermark with the page numbes, so they will start at 3?

Automating PDF is difficult, i did it in C# using the Acrobat libraries and it was horrendous, the documentation from Adobe is no help, i had to do it all by trial and error.

Google Automating Acrobat and you'll see, download the docs as its a good place to start

[reachharry]

Let me describe it in this way. Imagine we have a pdf file name "test.pdf" which contains 30 pages. Through a macro from excel, I want to print only 5th, 7th & 12th page of the test.pdf file. Is this possible?