interrogate shape info using vba

[Thomson]

Hello all,

I'm a newbie to VBA, I'd posted a question on th ShapeSheet forum, and Paul
had given me some good directions. But unfortunately, I still couldn't do
what I hope to achieve.

How could I get info from a ShapeSheet's cell with VBA? And how could I use
VBA to change the value of the cells?

Any help would be appreciated.

Cheers,

 

[Al Edlund]

There are examples for reading and setting custom properties (shape data) in
the visio sdk which can be downloaded from msdn. Cell interrogation for the
other cells is pretty much identical.
al

 

[Chris Roth [Visio MVP]]

Hi Thomson,

There is a (hopefully) straightforward example on my web-site that walks
you through many of the usual tasks that Visio developers need to perform.

Create Visio Flowcharts Programmatically
http://www.visguy.com/2006/09/13/create-visio-flowcharts-programmatically/

The one thing it doesn't do is read info from cells. This, however, is
just the reverse of writing cells, and as Al said, once you know how to
read one cell, you know how to read them all.

In the article, search for "Set custom properties" to get to the stuff
you're looking for!

--
Hope this helps,

Chris Roth
Visio MVP


Visio Guy: Smart Graphics for Visual People

Articles: http://www.visguy.com
Shapes: http://www.visguy.com/shapes
Dev: http://www.visguy.com/category/development/
Forum: http://www.viguy.com/vgforum