Hi
In Excel I use vba to read a comma delimited line of text from a text file.
so my variable str would hold something like:
one,two,three,four etc
There is two things I wan to do
First I want to be able to put the contents of my variable in to individual cells e.g.
A1 B1
one two and so on
at the moment I can only dump the whole string in to one cell - I could do text to columns afterwards but I am sure there must be a better way.
The second thing I want to do is to delete the first line of text from the text file (i.e. the line I have read in to my variable) but only that line -the text file could contain many lines.
Any help on either or both problems would be greatly appreciated
Many thanks
In Excel I use vba to read a comma delimited line of text from a text file.
so my variable str would hold something like:
one,two,three,four etc
There is two things I wan to do
First I want to be able to put the contents of my variable in to individual cells e.g.
A1 B1
one two and so on
at the moment I can only dump the whole string in to one cell - I could do text to columns afterwards but I am sure there must be a better way.
The second thing I want to do is to delete the first line of text from the text file (i.e. the line I have read in to my variable) but only that line -the text file could contain many lines.
Any help on either or both problems would be greatly appreciated
Many thanks