I am looking to create or customize a macro, that will go thru all of the fasteners in a given assembly and calculate the thread engagement, ensure that the right fastener is used in the right hole wizard hole and ensure that the fastener is not bottoming out in the tapped hole. This macro would be used as a design check function automating the manual thread engagement calculation on each fastener in which there are many in our assemblies. We do not use toolbox, so none of that functionality can be used. Is there something like this already out there that I could leverage? If not, then are there any suggestions on how to go about finding all of the fasteners in the subassembly, finding the hole properties of the hole the fastener is located in, finding the amount of fastener engagement into that hole? Any help is greatly appreciated. Thanks.
You have not stated any level of current API knowledge. However, this one is complex enough that, unless you are already pretty experienced in the SW API, it's going to be most cost-efficient for you to pay someone to do it. It probably won't be particularly cheap, but to go from zero to the ability level required by this macro would probably take 2 months full-time study for someone with a knack for coding. And then you'd have to actually write it.