How to insert PDF file into Excel file

Hello,

To begin with, I would like to thank everyone for their answer.

I have one question, is it possible to insert PDF file (display as icon) into Excel file? For a better illustration I added the picture below.

Kind Regards,

Marek

Refer this

1 Like

Hi @vvaidya, thank you for the info. I have same requirement and i was able to insert pdf files into Excel using the above method. However, all the attachments are being saved at the same position. For example, i have 3 pdf files, and all 3 are getting saved in the same location, even though i specify the Excel Row/column info in the selectors, the pdf files are saving always in the first column. Is there a way to fix this? Thanks in advance.

The below pic shows single file, in fact it has 3 files overlapping on each other.

Two ways :
1.Change active cell position, before inserting the file. Use “tab” or set address directly.
2.Use VBA macros after inserting the file. Like this:

Sub MoveShape()
  ActiveSheet.Shapes("Object 1").IncrementTop 100
End Sub

Sorry for the delay…the first option worked for me. Thank you very much!

If it works - mark “as solution”

Since the initial problem raised by different person, i don’t see an option to “mark as solution”.