My previous post showed how to link Visio Timelines to a SharePoint Calendar ( http://bvisual.spaces.live.com/blog/cns!3350D61BC93733A9!552.entry ), and I glibbly mentioned how you can create hyperlinks automatically on the shapes from the SharePoint list. Well, that was true, but the example shown goes to a SharePoint page, and it didn’t work. So, I feel I need to demonstrate a fix for it.
The ShapeSheet formula in the hyperlink address cell is:
This translates to the URL:
Well, this does not actually work from Visio, but, navigating to the entry in the SharePoint calendar shows that the actual URL is:
… and this can be reduced to:
So, how can we correct the URL for the Visio shapes?
We will need to write a little bit of code to change the formula in the hyperlink Address cell to :
This will change the URL to actually open the SharePoint page, like this:
I will write the code when I can get my Office programs working again….
Leave a Reply