Originally Posted by
pike
lacour
Is it a txt file?
I'm reading from a text file using VBA, the content of that text file is held in a vairable called sText
Once the content of the file is loaded into sText, I copy sText into an Array as such
sArray = Split(sText, vbNewLine)
then I parse scan the array row by row and write the content to each cell. This is the part I'd like to change. I would like to get away from parsing this through the loop and would prefer instead to write one statement that copies either sText or sArray() into the respective rows.
Bookmarks