1. | Identify a text file to convert to an array by using the fileSystemObject to point to the file.
|
2. | Use the InStr function to parse the data.
|
3. | Use the file system object to connect to a data source.
|
4. | Use a dynamic array to hold the data.
|
5. | Use LBound and UBound to set the limits when we iterate through the array.
|