VBA Code for Exporting PDD and ATT Properties from CATIA V6 to Excel

Hello everyone,

I am seeking assistance with developing a VBA macro for CATIA V6 that can export properties of PDD and ATT files based on a specific filter. I need to extract the following properties via excel file:

For PDDs:

[ul]
[li]PLM ID (idPLM)[/li]
[li]Designation in both French and English[/li]
[li]Version[/li]
[li]Maturity[/li]
[/ul]

For ATTs:

[ul]
[li]Ref PA[/li]
[li]Designation in both French and English[/li]
[li]ECO[/li]
[li]Technical Attribute[/li]
[/ul]

If anyone has experience with similar macros or can guide me on how to start writing this VBA script, I would greatly appreciate your help. I am specifically looking to understand how to access these properties programmatically within CATIA V6.

Thank you in advance for your assistance!

Best regards,

FouadM