saracensxv

Hope someone can help...I am trying to create a VB prog. which needs to use data stored in a table format. Does anyone have any ideas as to how Excel can be used for this? The data stored does not change. I am a novice VB user so I would be grateful if you explained it in 'baby speak'!!

italkid

First you should think about what application would be the best to
handle/store your data.
Is for instance Access an option ?
Be aware of the fact Excel isen't a real DB application but more a "calculation" program.
What kind and how much data you need to handle...?
If you want to link Excel to your VB application then i would advice you
to take a look at these threads which handles the basics of linking VB with Excel.
Take a look at these threads...
One
Two
Three
Four
Additional you could use this forum's excellent search tool and search
for words like "open,close,save,quit,application" etc....
Hope this gets you started.

saracensxv

Quote:

---

Originally Posted by saracensxv
Hope someone can help...I am trying to create a VB prog. which needs to use data stored in a table format. Does anyone have any ideas as to how Excel can be used for this? The data stored does not change. I am a novice VB user so I would be grateful if you explained it in 'baby speak'!!

---

Thank for the reply. I'm open to suggestions about which is more appropriate to use (Excel or Access). I'm trying to create a Scuba Diver's Planner. Divers enter the depths and time they wish to spend underwater and VB uses the tables (which I was planning on storing in excel) to find the corresponding Nitrogen level in the body and the maximum time the diver can remain underwater at the given depth. I only need excel in this example to store the nitrogen/max dive time data. No calculations are required by Excel.
The above is then repeated if the diver wishes to do a repetitive dive following a surface interval, then different dive tables are referred to which also need to be stored.

Timbo

If you don't need Excel's analysis features, then don't use it if you have an alternative...