Place all pages into a single PDF file (VBA)

[kelly mort]

Hello WORLD,
I am having this issue an I need a way around it:

I am using a for loop to create pdf files of a sheet (page)

Something like ....

For i = 1 To 20
Create_pdf_file
Next i

So the loop produces a page each time with unique data then I also name each pdf file uniquely.

Now I want a way to get say the 20 files created into a single pdf document or file.

If that is possible, can someone please show me the way?

Thanks a lot in Advance.

 

[6StringJazzer]

Are you creating multiple PDF files of the same sheet with different values each time? Please show Create_pdf_file.

 

[kelly mort]

Are you creating multiple PDF files of the same sheet with different values each time? Please show Create_pdf_file.

Yes I am creating multiple pdf files of the same sheet.

I am feeding the sheet with vlookup

So each loop counter feeds the sheet with different values.

I am not with my pc at the moment so I can't get you the exact code.

I wish the above have made it clearer.

 

[6StringJazzer]

Since it is multiple versions of the same sheet, they would have to be merged/appended to an existing PDF file. Excel does not have this capability.

It is possible to do this if you have Adobe Acrobat Professional installed (not Acrobat Reader). Acrobat provides an API that can be called from VBA. Other products may offer that also but I am not familiar with them.

Another option is that each time you update the sheet, copy values to a new sheet. Then when you are finished you can select all the new sheets and export them to a single PDF file. Then you can delete them. I can't help with that unless I have your existing code.