Discussion:
Visio 2003: Getting Formula from cell as String
(too old to reply)
Udo
2007-01-07 13:10:32 UTC
Permalink
Hello,

I need a formula from a cell as string in a user-defined cell
for further (string-)processing. Is that possible?


Thanks and greetings
Udo
Chris Roth [MVP]
2007-01-08 19:35:03 UTC
Permalink
Hi Udo,

There is no way to get a formula-as-text in the ShapeSheet that I know of.
If Visio understands the text in a cell as a formula, then it get's parsed
and tokenized and is no longer really "just a string"

You would have to use automation code, VBA, etc.and get the Cell.Formula
property.
--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/
Post by Udo
Hello,
I need a formula from a cell as string in a user-defined cell
for further (string-)processing. Is that possible?
Thanks and greetings
Udo
Loading...