Code:
Sub CATMain()
'_________________________________________
' Separating char
trz = ";"
crlf = chr(10)
'-----------------------------------------
Set document = CATIA.ActiveDocument
Set filesys = CATIA.FileSystem
'__________________________________________________________________________
' Filename and path
'on error resume next
Dim filefile = Document.Name
Dim path
Dim Nazwa
path = left(Document.FullName,InStrRev(Document.FullName,"\"))
pathdummy = left(path,len(path)-1)
Nazwa = left(file,Instr(file,".")-1)
filename = "D:\"&Nazwa&"_Materials.csv"
'--------------------------------------------------------------------------
if filesys.FileExists(filename) Then
filesys.DeleteFile(filename)
End If
Set file = filesys.CreateFile(filename,True)
Set stream = file.OpenAsTextStream("ForWriting")
err=0
Dim Part_Number
Dim VWG_Right_hand_Partnumber
Dim VWG_Material
Dim VWG_Material_Density
Dim VWG_Material_Thickness
Dim VWG_Volume_Solid
Dim VWG_Weight
Dim comment
Dim symmetry
stream.write("Part Number"&trz&"VWG_Right_hand_Partnumber"&trz&"VWG_Material"&trz&"VWG_Material_Density"&trz&"VWG_Material_Thickness"&trz&"VWG_Volume_Solid"&trz&"VWG_Weight"&trz&"comment"&trz&"symmet ry")
stream.write(crlf)
Dim Document
For each Document in CATIA.documents
'Set element = CATIA.Document
'Msgbox(TypeName(element))
'Dim Params
'Params = element.Parameters
'Msgbox(Params.count)
If TypeName(document) <> "ProductDocument" then
'Part_Number = Document.Name.value
VWG_Right_hand_Partnumber = Document.Part.Parameters.RootParameterSet.Directparameters.item("right_hand_part").value
VWG_Material = Document.Part.Parameters.RootParameterSet.Directparameters.item(2).value
VWG_Material_Density = Document.Part.Parameters.RootParameterSet.Directparameters.item("material_density").value
VWG_Material_Thickness = Document.Part.Parameters.RootParameterSet.Directparameters.item("material_thickness").value
VWG_Volume_Solid = Document.Part.Parameters.RootParameterSet.Directparameters.item("volume_solid").value
VWG_Weight = Document.Part.Parameters.RootParameterSet.Directparameters.item("weight").value
comment = Document.Part.Parameters.RootParameterSet.Directparameters.item("comment").value
symmetry = Document.Part.Parameters.RootParameterSet.Directparameters.item("symmetry").value
stream.write(Part_Number&trz&VWG_Right_hand_Partnumber&trz&VWG_Material&trz&VWG_Material_Density&trz&VWG_Material_Thickness&trz&VWG_Volume_Solid&trz&VWG_Weight&trz&comment&trz&symm etry)
End If
Next
stream.close
msgbox ("Ready: "&filename&" ")
End Sub