How to merge multiple PDFs into a single file using VBA?

[stastim]

I have a code that saves individual excel files as pdf, but I'd also like to merge these pdf files into a single pdf file at the end of the macro. Is it doable? Thanks!

 

[mvptomlinson]

Merging PDF files is not a function of Excel. Instead, why not combine all of the Excel data into one worksheet and print that to a PDF? A macro could do that, then delete the merged sheet afterward.

 

[stastim]

Thanks for the suggestion! Copying/pasting each individual file data into a separate worksheet of the same workbook may actually work. There's a way to save an entire workbook as pdf. That way, page breaks will be perfect too...

 

[stastim]

So, now I have multiple worksheets in an Excel file, that I want to save as a single .pdf file. Is there a way to automatically add bookmarks to the .pdf file based on the worksheet names? Thanks!