How to insert PDF file into Excel file

Help
1

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

image
image862Ă—428 20 KB

2

Refer this

2 Likes
3

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.

image
image693Ă—467 21 KB

4

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
5

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

6

If it works - mark “as solution”

7

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

8

@vvaidya

I ran the above code which you have attached. in Finally, The PDF is not saving in that excel ?
what is the error in it ? Please let me know the solution?