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.