Well, at least some of the answers.
Go to www.odtug.com, click on Tech Resources, then Essbase, then type in SmartView (yeah, one word), and you will see a presentation and white paper by Robert Gideon (Hi, Rob) on SV and VBA. The presentation is "Hyperion SmartView Automation with VBA".
Then change that search string to "Smart View" and search again and you'll find a presentation and white paper by Matt Milella (yes, the PM of SV, at least I think that's his title, maybe he's been promoted since?) on "Convert Legacy Add-in Solutions in VBA to Smart View VBA or .Net".
You have to join ODTUG as an associate member (which is free) to download this stuff. Of course I would recommend that you become a full member, and come to KScope12 in San Antonio, Texas, but that would be marketing. Hopefully the actual real content above gives you a feel for the total awesomeness that is ODTUG/the KScope conferences. :)