hyperlink to open pdf files in excel

sharathnarayanan

New member
Joined
Nov 3, 2014
Messages
2
Reaction score
0
Points
0
Excel Version(s)
MS 2019
Hello everyone,

Need help with a formula to open pdf files for the list in excel. A sample sheet is attached for your reference.

Thanks in advance!
 

Attachments

  • sample file.xlsx
    26.4 KB · Views: 11
try this in H2, replace JoBlow with your user name

=HYPERLINK("file:///C:\Users\JoeBlow\Documents\Transmittals"&A2&"-"&B2&"-"&C2&"-"&E2&"-"&F2&" "&G2&".pdf","ClickHere for pdf")
 
Oops
=HYPERLINK("file:///C:\Users\JoeBlow\Documents\Transmittals\"&A2&"-"&B2&"-"&C2&"-"&E2&"-"&F2&" "&G2&".pdf","ClickHere for pdf")
 
cross posted without links:

hyperlink to open pdf files in excel
https://www.msofficeforums.com/excel/47184-hyperlink-open-pdf-files-excel.html
Hyperlink in excel to open specific folders
https://www.excelforum.com/excel-fo...cel-to-open-specific-folders.html#post5531104
hyperlink to open pdf files in excel | MrExcel Message Board
https://www.mrexcel.com/board/threads/hyperlink-to-open-pdf-files-in-excel.1174224/

sharathnarayanan, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184
 
Back
Top