Author Topic: ShapeSheet Results Data to a File  (Read 6766 times)

0 Members and 1 Guest are viewing this topic.

bruceam

  • Jr. Member
  • **
  • Posts: 20
ShapeSheet Results Data to a File
« on: June 18, 2021, 10:54:11 AM »
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

  • Hero Member
  • *****
  • Posts: 1803
    • ShapeSheet™ Knowledge Base
Re: ShapeSheet Results Data to a File
« Reply #1 on: June 18, 2021, 12:10:21 PM »
Many years ago i use tool named celMaker by David J Parker
Quote
celMaker 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
« Last Edit: June 18, 2021, 12:31:33 PM by Surrogate »

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4837
  • Ideas Visio-lized into solutions
Re: ShapeSheet Results Data to a File
« Reply #2 on: June 18, 2021, 08:28:56 PM »
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