I am trying to develop a rate calculator for a fee schedule although "calculator" may not be the best term to use.
I have an Excel file containing 7 different fees that correspond to a single loan amount. LOan amounts run in $1,000 increments from $50,000 to $1,000,000.
I am trying to develop an application for quick-lookup of fees matching a loan amount. I would like to keep the application to a single .exe file if possible. I have the layout created and close to pulling data from the Excel file...still trying to figure out how to pull the Excel data into the VB app...help!
The fee schedule and a sample app are attached.