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
Printable View
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:
you could hold a single cell's data/text in a variable so you could evaluate it....Code:Dim strTempVal As String
strTempVal = cstr(.range("A1")
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.