 |  |  |  |  |  |  |  |
Internal Data Tables
 |
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.
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.
•
•
•
•
Originally Posted by LenderRep
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.
Don't post .exe files to forums and expect people to open them.
No 2.
Why are you storing the data in Excel? This will require the client computer to have the Excel object library installed on it to be able to run the application. I'd store it in a text file or something similar and then on program startup load the file into memory.
No 3.
Let me know if you need more help with this.
Mark
Mark Nemtsas
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
No. 1
Great point...I don't know why my mind blanked on that one...
No.2
The company I work for paid a temp to re-type a booklet that we distribute. They used Excel for whatever reason. I can't even find the department that published the content in this booklet...it's a rate schedule...wouldn't it make sense that the rates would have some mathematical relation to the corresponding amount...it seems almost random! I can take this table and port it to any format.
I figured that this could be a 2 file application pretty easy...I was wondering if it could be done in 1 .exe file...
Thanks for any help you can offer!
Great point...I don't know why my mind blanked on that one...
No.2
The company I work for paid a temp to re-type a booklet that we distribute. They used Excel for whatever reason. I can't even find the department that published the content in this booklet...it's a rate schedule...wouldn't it make sense that the rates would have some mathematical relation to the corresponding amount...it seems almost random! I can take this table and port it to any format.
I figured that this could be a 2 file application pretty easy...I was wondering if it could be done in 1 .exe file...
Thanks for any help you can offer!
•
•
•
•
Originally Posted by LenderRep
No. 1
Great point...I don't know why my mind blanked on that one...
No.2
The company I work for paid a temp to re-type a booklet that we distribute. They used Excel for whatever reason. I can't even find the department that published the content in this booklet...it's a rate schedule...wouldn't it make sense that the rates would have some mathematical relation to the corresponding amount...it seems almost random! I can take this table and port it to any format.
I figured that this could be a 2 file application pretty easy...I was wondering if it could be done in 1 .exe file...
Thanks for any help you can offer!
Mark Nemtsas
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
You could store the tables in data statements but then you would have to
recompile the program if changes were made.
I would think that either 1) a text file containing the tables or
2) a separate entry program for the tables (to keep the tables in a relatively
safe format)
then print or whatever with your main program after reading the table(s)
and selecting which one.
A random file would be the easiest solution for 2). That way you could update
an individual record (or correct an error) when needed. I have done this
with payroll tables which sound similar to what you have.
Number 1) would be just about as easy with a text editor but less secure.
recompile the program if changes were made.
I would think that either 1) a text file containing the tables or
2) a separate entry program for the tables (to keep the tables in a relatively
safe format)
then print or whatever with your main program after reading the table(s)
and selecting which one.
A random file would be the easiest solution for 2). That way you could update
an individual record (or correct an error) when needed. I have done this
with payroll tables which sound similar to what you have.
Number 1) would be just about as easy with a text editor but less secure.
|
Similar Threads
- how to insert data into 2 tables in single query/ (MS SQL)
- Join Two data tables (C#)
- Insert data into two tables using php and mysql (MySQL)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: bload something into an array
- Next Thread: Is there any way that VB can force Windows not to modify a file
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
