Hyperlinking Pdf files to an Excel Colum

llleo

New Member
Joined
May 9, 2018
Messages
4
Hello Excel Experts!!

As I have no experience in coding whatsoever, I am here to seek assistance.
I am trying to create a function such I can hyperlink and open pdf files directly from an excel spreadsheet.

There is a Main Directory containing the "Excel file" and a Sub-folder containing all the pdf files. This Subfolder further has folders (namely as years e.g. 2017, 2018) to organize the PDFs.

Is there a way to create an excel function/VBA code to link files across the sub-folder directories. We plan to use different Excel sheets (namely as years e.g. 2017, 2018) to link to the respective directories in the subfolder.

It maybe that we need to re-run the code/function to refresh the hyperlinks. Also the names to PDF are following a series but some can have extensions e.g. Rev1, Rev2 and so on.

Looking for suggestiouns and solutions from the experts out there.


Many thanks!!
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top