By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

VBA Code to copy multiple PDF sheets and paste in Excel

P: 34
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
May 17 '08 #1
Share this Question
Share on Google+
2 Replies


Dököll
Expert 100+
P: 2,364
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;-)
May 20 '08 #2

P: 34
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!
May 20 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.