Name/NameU/ActiveWindow.Page= Phenomenon

[Paul V]

I have a complicated case that I reduced down to the following simple case.

Start Visio with blank drawing.
Have 1st page: Name "Page-1", NameU "Page-1"

Insert new page -- name it "abc"
Have 2nd page: Name "abc", NameU "abc"

Rename 2nd page to "def": Name is "def", NameU is "abc"

Rename 1st page to "abc": Name is "abc", NameU is "Page-1"

View page abc then:
ActiveWindow.Page = "abc"
This takes you "def"

View page abc then:
ActiveWindow.Page = "def"
This also takes you "def"

i.e. ActiveWindow.Page = seems to looks at NameU first, then Name

My guess that is an undocumented "feature" rather than a "bug," but is
surprised me.

Comments?

Paul

 

[Paul V]

Argh!

After further review is appears that this behaves differently in 2002 SP2
than 2003 SP1. The behavior in 2003 SP1 is as described in the original
post. In 2002 SP2 it appears that ActiveWindow.Page = looks only for Name
and not for NameU at all. In 2003 SP1 it looks for NameU first then if not
found looks for Name.

Again, can anyone comment on this?

Thanks.

Paul

 

[vojo]

Yes...this feature is definitely the result of having one of NASAs
finest actually thinking about how people would actually use it.

A similar one is that peer shapes use their name but subshapes in the
group use the sheet name no matter how hard you try to fix

Another piece of rocket science is that there is not relative or
inderect cell reference in a shapesheet so you could use some local
cell that contained the handle of a far off shape to provide the
"sheet.x" peice of the reference. Even if a special section to be
added to a shape where this section contianed all the handles that all
other sections in that shape could use (via a formula if nothing else)
would be helpful.