cell reference with multiple pages

[Ergun]

I am using visio 2002 prof. ed. and cannot reference a
cell in another page... need help

example
Name of the first page is Page-1
Name of the second page is Page-2

I am in a shapeheet of an object in Page-2 .

following formula in the cell returns with error
Pages[Page-1]!Chair.34!User.Row_1

Note that I have onject Chair.34 in Page-1 and I am trying
to reference a cell in its shapesheet...

Cheers

 

[Mark]

To reference in code, you must first make that page active.

i.e. ActiveWindow.Page = vsoPage.Name

setting of course vsoPage to page-1

 

[Ergun]

Mark,
Thanks, I guess my question was not clear... I am trying
to access another page's shapesheet from a shapesheet
without using VBA. ..

According to Visio's developer guide the format for the
formula to access another page in shapesheet is:

Pages[Page-1]!DrawingScale

but this format does not work!!!

I need to do this in the shapesheet not in VBA...

Cheers

Ergun

-----Original Message-----
To reference in code, you must first make that page active.

i.e. ActiveWindow.Page = vsoPage.Name

setting of course vsoPage to page-1

-----Original Message-----
I am using visio 2002 prof. ed. and cannot reference a
cell in another page... need help

example
Name of the first page is Page-1
Name of the second page is Page-2

I am in a shapeheet of an object in Page-2 .

following formula in the cell returns with error
Pages[Page-1]!Chair.34!User.Row_1

Note that I have onject Chair.34 in Page-1 and I am trying
to reference a cell in its shapesheet...

Cheers
.

.

 

[Mark Nelson [MS]]

You will not be able to use the shape name Chair.34 in your cross-page
reference, but you should be able to use its generic NameID which is
Sheet.34.

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Mark,
Thanks, I guess my question was not clear... I am trying
to access another page's shapesheet from a shapesheet
without using VBA. ..

According to Visio's developer guide the format for the
formula to access another page in shapesheet is:

Pages[Page-1]!DrawingScale

but this format does not work!!!

I need to do this in the shapesheet not in VBA...

Cheers

Ergun

-----Original Message-----
To reference in code, you must first make that page active.

i.e. ActiveWindow.Page = vsoPage.Name

setting of course vsoPage to page-1

-----Original Message-----
I am using visio 2002 prof. ed. and cannot reference a
cell in another page... need help

example
Name of the first page is Page-1
Name of the second page is Page-2

I am in a shapeheet of an object in Page-2 .

following formula in the cell returns with error
Pages[Page-1]!Chair.34!User.Row_1

Note that I have onject Chair.34 in Page-1 and I am trying
to reference a cell in its shapesheet...

Cheers
.

.

 

[Patrick Arkins]

Mark, Ergun - Your conversation seems to get me close to
solving a problem:

Should the same concept work if I want to display the name
of every page in a Visio file (the name I gave each page
on the "Tab") in a table?

Or, is there an easier method to create a "Table of
Contents?"

I suspect I may just be having syntax trouble, but when I
try every variation of =PageName(Sheet.2) =PageName(!
Sheet.2!) =PageName()!Sheet.2 I can think of, I constantly
get an error when attempting to Accept the Formula in the
ShapeSheet value field.

Thanks

Patrick

-----Original Message-----
You will not be able to use the shape name Chair.34 in your cross-page
reference, but you should be able to use its generic NameID which is
Sheet.34.

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Mark,
Thanks, I guess my question was not clear... I am trying
to access another page's shapesheet from a shapesheet
without using VBA. ..

According to Visio's developer guide the format for the
formula to access another page in shapesheet is:

Pages[Page-1]!DrawingScale

but this format does not work!!!

I need to do this in the shapesheet not in VBA...

Cheers

Ergun

-----Original Message-----
To reference in code, you must first make that page active.

i.e. ActiveWindow.Page = vsoPage.Name

setting of course vsoPage to page-1


-----Original Message-----
I am using visio 2002 prof. ed. and cannot reference a
cell in another page... need help

example
Name of the first page is Page-1
Name of the second page is Page-2

I am in a shapeheet of an object in Page-2 .

following formula in the cell returns with error
Pages[Page-1]!Chair.34!User.Row_1

Note that I have onject Chair.34 in Page-1 and I am
trying
to reference a cell in its shapesheet...

Cheers
.

.

.