Hyperlink macro linking other file

[IKZOUHETNIETWETEN]

I have an autocreating hyperlink (see short code below) but it creates a hyperlink to a file inside the folder where the excel file is. (autosave). But I want it to be linked to the file that is saved manually by the user. (see bigger code below) (right after the auto save). Try pressing on the 'Opslaan' Macro, and you will see what I mean. Anyone has an idea to link to the file where its saved manually? Basically its the same address as in Columns B and C, thats what the address/destination of my hyperlink should be, right now its the folder of the excel file.. Thanks!!

Kopie van Werkorders - Copy.xlsm

Please Login or Register  to view this content.

Please Login or Register  to view this content.