Calculate surface area Vba

[Anonymous]

First I would like to say that my knowledge of VBA coding is limited. That being said I do have some coding experience but I am unfamiliar with some of the concepts of VBA coding and how they interact with inventor files. 

Currently I am trying to figure out how to calculate the area of a flat pattern created in an inventor part file and then have that area subtracted from a rectangular boundary box that is dictated by the largest length and largest width of the part file, a picture file is attached for better visualization. This information would then need to be exported to our cost report as a scrap factor. 

Attached is our current cost report macro VBA Code as a text file. Which was not written by myself. I was wondering if there was a way to easily implement this idea into the current code? Or would it be best to create another macro?

Any help is much appreciated. 

[johnsonshiue]

Hi! Is this a school project? You may want to discuss with your classmates or teaching assistant first. Let me give you a hint. Inventor sheet metal part has uniform thickness. Volume is part of the physical properties. Surface area (flat pattern area should be computed easily.

Thanks!

[Anonymous]

This is a project for my workplace. Where we are trying to implement this idea into our already existing software.

[Anonymous]

So any help would be much appreciated. I just need help on the best location and best way to call out for information for what I am trying to do and how to implement it in the most efficient way into the existing code that I already have. This is a project that I am researching for my company to help alleviate some headaches we have with scrap factors with our plasma table. 

[PaulMunford]

You could do this with iLogic.

You can get the extents and area like this:

https://knowledge.autodesk.com/support/inventor-products/learn-explore/caas/CloudHelp/cloudhelp/2016...

Would that give you enough to work out the extents area and subtract the face area?