48 Replies Latest reply on Jun 2, 2015 1:34 PM by Endi Tollkuci

    macro to export center of mass/gravity of parts from an assembly to excel

    Mark Thompson

      Hello,

       

      I'm trying to source a macro that will locate the centre of mass/gravity of all components within an assembly relative to a specific point (i.e. the assembly origin) and export this information to an excel file. I realise this has been brought up on several other forums but as yet there doesn't seem to be a solution.

       

      Effectively I'm trying to incorporate the parametric capabilities of solidworks to iteratively optimise the structural configuration of a concentric shaft/bearing arrangement. However, at this stage I'd just like to avoid clicking on and recording the position and mass of each component within what is a fairly large and complex assembly.

       

      Thanks in advance.

       

      Mark,