My Assistant
![]() ![]() |
|
|
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. |
|
|
|
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 |
|
|
|
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. |
|
|
|
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 |
|
|
|
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 Top · Lo-Fi Version | Time is now: 25th May 2013 - 11:24 AM |