Merge PDFs using VBA

[TheQ1991]

I have the following scenario:

I have up to 200 different folders on my desktop. In each of these folders, I have up to 15 different pdf files. So I might have the following:

Folder A: Maths.pdf , English.pdf , Science.pdf , Geography.pdf
Folder B: Maths.pdf , English.pdf , Geography.pdf
Folder C: Science.pdf , Geography.pdf

I have an excel file that contains the names of all the folders in column A, all the possible filenames that could be saved in each folder in column B.

What I want is an automatic process that combines all pdf in Folder A and names the new file Folder A. I want it to then loop and to do this for all 200 folders on my desktop.

Any ideas how I could do this?

 

[Micron]

If you want to combine multiple pdfs into one pdf, every thread I've read on this subject states that you need Adobe Acrobat, not just Reader. If you don't have that, it's a non-starter. If you do, it's been covered many times before, but I don't have any links for the code solutions as it's not something I'd ever need.

 

[TheQ1991]

If you want to combine multiple pdfs into one pdf, every thread I've read on this subject states that you need Adobe Acrobat, not just Reader. If you don't have that, it's a non-starter. If you do, it's been covered many times before, but I don't have any links for the code solutions as it's not something I'd ever need.

Thanks Micron. I do have Adobe Acrobat.

The problem I have with the solutions I have found is that it requires me to know which files are in which folder in advance.

 

[Micron]

The problem I have with the solutions I have found is that it requires me to know which files are in which folder in advance.

You have that in columns A and B in your sheet?

 

[TheQ1991]

You have that in columns A and B in your sheet?

Column B contains all possible file names. So filename that is B2 might not exist in Folder D for example

 

[Micron]

You can loop over the possibilities and pass the names to the Dir function to test if the file exists. If not, it returns an empty string. Can't say if you combine one by one or create an array of file names and combine those because I've never needed to combine pdfs. HTH.

 

[John_w]

I have up to 200 different folders on my desktop. In each of these folders, I have up to 15 different pdf files. So I might have the following:

Folder A: Maths.pdf , English.pdf , Science.pdf , Geography.pdf
Folder B: Maths.pdf , English.pdf , Geography.pdf
Folder C: Science.pdf , Geography.pdf

I have an excel file that contains the names of all the folders in column A, all the possible filenames that could be saved in each folder in column B.

What I want is an automatic process that combines all pdf in Folder A and names the new file Folder A. I want it to then loop and to do this for all 200 folders on my desktop.

There are several command-line tools which can be run from VBA to merge PDFs. See these threads:

Combine PDFs using VBA

Hi, I have a workbook in which I save 3 worksheets as a PDF and print them out. Now, one of the actual excel sheets triggers an external pdf file. I need to combine this external PDF to the other 3 PDFs created before. I have tried few different way but to no avail. Any suggestions would be...

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

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