Visio, Excel and late binding enumerations

Excel MVP, Mike Alexander, has an interesting video over at DailyDoseOfExcel.com The video covers how application-specific enumerations aren’t recognized when using late binding.

His answer to the problem is to use a list of ‘manual’ enumerations, which he includes as a download on the above post.

I emailed Mike earlier today and he very kindly ran his magic code over the Visio help files to produce this set of Visio enumerations. Perfect if you’re writing code from the other direction.