Hi,
I have published new blog post 5 best practices to make your VBA macro great. It practically demonstrates simple techniques which can be used in macro development which will make macro more reliable, stable and easy to use and maintain. I have used Excel macro in this example, but the same techniques can be applied to VBA macros in SOLIDWORKS.
Thanks,
Artem
SolidworksApi/macros