Excel BOM

Hi all,

I am trying to write some custom SW to produce an excel BOM foreach separate sub-assembly within an assembly.

I have done quite a bit but amreally struggling with how to structure my UDT. The way Ihave it so far is the UDT replicates the structure of the assemblyand parts within each assembly which can then be turned into aspreadsheet.

My problem is 1) the structure of the UDT and 2) how to fill it.

Does anyone have any examples or ideas how I can achieve this? Thismust have been done before??

Any ideas appreciated.

ThanksSolidworksApi macros