ShapeSheet Results Data to a File

Started by bruceam, June 18, 2021, 03:54:11 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

bruceam

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.

Surrogate

#1
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

wapperdude

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

From Visio to Excel:
http://visguy.com/vgforum/index.php?topic=7302.msg30745#msg30745
http://visguy.com/vgforum/index.php?topic=7572.msg32083#msg32083

...and there are more.
Visio 2019 Pro