Excel programming

starview
starview used Ask the Experts™
on
I have and excel spreadsheet that has the name of the following colums, Titie, date,Level, person, PDF
These are Titles of files I have on hand.
Date when they where made
Dance level of the files
Persons name who made the file
PDF file.

My question is is there a way to have the column that say PDF
be click and it would display the PDF file for that row of information?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
Hello starview,

You could put a hyperlink formula into that PDF column:

=HYPERLINK("c:\folder\subfolder\filename.pdf","Friendly name here")

If you provide more detail about the files and locations I may be able to help further.

Regards,

Patrick
Cory VandenbergSenior Risk Manager
Commented:
When you say on hand, I'm guessing you mean you have them on your local drive or on a server, but I also thought perhaps you mean they are embedded directly in the workbook.

Unlikely as it may seem, if that is the case, you should take a look at this solution for an example of how to open embedded objects with the use of a OLE label formatted to appear like a hyperlink.

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_24662945.html

Cheers,
WC
Cory VandenbergSenior Risk Manager

Commented:
Meant to say ActiveX label......late on a Sunday... ;)
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Author

Commented:
How do you embedded a file into excel?
Cory VandenbergSenior Risk Manager

Commented:
Go to Insert->Object

Select "Create from file" and then browse to find your pdf.

WC
Commented:
Secect the cell you want to have the PDF in.

Go to insert ,
click object,
Select adobe acrobat document,
tick the box saying Display as icon

Find the file and click open.

That should be it.

Author

Commented:
Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial