CATIA V5 - Generating Bill Of Material using Macro

Demonstration of automatic export custom Bill Of Material parameters to Excel table.
The video shows how VBA Macro picks parameters from BillOfMaterial parameter set and exports them in Excel table.
It is good to notice that:
Parts without BillOfMaterial parameter set are not exported (e.g. ADAPTER).
Parts which appear several times in Assembly are not exported several times.
Macro will not crash if Assembly is empty, or if Part, or Drawing is active document.

[@muhammadkurniawan203]

How i can get this macro?

[@liquidgaming2455]

I think comment and heat treatment values are swap plz check

[@naveenb.n.8663]

Can u please explain in detail regarding how to create a macro and to use for extracting info

[@slavisasavic5129]

You need V5Automation.html document which you can find in the installation directory. It will help you to understand the structure of classes and objects. That is the first step, the second step is to record some simple macro (create a parameter, create a parameter set, etc.) then open code and try to figure what is defined and how using V5Automation.html for help. If you have basic knowledge of object-oriented programming, it will not represent a problem for you. It that is not the case, then I suggest the first step to learning the basics of OOP. Good luck.

[@mauricioruano]

Hi friend, can u copy and paste the Code here? Or share a txt with the code in it? That would be nice and it will earn us so much time figuring it out by ourselves.. thanks again!