Not intending to be a jerk, but this took me 5 minutes... The learning curve for the SolidWorks object model is much steeper than Excel's before you can achieve useful stuff. If your goal is to learn it, understand it, and become proficient, by all means proceed! It's rewarding. However, if your goal is to complete this one project, it might be more economical to write a small PO to someone who specializes in this sort of thing. Depends on whether you have more time or money. Keith Rice is a good resource for either learning or finished code.
Also, I recommend using the offline API help rather than the web help. Inside SolidWorks, point to "Help", then un-check "Use SOLIDWORKS Web Help". Then point to Help->API Help.
Thank you very much for your helpful reply and pointing me in the right direction. It looks like each of these will work for what I need. I appreciate the suggestions and I will check out the offline API help to see if it is easier to use.
My goal is indeed to learn it and become more proficient so that we have a product that not only is usable, but also so that more features can be added slowly (as we have ideas about what to add) and so that it can be maintained long term. Not only that, but it provides a fun side project to stretch myself and learn something new.
Would you happen to know if there is a similar method for getting the dimension count for sketches in a part file?
I really appreciate you pointing me in the right direction. I should be able to add some program code now.
Appreciate the recommendation, Josh, and great answer to Keith. I'll second you in saying that the local API Help is easier to navigate than the online API Help.