I haven't got much experience with using VBA for CATIA but I was wondering if it was possible to create a simple VBA script/macro to extract the volume of each part under an assembly and save it in an Excel file?
Yes, it can be done, but as Eric said, first try to do something and then come with your code and problems here. Search also the forum, you will find a lot of examples.