Let user select file to open

Dim nwWbName As String, nwWb As Workbook

nwWbName = Application.GetOpenFilename
Set nwWb = Workbooks.Open(nwWbName)

I don't know how this can be applied to your code up top there as this will actually open the csv as its own workbook, which is what you were asking for.