Create an Adobe PDF from other PDF files

[Guest]

Hi,

I know this looks as though it falls outside of Excel, but I have code that
creates about 75 pdf files of my excel charts. That was the relative easy
part. (btw, I'm using xcl '02, adobe 5.0, & win xp).

What I am trying to do is have code where I can select various pages from
these PDF's and assemble them into different master documents. Is that
possible? Anyone have any sample code? Or would I have to assemble the chart
sheets together in an excel workbook in the order I want before it gets
pdf'd? I'm dealing with 50+ workbooks and probably a few hundred pages of
printed charts.

Thanks!

jbl

 

[Fredrik Wahlgren]

Hi,

I know this looks as though it falls outside of Excel, but I have code that
creates about 75 pdf files of my excel charts. That was the relative easy
part. (btw, I'm using xcl '02, adobe 5.0, & win xp).

What I am trying to do is have code where I can select various pages from
these PDF's and assemble them into different master documents. Is that
possible? Anyone have any sample code? Or would I have to assemble the chart
sheets together in an excel workbook in the order I want before it gets
pdf'd? I'm dealing with 50+ workbooks and probably a few hundred pages of
printed charts.

Thanks!

jbl

I think you will need some kind of pdf API in order to do this. I have found
one here :
http://www.pdf-tools.com/shop/products.asp?pcid=LBE

I think you need to ask these people if it's possible to write VB or VBA
code to do what you want.Adobe Acrobat is an alternative. Your own
suggestion, rearranging the sheets and chart is also a possibility.

/Fredrik

 

[Guest]

Fredrik,

Thank you for the site. I would think such a task is possible, but since
I'm no pdf expert I don't know for sure. If I have to go the other route, it
would be a pain but doable. I contacted that company and hopefully they have
an answer that isn't too cost prohibitive.

Cheers,

jbl