Very practical solution!. I am very frustrated in trying to get started with VBA since most texts don't cover Visio. I am a technical writer (retired from natural gas industry) for the refinery industry and use Visio extensively. Got halfway through MCSE and decided that was a MS racket. Got Cisco cert. "power" user. in-the-closet geek. I am trying to automate a technical drawing (very complex compressor/turbine combo with auxiliary system and control systems) with some 20 plus layers. Various pics with different layer combos are inserted into tech manuals. I have been using screen prints pics of the layer properties page to be sure and get the right combos each time but this needs automation for someone else using the drawing. I dissected some recorded macros (thank god it's available in 2007)and got a prototype working but I need to (1) be able to count layers (2) handle added/removed layers (3) get the layer names (4) maybe reorder the layers. Control over the other "columns", especially "print" is also needed. Why can I not ad a button to the ribbon or one of the toolbars for a macro like i used to do in Word2003 (I had Word2007 so far; tough on a real-word office trying to be productive). Looking through all the detail in VBA help had me foaming at the mouth and pulling outhair I don't have.
Bottom line: (1) Is there a text or site with tutorials that are oriented toweard Visio (pay sites OK but of course preferr shareware or free!)(2) VBA for dummies is the worst book I have ever picked up but"Mastering VBA" is OK (3)Is there a good source that "slow walks" through the organization of Visio application (shape sheet? i hardly know where to begin) (4) it seems like "Help" assume one has been doing VB and VBA for years. I would like to speed up the learning curve. (5( any thoughts on my project above?
Sorry about the long post!!!