I need to figure out how to create a parametric program to check a family of parts. Initially it sounds somewhat simple, except I am a complete noob to computer programming. Before I spend more time on this, I want to run some info past the group mind to make sure I am not wasting time.
Attached is 1 of 11 sets of tables that contain all the information for 1 of the 11 parts in this family. The last 4 or 5 digits of any part number can be referenced back to the tables.
I have watched the kb article on parametric programming, I just can't quite wrap my head around it. My situation is quite a bit more complex. How can I create a program that the only information entered is a part series number and then the last 4 or 5 digits of a part number?
My current idea is to create an excel file for each of the 11 parts, including all the info from the tables. After that I am not seeing how I can reference those files to get the data that I need.
So far I have confused myself looking at stuff for VB Script, VBA and the article about parametric programming. Any guidance would be appreciated.