Depending on how custom your macro was, you may be able to do just as well with the Custom Property Tab Builder. I can't remember if that was available in 2010.
That was a quite massive macro. I just had a quick look and I can not tell how much work it would be to debug it.
Have you looked at this video and information from CADsharp? http://www.cadsharp.com/blog/solidworks-macro-compatible-64-vba7/
Is this what you are facing?
Or is it perhaps related to something like this...? Common controls do not load in VB6 after IE10 installation - Microsoft Community
But be careful.., playing around with dlls might not be that fun in the end.
Otherwise would recommend that you ask a general question about how to handle ActiveX (common controls) transist from VBA6 to VBA7 at www.stackoverflow.com. MSDN is also a good place to look for some more information.
I took a look at your macro. It looks pretty straight forward. It appears that there are some missing controls on the frm_solidworks_frm - some slider controls maybe? There is also an error when starting the app. I think there must be a missing date picker??
Make sure you add the reference to the SolidWorks Type Library. Tools -> References in the VBA editor. I also commented out the lines where it was trying to access a slider value.
!I took a look at the macro. Lots of stuff but since this is VB is very verbose and looks more than it really is. If you love it, I'm sure you could find someone to fix it for you for a small fee. I was able to get it to run in about 10 minutes (without the missing sliders for color control). But to answer your question, we found that managing properties one file at a time was labor intensive and there was no easy way to review the work other than opening up each file. Additionally, we synchronize properties between drawing and part file. So to do this we have an external program written in Delphi that scans all the file in a folder (or subset there of). I analyzes each of them to make sure all the properties are in sync and that the user as entered all the information correctly. I then presents this in a nice spreadsheet like view to the user with little flag indicating errors. In all, it checks 50 or so parameters on any given file. If there is clean up to do, it is all done outside of Solidworks (using their API). We include all sorts of file management stuff as well such as extracting PDF files.