User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 455,968 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,739 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 2832 | Replies: 4
Reply
Join Date: Aug 2004
Posts: 2
Reputation: LenderRep is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
LenderRep LenderRep is offline Offline
Newbie Poster

Internal Data Tables

  #1  
Aug 24th, 2004
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.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jul 2004
Location: Adelaide, Australia
Posts: 191
Reputation: mnemtsas is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 1
mnemtsas's Avatar
mnemtsas mnemtsas is offline Offline
Junior Poster

Re: Internal Data Tables

  #2  
Aug 25th, 2004
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.

No 1.

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
Reply With Quote  
Join Date: Aug 2004
Posts: 2
Reputation: LenderRep is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
LenderRep LenderRep is offline Offline
Newbie Poster

Re: Internal Data Tables

  #3  
Aug 25th, 2004
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!
Reply With Quote  
Join Date: Jul 2004
Location: Adelaide, Australia
Posts: 191
Reputation: mnemtsas is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 1
mnemtsas's Avatar
mnemtsas mnemtsas is offline Offline
Junior Poster

Re: Internal Data Tables

  #4  
Aug 25th, 2004
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!

I can't seem to open the attachment anymore, perhaps you can email me the spreadsheet at mnemtsas @ timesheetsmts . com for me to take a look at. And no there is no reason why it can't be a one file app.
Reply With Quote  
Join Date: May 2004
Location: OK
Posts: 40
Reputation: Buff is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 0
Buff Buff is offline Offline
Light Poster

Re: Internal Data Tables

  #5  
Aug 25th, 2004
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.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 9:09 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC