how do I pull the data being used for the BOM in VBA?

[JBEDsol]

I need to create something that adds up the collective CG's of components as they'll be in the BOM.  What I have goes through each item in an open assy and pulls data from each visible item.  Problem is that I may have conflicting units.  Some pipes will be in meters others in feet, others in inches.  I need a way to pull the document BOM value being counted and the units being used.

So for each occurrence I need to find the unit quantity, base quantity, and Base Unit.  How do I pull these up?

I know it's largely a duplication of efforts from what IV does for a parts list, but I don't have an option to get the CG for each of the grouped elements in a parts list.

[chandra.shekar.g]

@JBEDsol ,

Please explain more about requirement with screenshots. What is difference between Unit quantity and base quantity in assembly?

Thanks and regards,

[JBEDsol]

I'm trying to see how to get this data of a document using vba.