Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: bruceam on June 18, 2021, 03:54:11 PM

Title: ShapeSheet Results Data to a File
Post by: bruceam on June 18, 2021, 03:54:11 PM
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.
Title: Re: ShapeSheet Results Data to a File
Post by: Surrogate on June 18, 2021, 05:10:21 PM
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
Title: Re: ShapeSheet Results Data to a File
Post by: wapperdude on June 19, 2021, 01:28:56 AM
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.