Is it possible to have data from one or more ShapeSheet Values of a Custom Smart Shape, to be written/appended to a specified external file. This basic ability would go a long way, but being able to a) format the data for a specific situation, and b) being able to execute this data dump by a keyboard or mouse sequence - would be extremely helpful. I envision the dump format and the file being written/appended to as being specified in the associated shape's "Shape Data" cells, instead of being "Hard Coded" into the ShapeSheet formula's.
In the best of all worlds, I would be dumping a set of ordered pairs (or ordered triples) to either the Excel file or a CSV (Comma Separated Values) text file (which can be easily imported into Excel).
Thank you for your assistance.
Many years ago i use tool named celMaker by David J Parker
QuotecelMaker copies Visio custom properties, user-defined cells and actions to and from Excel.
Microsoft Office Visio shape developers often need to copy custom properties, user-defined cells, actions and connection points from one master to another.
celMaker is a developers tool that allows selected ShapeSheetâ„¢ sections to be documented, verified, enhanced and propagated from one Visio master to another, including the migration of complex formulae. Current version supports Custom Properties, User-defined cells, Actions, Connection Points and SmartTags*.
* Visio 2003 only
but now i cant find it
Have you tried the Data report wizard (whatever it's called)?
Other links that might be useful:
From Excel to Viso via VBA: http://visguy.com/vgforum/index.php?topic=7450.0 (http://visguy.com/vgforum/index.php?topic=7450.0)
From Visio to Excel:
http://visguy.com/vgforum/index.php?topic=7302.msg30745#msg30745 (http://visguy.com/vgforum/index.php?topic=7302.msg30745#msg30745)
http://visguy.com/vgforum/index.php?topic=7572.msg32083#msg32083 (http://visguy.com/vgforum/index.php?topic=7572.msg32083#msg32083)
...and there are more.