Excel – 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”

A few Words of encouragement.

Visio has had reporting capabilities for several versions, but it has not been well documented. There are blogs and videos on how to create a report, so I decided to create a document to provide more details about the file that reporting feature creates *.VRD files. To do that I had to create two WordContinue reading “A few Words of encouragement.”

Help Analyzing Shapes

I have been analyzing a Visio feature in some of the shapes implemented through the shapesheets to understand what is going on and provide guidance for anyone who wants to implement the feature on other shapes. (Sorry Dave no pictures.) The feature involve the User and Shape Data sections, some lists, lookups and nested IFs.Continue reading “Help Analyzing Shapes”

Excel Laundry Tip for Visio

After exploring the Visio Format codes I found the documentation lacking so I decided to create a Format Code Sample shape. It is basically a rectangle with a few hundred User cells that show examples of Format Codes. Most of the codes are obvious, but some require explanation. In addition to the shape, I willContinue reading “Excel Laundry Tip for Visio”

Colour My World Part II

Visio does not handle rows well and lists easily in the shapesheet, you can not do basic things like sorting the rows. So I use my favourite list handling app, Excel. When I need to manage large amounts of shape data, I manage it in Excel and then use VBA to remove the old shapeContinue reading “Colour My World Part II”

Converting from PowerPoint to Visio

Every so often I get requests about copying from PowerPoint to Visio and confusion about why it is not easy. The problem is that PowerPoint, like several of the other Office apps (Word, Excel and Publisher) have the ability to create Visio like drawings. These are not Visio drawings, just drawings that have Visio featuresContinue reading “Converting from PowerPoint to Visio”