There is a lot of posts on the forum regarding the issues with the macros. This includes but not limited to the issues like:
I have published the blog post which describes the most common issues, causes and resolutions when it comes to the SOLIDWORKS macros: Macros Troubleshooting: Issues And Resolutions
I did not read the solutions but I think you have made a good start at addressing macro issues.
Retrieving data ...