Need code to merge PDF files in a folder in to single PDF file using adobe reader

Hi,

I have an excel file in which I have a macro that creates a series of 20 PDF files and will saved in pdf folder path and now I need a code to merge all the PDF files in a folder into single file I am using adobe acrobat reader to view pdf files. I searched in google but I didn’t get proper code to combine PDF files into single PDF. Please anybody help me with this. It will very grateful help to me.

Originally Posted by YasserKhalil

Hello
Have a look at this link
https://wellsr.com/vba/2017/word/com...adobe-acrobat/

HI YasserKhalil,

Thank you so much for reply. i gone through your link its awesome once again thanks but its not worked to me because in instruction itself mentioned
DESCRIPTION: This function uses Adobe Acrobat (won't work with just the Reader!) to-------------
unfortunately am using the adobe reader i dont have the full version of licences of adobe acrobat. Is there any other way to get combine PDF using by arcoba reader or i am using other application called Nitro PDF

Originally Posted by bakerman2

Why not just group the sheets before converting them to pdf so they already are in 1 pdf file ?

HI Bakerman2,

i have one sheet only with 20 units by monthly wise i will generate the reports as 20 PDF files it save in PDF folder path from the folder i need to combine all pdf it one single PDF files it so easy to send email to my boss, is not possible when i creates PDF files working perfectly why cant make single pdf files by normal VBA code.

Originally Posted by humdingaling

you need 3rd party software
https://www.mrexcel.com/forum/excel-...using-vba.html

Hi humdingaling ,

Thanks i visited the link which you given and many solution reporst how to combine the pdf mostly they given has solution with 3rd party software like PDFSAM, PDFCREATOR. I am using the 3rd party software in my home pc is NirtoPDF software i will check with the code which i can modify with NitroPDF but my company i have in my system only Adobe Reader only there is no 3rd party software and i cant have access to install the other 3rd party software. My worries are how can use the vba code to merge pdf files without 3rd party software on my company pc.

Originally Posted by humdingaling

Already said you need 3rd party software, so instead trying to force a round peg in a square hole

suggest you talk to your IT within your company on how to obtain software to achieve the task that is required of you
if they are being a road block then talk to your boss to talk to your IT to tell them to provide you with the appropriate tools for the tasks that is required

Hmm.. i will speak with my boss Thank you so much