Referencing an excel 'cell' value on the shapesheet screen

[Fred]

I have a value in an excel spreadsheet, Test.xls for example at cell 'A1',
that I want to use in the PinX field of a shapesheet. How do I reference the
excel sheet in the shapesheet window? I tried to use
='Path\[Test.xls]Sheet1'!A1 to do this but it didn't work.

Thanks for all your help.

 

[Chris Roth [MVP]]

Hi Fred,

That's a cool idea and it makes perfect sense, but...

I know the ShapeSheet looks like Excel, but unfortunately, you can't do this
directly. You could write some automation code that might be able to do some
sort of linking, but this capability isn't built in.

--
Hope this helps,

Chris Roth
Visio MVP

More Visio shapes, articles, development info and pure diagramming fun at:
www.visguy.com