Code:
Sub CATMain() ' ************* Definition Variablen*****************
Dim mainProduct As ProductDocument
Set mainProduct = CATIA.ActiveDocument
Dim rootProduct As Product
Set rootProduct = mainProduct.Product
Dim lvlnProducts As Products
Set lvlnProducts = rootProduct.Products
' ************* Oeffnen vonm Excel und Anlegen der Ueberschriften*****************
Dim objExcel as Excel.Application
Set objExcel=CreateObject("Excel.Application")
objexcel.Visible=True
Set objWorkbook= objExcel.workbooks.Add()
Set objSheet1=objWorkbook.sheets.item(1)
objSheet1.cells(1,1)="Fuehrende Sachnummer"
objSheet1.Range("A1").ColumnWidth = 30
objSheet1.cells(1,2)="Sachnummer"
objSheet1.Range("B1").ColumnWidth = 30
objSheet1.cells(1,3)="Model-V5/Teilmodel-V5"
objSheet1.Range("C1").ColumnWidth = 30
objSheet1.cells(1,4)="Gewicht"
objSheet1.Range("D1").ColumnWidth = 30
objSheet1.cells(1,5)="Material"
objSheet1.Range("E1").ColumnWidth = 30
' ************* Befuellung der Excel*****************
Dim i As Integer
For i=1 to lvlnProducts.Count
Call Test(i)
Next
End Sub
Sub Test(testi)
Dim mainProduct As ProductDocument
Set mainProduct = CATIA.ActiveDocument
Dim rootProduct As Product
Set rootProduct = mainProduct.Product
Dim lvlnProducts As Products
Set lvlnProducts = rootProduct.Products
objSheet1.cells(2+testi)=lvlnProducts.Item(testi).Name
End Sub