Hi everyone
I am writing an excel macro which needs to be able to read an arbitrary line from a text file. Suppose the text file contained the following text where each of the sentences is on a separate line:
This is line 1
This is line 2
This is line 3
This is line 4
I need to be able to select an arbitrary line to read. If I can store each line as an array element then I am done but I don't know how to do that. How can I store each line as an array element?
Thanks
I am writing an excel macro which needs to be able to read an arbitrary line from a text file. Suppose the text file contained the following text where each of the sentences is on a separate line:
This is line 1
This is line 2
This is line 3
This is line 4
I need to be able to select an arbitrary line to read. If I can store each line as an array element then I am done but I don't know how to do that. How can I store each line as an array element?
Thanks