I have a csv file that automatically generated (update) every 15 minutes
from a computer server (which I cannot control).

The csv file is only one row and 7 data separated by commas. The filename
and format of this csv file are always the same.

In another workbook, I would like to link a cell to one of the data of the
above csv file.


At the moment, I need to open the csv file manually and then copy the
required data to my spreadsheet.

Is it possible to extract the data from the csv file without opening the csv
file?


Thanks.