473,624 Members | 1,957 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VBA Code to copy multiple PDF sheets and paste in Excel

34 New Member
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
2 7592
Dököll
2,364 Recognized Expert Top Contributor
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
deve8ore
34 New Member
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

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

Similar topics

1
21504
by: Carl Corcoran | last post by:
I'm developing a website for work that exports some reports to excel. I am using the... Response.AddHeader "Content-Disposition","attachment;filename=report.xls" Response.ContentType = "application/vnd.ms-excel" ....strategy to do this. It works wonderfully except I cannot figure out how to do two things: 1) specify a name for the worksheet that's exported (it names the
3
9537
by: cv | last post by:
Hi all, I have to copy two set of data from 2 files(notepad/excel) say, products and their corresponding prices to list/textarea/table. I should be able to retrieve the product and corresponding price information from the control(list/textarea/table). Which is the best way? Quite urgent.. pls let me know. TIA, cv
53
5688
by: Cardman | last post by:
Greetings, I am trying to solve a problem that has been inflicting my self created Order Forms for a long time, where the problem is that as I cannot reproduce this error myself, then it is difficult to know what is going on. One of these Order Forms you can see here... http://www.cardman.co.uk/orderform.php3
3
32925
by: Faith | last post by:
Hello. I need to take a column from Excel(unknown amount of rows) that will be selected by the user and copy those cells. Then I will need to paste those cells into the first column in a Data Grid (system.windows.forms). Basically, the user receives a list of clientIDs from a client as an email attachment in Excel listed like: 1234 ABC Company 234 DEF Company 348 GHI Company
2
6115
by: PrinStation | last post by:
I am looking to import data from Excel to Access. The data is set up in one Excel file, but on 12 (monthly) sheets. After importing the first month/sheet (which I did successfully), I was looking to use the old dBase 3 plus command "append" to bring in the eleven remaining sheets. I am thus far unable to find "append" or rather its Access equivalant. What to do? Any help is appreciated.
1
1766
by: BigAbility | last post by:
hi all, i am trying to make a excel file that is consist of multiple sheets now i did that downlaod excel file from the web server. but it's not multiple sheets, so i realize that i have to use owc (Office Web Components ) in order to solve this
4
8067
by: andrewmac | last post by:
I hope someone can help - I am new to Access so please be patient. I have a list of about 100 equity tickers in a column in Excel formatted as Text. I am trying to copy and paste into a field in a table in Access with Text data type. For some reason Access only wants to paster the first 3 records. Can anyone please help me? Thanks in Advance
5
6401
by: rewalk | last post by:
Hello all, I've set up protected Excel sheets that users can paste data into. I then need to be able to pull the data they paste into multiple access tables and then reset the Excel spreadsheet back to the template. For example, the first few columns go to the first table, the next 3 into a second table and so on. Is this possible? I can't think of a way to do it. Thanks in advance for all your help!
1
1359
by: eskelies | last post by:
Below you will find the code that I have written. I am asking it to search for an Excel file. Once it finds the correct dated Excel file it opens it. From there it is in search of information. I can't determine if the macro is working without fixing the following date - 1 issue. Any assistance would be greatly appreciated. I am using Excel 2003. Dim FileDate, Cusip, Here, Today, There FileDate = InputBox("Enter File Date in yyyymmdd...
0
8174
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8624
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8478
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6111
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5565
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4082
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4176
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2607
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1485
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.