Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: FFC on June 02, 2016, 03:36:30 PM

Title: How to link shapes through different pages
Post by: FFC on June 02, 2016, 03:36:30 PM
In the shapeSheet of a shape, we can write in a cell something like Sheet.51!User.Row_1 to access the Row_1 of the shape #51. But that only work if both shapes are in the same page.

How do I get data from one shape to another when they are not in the same page?

I wanted to use the Setatref() function to link shapes and it work well on the same page but now i need to do it with shapes on different pages.

Any ideas?


FFC
Title: Re: How to link shapes through different pages
Post by: Surrogate on June 02, 2016, 04:07:55 PM
you can use syntax like as
QuotePages[Some_PageName]!sheet.51!User.row_1
Title: Re: How to link shapes through different pages
Post by: wapperdude on June 03, 2016, 12:38:57 AM
This article covers how to reference most anything in Visio shapesheet:  https://msdn.microsoft.com/en-us/library/office/ff768760.aspx

Wapperdude
Browser ID: smf (is_webkit)
Templates: 1: Printpage (default).
Sub templates: 4: init, print_above, main, print_below.
Language files: 1: index+Modifications.english (default).
Style sheets: 0: .
Hooks called: 50 (show)
Files included: 25 - 925KB. (show)
Memory used: 747KB.
Tokens: post-login.
Cache hits: 8: 0.00122s for 22,292 bytes (show)
Cache misses: 3: (show)
Queries used: 12.

[Show Queries]