• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help - Embedded PDF file into spreadsheet

H

Hurtgy

New Member
Hello. I am wanting the best of both worlds so I don't know if this is possible, however I am going to ask. I have a large spreadsheet that I want to have multiple pdf files inserted for reference-this file will be sent to many different people. I want the files to look like a hyperlink and not an icon. I got it to work by inserting object, etc. however does anyone know if I can do this so it looks like a hyperlink? It would be much cleaner of a spreadsheet if that is possible! I might be dreaming but I want to ask for help :)
 
So I got it to work for my first pdf but if I want to do multiple, do I have to do this coding for each file?

Private Sub Worksheet_Activate()
ActiveSheet.Shapes("Object 1").Select
Selection.Verb Verb:=xlPrimary
End Sub
 
Also the hyperlink is working correctly on my computer but when I send it to someone else it doesn't automatically open
 
Should the below help?
Insert the full name(along with the path) in a cell
in the besides it update the formula like the below
=Hyperlink(address cell, Display name)..

Hope this helps...:)
 
Hurtgy said:
So I got it to work for my first pdf but if I want to do multiple, do I have to do this coding for each file?

Private Sub Worksheet_Activate()
ActiveSheet.Shapes("Object 1").Select
Selection.Verb Verb:=xlPrimary
End Sub
Click to expand...

Yes and no. Each PDF will need to have it's own sheet and code. Note that not all of the object will have the same name. You can click on the object once to see the name appear in the Name box (top left of worksheet).
 
Ok so that isn't going to work as I have multiple pdf files. Hmmm, I am thinking my pretty little dream isn't much of a possibility. I REALLY appreciate your help though!
 
Oh well. One final thought is to just have all the objects/icons on some sheet, and you create links to the cell where the object is at, and then the user click on it. It makes the front end look a little nicer maybe...but again, not sure it's worth the effort.
 
You must log in or register to reply here.
Back
Top