Question: how to extract data from text file using vba?
Answer: First, download the text file and add it to "C:\test\" ... 
We declare four variables. ... 
We need to initialize the variable myFile with the full path and the filename. ... 
Add the following code line: ... 
Add the following code lines: ... 
Close the file.