Hyperlinks between open Workbooks fail in OneDrive

This issue exhibits in Excel 2019 (not necessarily 365).

I open 2 workbooks and want to create a hyperlink in each workbook that links to the other in a OneDrive environment and takes the user between them.

The hyperlinks are created but will only activate if the workbook being called is closed. On the other hand, if already open I get an error message to the effect that Excel cannot "open the workbook". Presumably, because it is already open. The current code is shown below.

Any solutions gratefully received.

Please Login or Register  to view this content.

Hi Stephen,
I think the problem lies in the fact that when you created that file with your AddIn the path to the your one drive environment is set which is not necessarily the same at the user's end.
When you have the app installed you can tell it where you want the synced files to be store, in my case is a dive G with a subfolder _webstorage and there another named OneDrive

This is what is set the hyperlink

I was looking into it too and what might be possible is that the file's full name be read at all times when it's opened in let's say fixed cell of both your Data sheets and have the hyperlink refer to that cell as 'source'
Probably a something to test.
I'll try it out and let you know.

Hi Hans

Yes, I recognised that as a potential problem. However, I created these test files manually to avoid that that issue.

It also possible the conversion Function from an "https://" string to a "C:\users" string is part of the problem. It's not my function but it works very well in tests. However, I included code just in case there is a problem there that I haven't recognised.

One thing I also need to dentify, is whether there are similar issues in Office 365.

Stephen

I don't have Office 365 but will check with a friend's account.
If he allows me to access their account I will be able to do some tests and let you know.