VBA – john Visio MVP

Organizing VBA Routines, Sort Of

This is not a routine for just Visio VBA, but it will work for other Office Apps that use VBA. VBA modules do not have to have unique procedure names. As long as you do not Run the module, VBA will not complain. The VBA editor does have a drop down alphabetical list for theContinue reading “Organizing VBA Routines, Sort Of”

History of Visio Visual Section Shapes

I have been playing with Visio since 93 when customer support was on CompuServe. With Visio, I could create Business diagrams easily. Before that I was creating the diagrams by using code, including COBOL. Around version 3, Visio was the first non MS company to fully implement VBA, including the macro recorder. So since then,Continue reading “History of Visio Visual Section Shapes”

Updated Custom Property Dump

(AKA Shape Data Dump) Decades ago, I created a simple VBA script to dump a shapes Custom Properties (Aka Shape data). If I wanted to include the Custom Properties Section in documentation I had to run Show Shapesheet and take a screen capture. It was just an image. Since Visio shapes are more flexible inContinue reading “Updated Custom Property Dump”

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. 😉

Is it Metric?

I am working on a blog post about Title Blocks and doing some research on adding a Scale value to a Visio text block and came across an interesting post by the shape miester Visio Guy (AKA Chris) (my usual research method is to review blogs by the Visio MVPs) Detect-drawing-units-in-the-shapesheet In the comments, oneContinue reading “Is it Metric?”

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”

Visio RowType?

I love spelunking through the Visio shapesheet and creating Visio shapes that are more than just plain clipArt. I use CellsSRC() to explore because I can iterate through an entire shapesheet and learn. Though CellsSRC sounds like Cells Source, it actually stands for Section, Row and Cell. Section is misleading. If you look at theContinue reading “Visio RowType?”

Visio Background Check

Another interesting question from the Visio section of Answers. The user wanted to find the background colour of a page. He was using the Backgrounds tab on the Design ribbon. This creates a background page with a name like VBackground-1. So, what he was looking for was the colour of the first shape on theContinue reading “Visio Background Check”