Hi,
I am reading a csv file and I want to check if the data is a string or an integer. But I am having trouble doing this.
hen lineitems(1) = "row text" it crashes. How to fix this?
for i = 1 to 100
If EOF(1) Then MsgBox "Error"
Line Input #1 , linefromfile
lineitems = Split(linefromfile, ",")
If Not IsError(CInt(lineitems(1))) Then min_age = lineitems(1)
next i
I am reading a csv file and I want to check if the data is a string or an integer. But I am having trouble doing this.
hen lineitems(1) = "row text" it crashes. How to fix this?
for i = 1 to 100
If EOF(1) Then MsgBox "Error"
Line Input #1 , linefromfile
lineitems = Split(linefromfile, ",")
If Not IsError(CInt(lineitems(1))) Then min_age = lineitems(1)
next i
Last edited: