Excel 2007 Macro to convert more pdf files to 1 single pdf file

[mihailovici]

Hi guys,
I have this folder
C:\MIHAI\DOC\ASIG\DOSARE

In this folder are more pdf files.
Can you help me with a macro that can run from Excel 2007 and converts all the pdf files in one single pdf file in the same folder, and if possible deletes the old pdf files ?

Thanks a lot.
God Bless!!

[June7]

This is a common topic.

Do you have Adobe Acrobat Pro installed?

Review https://stackoverflow.com/questions/51389983/vba-combine-pdfs-into-one-pdf-file

[mihailovici]

Hi June, thanks again for your reply.

Currently I do not have Adobe Acrobat Pro installed. Its my work computer and i cant install any programs.
Is there any other way I can achieve what I want just by using VBA code ?


Thanks a lot!

[June7]

Not that I know of. If you can get approval to install a freeware, consider https://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/

You already asked this question http://www.vbaexpress.com/forum/showthread.php?71362-Convert-all-jpg-and-pdf-files-from-folder-into-1-single-pdf-with-same-width

[mihailovici]

Thanks a lot June ... again
I think I will propose management to buy that program and to use it on a daily basis
Is it possible to write a batch file that uses the program that you recommended from pdflabs in order to convert all pdf files into a single one ?
Thank you
God Bless!

[June7]

I've never used pdflabs software and no idea if a batch script can run it. Maybe ask pdflabs. I didn't suggest pdflabs from experience, it was just one return from web search and they are certainly not the only one you could consider.