CSV Import while skipping "column" data from CSV

[chipsworld]

OK...I have some code that imports a csv into a sheet, but I don't want ALL of the data...

I need to be able to skip certain "fields" in the line string from the CSV. How can I accomplish that with the below?

Sub ImportCSV(customerfilename, unitnam, targetSheet)
Dim rw As String

With ThisWorkbook.Sheets("Template").QueryTables.Add(Connection:= _
"TEXT;" & customerfilename, Destination:=ThisWorkbook.Sheets("Template").Range("$C$2"))
.Name = "unitnam"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = False
.TextFilePromptOnRefresh = False
.TextFilePlatform = 65001
.TextFileStartRow = 1
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = False
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = False
.Refresh BackgroundQuery:=False
'.Delete BackgroundQuery:=True
'.UseListObject = False
End With
end sub

 

[Joe4]

I find that old method of importing seems to work better for me than the new one. I am not a big fan of it, but maybe it is just because I don't know it that well yet.