Ok,
I have been using the VSTA macros since SW 2009 (now on 2012, x64). I know that there have been a few reported problems with it but overall, I really like the interface and the functionality of the .NET platform. At one time, I was told by another developer not to use VSTA as it has too many problems. That said, I have used it for all my personal macros. I have some macros that I would like to share with my coworkers. Unfortunately, there is one issue that really prevents me from doing this. Often, when attempting to run a macro (from a toolbar button) it will reply with "cannot open dll", I have posted a previous post on this issue. While it is ok for me to exit out of Solidworks to clear up this issue, I really can't expect this from my coworkers.
Does anyone else use VSTA? If so, have you seen the same problems? I can confirm that it happens on multiple PC (not just mine) and that often it will happen when you have a large assembly open. It does not matter how big the macro is or what is in it (I have seen it fail with a simple "hello world").
Should I just give up on VSTA?
SolidworksApi macros