How to import Excel data

Hi

I need to import data from an excel spreadsheet. I have no idea how to do this. I need to import the data into a vb app where I will validate it before saving it. Can anyone tell me how this is done?

Thanking you in advance
PORRASTAR

Hi Pornstar, sorry porrastar :p

I worte this out this morning which you could easily modify:
http://www.vbforums.com/showthread.p...hreadid=235042

This one extracts a range from an Excel sheet & shoves the entries into a listbox, though if you altered it to somethijng like this:

Code:

---

Dim strTempVal As String
strTempVal = cstr(.range("A1")

---

you could hold a single cell's data/text in a variable so you could evaluate it....

Do you really want to import the data from an EXCEL-file into a VB appication, just to check the data and than staore it (store it as EXCEL-File?)
I'd use EXCEL (including VBA) to that.

Plerase state if you really need to import into VB or if an VBA approach would help.