Variable length recordset for GET statement in Excel

[StuartJones]

Hi - I'm getting a "bad recordlength" error message when I use the GET statement to read from a csv file.
Problem is, I don't know what the length of the line is until I read it.
Any help would be appreciated.

Stuart

 

[PHV]

HAve you tried to play with Line Input and the Split function ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[StuartJones]

Thanks,

I'm afraid I don't know VBA that well, and the on-line hindrance isn't very good in Excel.

Line Input worked - so thanks again.