Page 1 of 1
Visual Basic code to combine 2 or more pdf-files
Posted: Mon Jul 02, 2007 3:13 pm
by mictrine
Hi!
I have tried a code to print a single sheet i Excel from visual basic using the BullZip pdf printer, and it works perfect. Now i would like to go a little futher...
Does anybody know how to combine 2 or more pdf-files from visual basic?
Mic
Posted: Thu Jul 05, 2007 9:03 am
by jr
Have you tried to use the MergeFile setting of the PDF Printer? If you set that to the first file when you print the second then they should be linked together.
Regards,
Jacob
Posted: Thu Jul 05, 2007 10:14 am
by mictrine
Hi Jacob!
Yes i found out how to do it... Very cool
[code]
myobject.SetValue "output", SavePath & FileName
myobject.SetValue "MergeFile", SavePath & FileName
[/code]
Re: Visual Basic code to combine 2 or more pdf-files
Posted: Tue Jan 13, 2009 11:33 pm
by rudevincy
I also have a similar problem currently my program creates an excel worksheet then it pdf's the worksheet and closes the file and moves to the next one. It generates 250 reports. I would like to be able to make the pdf in one file (so it would be 250 pages) could I use the line of code
myobject.SetValue "output", SavePath & FileName
myobject.SetValue "MergeFile", SavePath & FileName
and if so where in my code can I place it?
PLEASE HELP ME