VBA Code to copy multiple PDF sheets and paste in Excel

[deve8ore]

Hello,

I'm working with Adobe Reader 8.0, working on a project for work, so not allowed to download any other software/ freeware.

We receive PDF files frequently with about 20 sheets. I'd like to copy these 20 sheets at one time and just paste them into an Excel spreadsheet (one sheet).
Nothing fancy, no elaborate formatting, I would just like the picture of the PDF sheets in Excel.

I can manually copy one sheet and paste onto the clipboard... in fact I can copy all the sheets and copy on the clipboard, however when I paste into Excel only the first sheet appears.

Any help would be appreciated.

Thank you,

Matt

[Dököll]

Hello,

I'm working with Adobe Reader 8.0, working on a project for work, so not allowed to download any other software/ freeware.

We receive PDF files frequently with about 20 sheets. I'd like to copy these 20 sheets at one time and just paste them into an Excel spreadsheet (one sheet).
Nothing fancy, no elaborate formatting, I would just like the picture of the PDF sheets in Excel.

I can manually copy one sheet and paste onto the clipboard... in fact I can copy all the sheets and copy on the clipboard, however when I paste into Excel only the first sheet appears.

Any help would be appreciated.

Thank you,

Matt

Greetings, deve8ore!

That's a good one there partner; it's probable you've already seen this but it looke like yyou can get some ideas there: http://www.mvps.org/dmcritchie/excel/pdf.htm

Have you considered going on an Adobe site for an answer, sounds like tech support should be able to help with paste mechanisms/options form PDF to Excel, it's their software;-)

[deve8ore]

Thanks for the response, and the directions (that I found) allow me to capture the first page and copy/ paste into Excel. I need all 20. I'm thinking there's a way since I'm able to at least copy one page......

Thanks anyhow. Any other ideas would certainly be appreciated!