I have written many COM and VSTO add-ins for Visio, but got confused when a client recently reported that the following Custom UI Runtime Error was appearing. I wasn’t getting the same error on any of my test laptops, so I chatted with my good friend, and fellow Visio MVP, John Goldsmith ( John Goldsmith’s visLog (typepad.co.uk) ). He gave me an excellent tip….[Read more…] about Spotting Custom UI Errors in Visio Add-ins
The Microsoft Visio product team have released a great video introduction to the Visio Data Visualizer, but even that does not reveal all of its power. So, here are some tips about using the Microsoft Visio Data Visualizer add-in in Excel. Firstly, the add-in currently offers three different types of diagram, and each have a number of alternative layout arrangements.
- Basic Flowchart – 4 layouts
- Cross-Functional Flowchart – 5 layouts
- Organization Chart – 5 layouts
Although these are the proposed diagram types, there is no reason why other types of data, such as network devices, cannot be used with any of them.[Read more…] about Visio Data Visualizer Tips
Update 1 : Microsoft read this post and immediately corrected the spelling so the following now works : https://adoption.microsoft.com/virtual-hub/search/?_sft_vh_product=microsoft-visio 🙂
Update 2 : Mr VisGuy! “spelt” is the same as “spelled” outside USA!
Aarghh! What kind of message is sent out if a company does not know how to spell the name of their own product? There is a make of TV in the States called Vizio, which is not the name of my favourite data-diagramming application, Visio. It may be pronounced the same, but believe me it is totally different. So, it is extremely disappointing that Microsoft have allowed their own product to be spelt incorrectly in the Virtual Hub in the Microsoft Ignite 2020 website.[Read more…] about Visio is NOT Vizio!
I recently wrote a series of articles about some of the new capabilities of the Visio desktop and web app.
I work a lot with layers in Visio, and written an add-in, LayerManager, to assist, but I was asked an interesting question recently: How can shapes by assigned to layers automatically from a list in Excel? So, I thought I would present my solution. This particular request was for a Timeline diagram, where the Milestone shapes are to be on specific layers. So, I just used one of the samples provided with Visio.[Read more…] about Assigning Visio Shapes to Layers from Excel Table
Microsoft Visio does have CHAR() and UNICHAR() ShapeSheet functions, just like Excel, but it does not have the inverse CODE() and UNICODE() functions, unlike Excel. However, there is a way to create a formula in the Visio ShapeSheet to provide these functions.
The following worksheet demonstrates how the CHAR(), CODE(), UNICHAR(), and UNICODE() functions work in Excel.