So for reference sake, here is something easy.
This is how to load a local text file into a variable, so you can process it.
Well here is how to do it:
Dim strURL As String
'this is the text file in the directory of your spreadsheet
strURL = ThisWorkbook.Path & "\currencies.txt"
Dim strFileContent As String
Dim intFile As Integer
intFile = FreeFile
Open strURL For Input As #intFile
strFileContent = Input(LOF(intFile), intFile)
Now the contents of your text file are in the string strFileContent.