UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Embed PDF into Excel    
 
   
parora1
post Jul 21 2005, 05:24 AM
Post #1

UtterAccess Enthusiast
Posts: 57
From: Toronto, Ontario, Canada



Is there any way to embed a PDF document into an Excel worksheet, such that it actually becomes part of the worksheet. If I create and Object and then reference the PDF document, when I delete the source PDF document, I can not open it anymore in Excel, because the reference is broken. I want the PDF to be part of the Excel document.

Thanks.
Go to the top of the page
 
+
sdosborne
post Jul 21 2005, 05:54 AM
Post #2

UtterAccess Addict
Posts: 206
From: Ohio, USA



Here's what worked for me:

Insert>Object>Create from file

Check "Display as icon"
Make sure "Link to file" is unchecked. If it is checked and you delete the file, it will not open because all you have created in your Excel document is a link to that document (i.e. a shortcut).

Click the browse button, locate the file, click Insert. Then click OK. When you save the spreadsheet, check the file size, it should grow by roughly the size of the pdf file you inserted.

I hope this is solves your issue.

Scott
Go to the top of the page
 
+
parora1
post Jul 21 2005, 06:04 AM
Post #3

UtterAccess Enthusiast
Posts: 57
From: Toronto, Ontario, Canada



Scott, thanks for your response, howeover that does not seem to work. I am able to follow the steps above, and then I purposely delete my document on my drive, and then I can't open it via Excel any longer. Please let me know if you have any other thoughts.

Thanks.
Go to the top of the page
 
+
doctor9
post Jul 21 2005, 06:50 AM
Post #4

UtterAccess VIP
Posts: 9,304
From: Wisconsin



Often I will create PDF files out of my spreadsheets, but I've never tried going the other way.

Excel is an analytical tool that can have graphics hovering over the data cells, but it's not really designed to store an entire PDF inside of it.

Not knowing just how much function has been built into this particular PDF, I'll assume it's just pages of text and drawings, not interactive forms or animations. If your PDF is small enough (less than ten pages, say), you may want to just convert it to a series of graphic pages, and insert the pages one at a time with the Insert->Picture->From File... menu item. Adobe Acrobat has an easy to use Save As... feature that will let you save pages as JPGs or other graphic types. (Not Acrobat Reader, but the full version of Acrobat, of course.)

Dennis
Go to the top of the page
 
+
sdosborne
post Jul 21 2005, 08:07 AM
Post #5

UtterAccess Addict
Posts: 206
From: Ohio, USA



No thoughts right now. I followed the steps exactly as listed and deleted the pdf from my machine. I was still able to open the document by double clicking the icon in the Excel document. I wish I could be of more assistnace.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 11:24 AM