You need to reference the sldworks type libraries. Then you call can SOLIDWORKS from you excel macro.
You can use this tool:-
This is works by linking multiple (pseudo) design tables to single master file.
Though documentation is not there much. But you can ask me if you are stuck.