Hi Kenneth, thanks for responding.

Software i'm currently using:

Excel 2013
Adobe Acrobat 8 pro (since it's free, and allowed me to drag and drop pdfs for doing this project manually.)


1. You want to create the cover pdf in Excel rather than MSWord?
Not mandatory. The original coversheets were being done in MSword via mail merge. I got this idea of generating the coversheet in excel from another site (I can't seem to post the site - so google "mail merge without word john walkenbach" and it'll come up)


2. You want to merge existing pdf files?
Yes. Existing PDF files (as indicated in the hyperlink in Column G) inserted directly behind the generated cover sheet. (see last image).

a. To merge existing pdf files, you must have a 3rd party application. e.g. Acrobat, not the reader, or PDFCreator v1 or v2, PDFsam, etc. Keep in mind that you users must have this application too. Which did you want to use?

I have acrobat 8 installed and working ok so we can go with that. My corporate laptop is not locked down tho so i can use the other software you mentioned if you feel it's better.

3. Would all of the hyperlinks be based on E2 path?
The hyperlinks for each PDF are located in column G. The existing PDFs are on a local drive.

Cell E2 is where i'd like the finished product to be saved to. The finished product being 1 combined pdf of the compiled coversheet+specsheet combos.

Good call not using dir for a variable.