Hi i would suggest you to record your actions in Catia to macro. Then look what was recorded and learn from it. If it's not recorded then you have no option to automate it (if you want to avoid CAA Api)
EDIT
Well I give it some other though and test this myself. It indeed doesn't show up in the recorded macro which in most cases (99%) shows that it's not available but in this case the Objects truly exists in API. But the access to them is rather different than normal objects (like parameters, relations, constrains and so on)
You have to get the collection of Sections for product in a different way like so:
Sub CATMain()
Dim Prod As ProductDocument
Set Prod = CATIA.ActiveDocument
Dim Sect As Sections
Set Sect = Prod.Product.GetTechnologicalObject("Sections") 'This is how you get the section collections a can do something with them
End Sub
Locals in VBA Editor in CATIA

Tree sections in catia

Then after all you can come up with something. I have to apologize that i did not make better effort to test this.