Hi all,

I have a sheet that automatically creates a hyperlink based on the combination of reference number and year in that row. However, if I add more information to the sheet, because the information is new the hyperlink exists, but the target folder doesn't yet. If I click on the hyperlink, I get a message "Cannot open the specified file". Then I have to manually create a file in the directory so that the link works.

Is there a way of circumventing this error. If the folder does not exist, I want the option of creating a new folder instead of the error.

I really don't know if this is possible or not. I presume not but I figured I should check first before abandoning hope.

Cheers boffins.
Rob