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”