Visual Basic code to combine 2 or more pdf-files

[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

[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

[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]

[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