Just to clarify since someone felt that I was asking others to do my work for me, here is the approach I'm taking:
I have a solid body, and from one end I have a circle that's larger than the greatest diameter of the body. I'm cut extruding along a centerline sketch, then doing a linear pattern that will advance the depth of the cut by a stepped amount with each additional # of patterns.
I have recorded the macro of selecting the face and measuring the surface area, but my confusion begins when trying to increment the amount of # of patterned features while taking the measurement in between each increment. The exporting to excel portion I'm pretty sure I can figure out based on other work I've done, but if anyone could help with the incremental increase in the number of patterns, that would be wonderful. I am more than happy to work in tandem with anyone up for the challenge - I would hate to come off as someone asking others to achieve my goal for me.
OK, so it sounds like you need to make a reference plane coincident to the axis of rotation and at and angle from one of the other planes.
You're going to drive that angular dimension to increment your section plane
On that plane you're going to create a sketch and do an intersection curve selecting the part-level of the tree as the curve source. That will effectively make a sketch of the cross section of the entire part-including all bodies.
You wire your existing macro into that sketch to take cross-sectional area
Rinse and repeat.
There's your pseudocode.
break it down into tasks, modularize the bits of code you don't know how to create and go to the online help and the forums to get help with those parts.
You'll find a lot more people willing to help you with a job when it doesn't look like they're going to have to do everything for you.
Thanks John, I appreciate you taking the time to provide your inputs and I wholeheartedly agree that people aren't going to be willing to write an entire code for me. I am familiar with editing the code, but this particular instance has taken me outside of my current understanding.
I think there was a miscommunication because I do not want to create planes spinning around the axis, but rather take area measurements as you move linearly from one end to the other. Imagine you wanted to know the cross sectional area every .25 inches along a baseball bat. You could cut the bat up into a ton of thin discs and measure the surface area at each face of the disc where the cut was made. This is what I'm trying for, based on incrementing the # of patterns for a cut extrude while exporting measurements taken prior to each increment of the pattern.
Hope this helps narrow down the task at hand!
Oh well you just need to make your plane offset from a starting plane and drive that dimension. The rest of the steps can be the same
I will give it a try and post my results here, thanks again for your assitance.
I was just wondering if you had success making this macro? I'm looking for something very similar right now.