I'm looking to read the last line in a .csv file for calculation purposes. I need to get two values from the last line of a .csv file so I can use these values to calculate other values in the program. Or if this is to difficult, the whole point of this is to be able to have a “calibration file” which will story the setting for a machine which will be calibrated occasionally and after each calibration the calibration file will be updated and then the most recent values will be read into the program and used for calculation purposes.
Thank You
hi
do you need a file for this ?
if you run your program on the same machine you may use
something like
SaveSetting "Program","Properties","Setting1",strSetting1
get the value back by
strSetting1=Getsetting ("Program","Properties","Setting1,"")
otherwise
Open FileName For Input As #1
While Not EOF(1)
Line Input #1, p
LastLine = p
Wend
Close #1
LastLine contains the data from the last line in the file