A couple of things to try (may not be acceptable to you!) look here for some code and explanation on how to prevent the hyperlink firing and you can also use the msoMethodGet ExtraInfo which is a String that's appended to the address.
found here so you could use the string as the workbook name to open!