bVisual

bVisual Blog by David Parker

Published on by

The Importance of the 2-Dot Rule in Visio Addins

First of all, I must say that I was unaware of this rule for many years, and that is probably because I started programming Visio in VBA back in the mid ’90s. VBA is built in to Visio like other Microsoft Office applications, and as such, it has a direct uninterrupted access to the Visio Api. It is very chatty by nature, and has immediate access to all the events in the Visio Api. Therefore there is little extra cost in using multiple nested reference to Visio objects, however VSTO Addins do not have this luxury, and the C# code gets access via the .Net Framework. This is an extra layer that calls to the Visio Api need to go through, and these calls need to cross the COM boundary multiple times if the they are chained together with more than 2-dots. So what does that mean in practice? Well, every crossing of this boundary takes time, and it all adds up. So, I asked AI to explain more about the importance of abiding by the 2-dot rule….

[Read more…] about The Importance of the 2-Dot Rule in Visio Addins

Published on by

Introducing a free Visio Report Runner application

AI is changing the world and how we should approach it. So I decided to see if I could get Claude Sonnet 4.6 Agent to completely write an application for me, and I mean completely. The application is written in Python by Claude, and I have not written a single line. The code is available at github.com/davidjpp/Visio-Report-Runner/ and it enables any Windows user, with Microsoft Excel installed, to run some types of reports from any Visio document (*.vsdx).

  • First, select a Vissio document
  • Displays the Visio preview image
  • Report definitions list
  • Simpple instructions
  • Saving an Excel report
  • Example list of qualifying items
  • Selecting a report definition and page
  • Example Summary report
[Read more…] about Introducing a free Visio Report Runner application

Published on by

Protecting the integrity of custom Visio masters

All of my Visio solutions contain custom masters because this is the best way to create smart shapes that respond to user’s needs. This usually means creating Shape Data, User-defined Cells and Action rows that govern aspects of the shape with formulas designed to provide an efficient user interface. As a developer I sometimes forget that other users may not perform the same actions as I do, and can accidently undo all my intended behaviour. For example, in recent testing of a visual stream mapping system that I am working on, my carefully constructed master-shape relationship was being broken by grouping some of them together, thus changing their behavior and hiding them from some of the custom functions. The reason given was to that they want to create copies and this seemed like a reasonable way to do it. Now, I have known that this is bad ever since my original Visio developer training back in 1996, so I always avoid doing this, and erroneously thought that other would know this too. I was wrong to be so myopic, so I explored how I can best prevent this and other user actions that could break the intended master-shape relationship.

  • Multiple instances of a single master shape
  • Locking some properties of the shape
  • Modifying group behaviour
[Read more…] about Protecting the integrity of custom Visio masters

Published on by

Docked Stencils in Visio for the Web

Visio desktop has multiple ways to specify the folder where docked stencils can be found, but, as far as I am aware, Visio for the Web only has one. I mostly create VSTO add-ins for Visio desktop, and I use Visio desktop as a studio for creating templates for Visio for the Web. Often, I leave the Document Stencil in the template open because users can then drag and drop from there, but when I create an installation with custom stencils then they normally go into the application folder, or a sub-folder of it. An alternative is to install them into the My Shapes folder in the users desktop Documents folder. These will appear in the Visio desktop UI. Also, there is the ability to set the Stencils folder using File | Options | Advanced | File Locations. Finally, the desktop edition will always first check the folder that the Visio document is in for any docked stencils. Visio for the Web does not have all these options, so how do you get any custom docked stencils to appear when you use Visio for the Web to edit a document?

  • Visio desktop with docked stencils
  • Visio web viewer
  • Visio for the web with missing stencils
  • Visio for the web with stencils
[Read more…] about Docked Stencils in Visio for the Web

Published on by

My Visio Books and Old pre-C# Work

We, as a family, are in the process of de-cluttering our house for hopefully a move closer to the south coast, so I decided to take a photo of my Visio books collection, and as you can see, back in the mid-1990’s, I started reading and learning from other peoples works, and then progressed to writing my own from 2007. This shows how mature the Visio desktop product is, and as very little has been removed, then each book has something to learn.

[Read more…] about My Visio Books and Old pre-C# Work

Published on by

Migrating from Lucidchart to Visio?

My fellow Visio MVP, Michel Laplane, and I recently converted and transformed 15k Lucidchart documents to Microsoft Visio for a large multi-national organization. This was approximately 4 years after they had moved from Visio to Lucidchart! I do not know the full reason behind these changes in technology, and I do not have a particular dislike of Lucidchart, but my passion is Visio, so I was willing to assist SohoDragon in this migration for their client. The Lucidchart application is solely a web-based diagramming system with the documents stored in AWS, so perhaps it does not fit easily within the corporate compliance architecture of Microsoft Azure, Teams and SharePoint. Microsoft Visio though has the same files for both the desktop and web editions, although there are some restrictions in the size and features of editing Visio document in the web. However, all the M365 users will have the ability to view and comment of the Visio documents that they have permission for. Visio Plan 1 or Plan 2 subscriptions will be required for editing the migrated documents because they have not been created with the templates provided in Visio for M365, and Visio documents which have any page with over a thousand shapes will currently only be editable in the Visio desktop edition. The Lucidchart documents needed to be audited, exported and transformed into Visio documents, and then uploaded to similar folders in SharePoint, where user permissions could be applied. We decided to use multiple secure Windows VMs to process the documents and then upload them to SharePoint before the VMs were deleted.

[Read more…] about Migrating from Lucidchart to Visio?