VBA Joining an External PDF to Excel Print to PDF

[pricebm17]

Hey everyone,

I'm not sure if this is possible within VBA, but just thought I'd throw it out and see.

I have an Excel workbook that I'm turning into a proposal generator. One function will print certain sheets from the file to PDF using ExportAsFixedFormat. I have that code running correctly.

I will also have hyperlinks within the file to various PDFs saved in a shared storage drive. For example: "H:\Folder\File.pdf"

I am curious if there is a way within VBA to open one of those hyperlinks and print it to PDF as part of the same file as the Excel sheets being printed. Any help would be greatly appreciated. Thanks!

 

[John_w]

There are command line tools available to merge PDFs, callable from VBA, for example PDFtk Server and PDFfill. See these threads for example code:

VBA Export diferent excel files to pdf and then combine them to one file

Hi, I know little of this, wondering if someone could help me. I 'm trying to create something like this thread Append to pdf VBA I've been searching for something like this, but just for one subfolder. How can i use this routine, but calling it inside another routine (let's say main...

www.mrexcel.com

Append to pdf VBA

Morning all. I am hoping to find advice for a Shell( ) or other method to add sheets to a pdf file. I have tried several pdf generators / merging programs that support command line, but cannot get any of them to work. I have a standard sheet which is filled by VBA and saved to PDF then...

www.mrexcel.com