How can I add PDF file to the Excel sheet (dont want link, but embedding it)

[hacky (NotHacker)]

Hi Team,

I am working on a project where I need to add a PDF file into the excel sheet.

I have been trying VBA script but it does not work as I want.

Pplease help.

[ashokkarale]

@hacky,

Refer these solutions

Insert a PDF document into excel cell of a specific sheet of a workbook

Hello @MANISHA_V_ARORA , Maybe these posts helps you: Vasile.

How to insert pdf file into excel using macros

Hi @prachi, Macros VBA is very specific to the individual requirement, so it is difficult to give general advice that will work across use cases. Hopefully, to get you on the right path, you can consider the following general VBA script. To embed objects in the cells. Sub AddingObjects() Range("A1").Select ActiveSheet.OLEObjects.Add(Filename:= " <Path of your PDF> " _ ,Link:=True, DisplayAsIcon:=True, IconFileName:= _ "C:\WINDOWS\Installer\{AC76BA86-7AD7-1033-7B44-AC0F074E4100}\PDFFile_8…

[prashant1603765 (Prashant Kumar)]

Hi @hacky

Check this link ,

How to insert pdf file into excel using macros

Hi @prachi, Macros VBA is very specific to the individual requirement, so it is difficult to give general advice that will work across use cases. Hopefully, to get you on the right path, you can consider the following general VBA script. To embed objects in the cells. Sub AddingObjects() Range("A1").Select ActiveSheet.OLEObjects.Add(Filename:= " <Path of your PDF> " _ ,Link:=True, DisplayAsIcon:=True, IconFileName:= _ "C:\WINDOWS\Installer\{AC76BA86-7AD7-1033-7B44-AC0F074E4100}\PDFFile_8…