I have a macro:
Sub test()
Dim myFile As String
Dim YourFolderPath As Variant
YourFolderPath = "\\ESCPTOVSPIFS003\Shares5\ESC\SSB2\Revenue Management\40 Elm Documentation\Bank Reconciliations"
myFile = Application.GetOpenFilename("Text Files (*.txt),*.txt")...