To be able to create the Visio Visual Section document meant, I needed to mine the information from Visio shapes. The easiest way was to let loose CellsSrc() on a series of shapes and let the code create a file of what it found. Visio is big on using enumerations, but they are not goodContinue reading “Visio Shape Explorer”
Tag Archives: VBA
Whose my parent?
Sorry David, no pictures this time. This is a very quick post. I came across a Stack OverFlow question. The user had a shape that contained other shapes and wanted how to reference the parent shape. The posted answer…. Although there nothing like “parent”, you can use shape id directly. You need to find theContinue reading “Whose my parent?”
I need a break
I was programming Visio almost from the beginning. At the time it was in C. Around version 3, Visio was the first non MS product to fully implement VBA, including the macro recorder. When VBA was introduced, I was hooked. I could quickly automate Visio. Well almost, they did not trap the Break key. YouContinue reading “I need a break”
Format Code Sampler
I have been exploring Format Codes in Visio and have created a download to make a Visio Format Code Sampler. The files are in Downloads.. This is a first draft and I will be updating it. I just wanted to get it out the door. 😉
The adventures of Visio section shapes continues
A while back I created a stencil of Visio section shapes. They were based on screen shots of the Shapesheet, I added control handles to adjust “cell” widths. The cells content was stored in Excel. I then loaded the “cell” contents from Excel. So, I had shapes that looked like Shapesheet sections, but they hadContinue reading “The adventures of Visio section shapes continues”
Stacking Shapes
One thing that is missing in Visio, is the ability to stack shapes. You can align shapes on the top, bottom, left or right edges, but you can not stack. To stack two shapes, you have to drag a guideline from the top ruler and then place the bottom edge of one shape on theContinue reading “Stacking Shapes”
I need an OED
I have enhanced the Visio stencil shapes so that each shape has custom properties (AKA Shape Data) that is pulled down to the various cells in the shape. I have also updated how the Control Handles that control the width of the cells work. So,I now have a stencil of Visio section shapes that IContinue reading “I need an OED”
ShapeSheet Shapes
A lot of people only know Visio as an app to create business diagrams with clip art and connecting lines. Some have realized you can connect the diagram to a data source like Excel and bring life to the content. Some have also realized you can add embellishments to the shapes called Data Graphics thatContinue reading “ShapeSheet Shapes”
Visio Stencil Sort
One of the things I noticed when reviewing Visio’s User Voice was the request for being able to have the shapes (they are actually masters) in the stencils be sorted. This is some code I have for keeping the masters in the document stencil sorted. Here is the before and after.
Adding Shape Data to a series of new shapes
I have been playing with Visio Visualization in Power BI and the first step is to create a Visio drawing. Basically it is a bunch of shapes, but I need to add Shape Data to the new shapes, basically the key that will link the shape to the row of data in Excel. I couldContinue reading “Adding Shape Data to a series of new shapes”