Cannot insert content of PDF in document

[Steve Bayliss]

Hi All,

This is actually a problem that is effecting not just Excel but all office.

I am trying to embed the content of a PDF into the workbook - I totally understand that I will only get the first page of the document, thats all I want as the PDF is always one page in length.

I am using Insert / Object, Create from File, Browse and select PDF, I DO NOT check the boxes Link to File or Display as Icon.

The result is I get an icon displayed and not the content of the PDF. This use to work fine.

The icon can be double clicked and the object will open fine.

When the icon is selected the formula bar displays =EMBED("Packager Shell Object","")

I am using Windows 7 / Office 2013

Others computers in the organisation are having the same issue but then some are OK.

The computer has Acrobat Reader DC, PDF X-Change editor and PDFCreator installed.

I have changed the default program association for PDF to Acrobat Reader and PDF X-Change but still the same results.

I have tried to turn off a number of security settings in Acrobat and PDF X-Change to no avail.

I don't have admin rights so I can't install or uninstall anything.

So, any idea anyone???

Regards

Steve
QLD Australia.

 

[rlv01]

I DO NOT check the boxes Link to File or Display as Icon.

Why not? I find that I have to check "display as icon" if I want a clickable icon to display the pdf file.

 

[Steve Bayliss]

Hi,

??? I don’t want a clickable icon, I want the content. Regardless of the whether I click ‘Display as Icon’ I always get just an icon.

Steve.

 

[rlv01]

I have full admin rights, and my PC behaves the same way. I think you may be looking at taking a screen grab of the PDF doc and pasting it in as a graphic image.

 

[sandy666]

maybe try:
Insert - Object - Create New - (select: Adobe Acrobat Document) - OK - select pdf file - Open
it will open Adobe Acrobat (close it) and you should see pdf file embeded in excel sheet.

see link: pdf embeded in excel sheet

 

[Steve Bayliss]

Hi,

Thanks for your reply. Yes, I had tried that earlier as a test and it does work. Unfortunately, I need the process to be automated so I can’t use that technique. It is all very strange as this use to work well.

Hopefully I will eventually work out the issue as there are still a few pc’s where it is working but I can it is going to a painful trial and error process to track it down and was hoping someone had already experienced the problem.

If I work it out I’ll surely post what I discover.

 

[sandy666]

it won't work if you want embed pdf second time (after deleting first embeded object) but I didn't check it too much.
to automate this try vba - but I don't use vba and I can't help

good luck