"Merging" a PDF file

**CassioGodinho** · 06-15-2012, 01:45 PM

Hello people, im looking for ideas on how to do a PDF merge using a macro I have.
macro_print_pdf_v1.7.xlsm
This file have a macro that open all excel files on a given folder, copy some columns em paste on the order I need on another sheet and print a PDF, the code is a little messy but I get the job done.
Then I merge all those PDFs plus a default PDF that have to be on top of all using this webapp: http://foxyutils.com/mergepdf/

Any Ideas on how to make this without the need to use this webapp?

Sorry for the bad english =)

**mojo249** · 06-15-2012, 03:55 PM

Do you have Adobe Professional (not just Adobe Reader)?

http://www.excelforum.com/excel-prog...-document.html

**Vladamir** · 06-15-2012, 04:13 PM

There are several different options you have to merge PDF files. How one would do it within Excel is something I can't say is possible or not possible at this moment. But due to the proprietary format of PDF files, it's not that easy to edit or merge them unless you purchase other software. These packages range from $30 to $100's. I'm sure there are free utilities but I always stay away from free stuff on the Internet because it's almost certainly spyware.

Now, there are some utilities which run on *nix OS and they are true Open Source programs which are free and also free of spyware. How you would interface these with Excel...again, I'd have to play around with it and even then I can't say it would work. But long ago, when I was working with PDF files I discovered that a PDF file converted to a true PS (postscript) file, is just a text file. And I found it very easy to merge text files with just about anything. This may not produce the most efficient method of doing it but it sure beat spending $100's on Adobe's Acrobat software.

I can also recommend another software called Revu by Bluebeam Software http://www.bluebeam.com. This is an expensive option that has more power than you could imagine when working with PDF files.

But to be completely honest with you...I can't say there is a magic bridge between Excel and PDF files. Someone may reply shortly and completely prove that wrong. Remember, there is always someone out there more clever than yourself. And forums like this are where you find clever ideas from others.

One of those *nix utilities is available at http://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/. It's a command line program so you could theoretically shell to DOS and run it to merge PDF files. I have used it before to install watermarks, merge...etc with PDF files and it's pretty good...plus it's free.

**CassioGodinho** · 06-15-2012, 04:22 PM

Thanks for the response guys.
Maybe the best way of doing this is not merging the pdf files, but while moving the columns I could try to copy them all to the same sheet and print just one... but if I do that I would need to merge this one file with my default pdf anyway.
Well, if I find a way (with some clean free utility) I post it here =)

**readinglife** · 09-05-2012, 06:20 AM

I've tried to merge PDF files with free online services, and there is a free pdf merger: http://www.kvisoft.com/pdf-merger/

**kellylorry** · 12-27-2012, 08:18 AM

Hi,

I have to use Kernel for PDF Split and Merge Tool for merge my different PDF Files into one PDF File.You can also try to use this tool from here http://www.merge-pdf.net/ .

May be it also help you.

**bojef** · 12-23-2023, 06:40 PM

Originally Posted by CassioGodinho

Thanks for the response guys.
Maybe the best way of doing this is not merging the pdf files, but while moving the columns I could try to copy them all to the same sheet and print just one... but if I do that I would need to merge this one file with my default pdf anyway.
Well, if I find a way (with some clean free utility) I post it here combining PDF files=)

I need to merge multiple pdf documents into single one, using their urls. Is there any way, we can merge the content of multiple pdf url without actually downloading them into local. Please help

**alansidman** · 12-23-2023, 06:45 PM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #1 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread