Forum Discussion
Dynamic Hyperlink: open a document (with the same value as in the cell) in a folder via a cell value
Hello, I want to be able to open a document via a dynamic hyperlink. In an Excel file I have 1 fixed cell that always contains a different article number after it has been selected from a lis...
If I understand your goal correctly, you could explore setting a hyperlink base for the workbook.
Work with links in Excel - Microsoft Support
See: Set the base address for the links in a workbook
With a base set, you'd only need to refer to the file name in the fixed location.
Patrick2788
Thanks for your option!
But in my workbook I have multiple links to other folders.
So, if I understand this option correct (wet the base address for ALL the links in my workbook) then this does not work for me.
But thanks for your thoughts!
Thanks for your option!
But in my workbook I have multiple links to other folders.
So, if I understand this option correct (wet the base address for ALL the links in my workbook) then this does not work for me.
But thanks for your thoughts!