icon

New tool – Visio Import/Export VBA

Hi all,

Have recently have created an extension to import/export VBA code from a Visio drawing or stencil. You can find this useful if you want to track VBA source code changes in your Visio files, like compare current version of the code with the past version. Could make sense to use together with some version control like TFS, Subversion, or GIT.

Extension page:
VBA Import/Export for Visio

Basically the code was inspired by the nice article on excel and CodeCleaner. Unfortunately the code in that article is in a form of a VBA macro, which may sometimes be not that handy  (you’ll need to copy that over and over to every document where you want to use it), and right out of the box that code does not work for Visio. So this extension addresses these issues (you get the code import/export with one click), also it allows you to export code in “ThisDocument”, and supports x64 version of Visio.

The source code of the extension is available on the github:
https://github.com/nbelyh/VisioImportExportVba

prj

Visio project templates updated (Visio 2016, VS 2015 support)

Visio project templates updated to version 1.0.7:

– added support for Visual Studio 2015
– added support for Visio 2016
– Simplified source code (removed extra files, so that project structure is more like vanilla VS).
Unified project wizard. Now there is one wizard to rule it all. It allows you to add (bside the add-in itself) other Visio files/templates in the wizard itself, add name/description, etc. Addin type selection, Visio files selection, setup – from one wizard.
– License support in installer.
– Support for the built-in VS ribbon designer (optional)
– Support for both x86 and x64 in one installer in one MSI (one DLL compiled to “AnyCPU”)
– Support per user/per machine install in one MSI
– Support for project auto-harvesting. Means, DLL version is auto-harvested, COM registration auto-harvested (for COM addin type).
– Support for old Visio versions (without ribbon) is still there.
– Improved messaging and comments.
– Possibility to compile everything even witout Visio installed (COM addin only)
– Support for installer UI type selection (basic cases)
– Support for installer language
– No more GUIDs in the installer. All is auto-generated on build.
– Addin project is referenced from installer project using “project reference”, so that msbuild variables can be used to refer to paths.
– Fixed issues with VSTO 2013 update 1

a6f2d2ab4d0dfa1d6a144ca085973d04

Rubberduck – refactoring in VBA

Hi all, recently came across an interesting Rubberduck project. Did you think that VBA is dead and buried? It looks like it’s not going down that easily 🙂

Rubberduck is a COM Add-In for the VBA IDE that makes VBA development even more enjoyable, by extending the Visual Basic Editor (VBE) with menus, toolbars and toolwindows that enable things we didn’t even think were possible when we first started this project.

If you’re learning VBA, Rubberduck can help you avoid a few common beginner mistakes, and can probably show you a trick or two – even if you’re only ever writing macros. If you’re a more advanced programmer, you will appreciate the richness of Rubberduck’s feature set.

Continue reading