I look within a VBA macro launched in an assembly to retrieve to place in an excel spreadsheet the name of the part (it's done) and the coordinates of the origin of this part in this assembly. That's what I don't know how to do yet.
Here is the piece of code concerned:
ChildPartCount = UBound(AssChild)
For j = 0 To ChildPartCount 'Name and config xlapp. Worksheets(1).cells(Row, 1). Value = AssChild(j). Name xlapp. Worksheets(1).cells(Row, 2). Value = AssChild(j). ????
I don't understand why you are trying to have the position of the origins. The components of the assembly I understand but the position of the origin seems a little too theoretical to me.
Especially since you're going to have the position of the origin but not the direction of the axes. You can surely find the answer here:
I've done something like this, I've made a sketch with reference point positions, I'm managing the position of the points and I'm saying this component goes on this point.