Hi guys,

I have this piece of code, which works fine, but it seems that by default it has a delimiter of ";", so if within an entry there is a ";" it is split into different columns, which I don't want. I only want the delimiter to be "|":
With ws1.QueryTables.Add(Connection:= _
        "TEXT;\\nbsmain\Archive\sxxirpts\" & cboYear.Value & " " & cboMonth.Value & " Sxxi Reports\Main\" & cboMonth.Value & cboDay.Value & "\F99999\" & cboRptname.Value & ".999", Destination:= _
        ws1.Range("$A$1"))
        '\\nbsmain\Archive\sxxirpts\2011 03 Sxxi Reports\Main\0331\F99999\PSAV00.999
        .Name = "cboRptname.Value"
        .FieldNames = True
        .PreserveFormatting = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .TextFilePlatform = 437
        .TextFileStartRow = 1
        .TextFileParseType = xlDelimited
        .TextFileTextQualifier = xlTextQualifierDoubleQuote
        .TextFileOtherDelimiter = "|"
        .TextFileTrailingMinusNumbers = True
        .Refresh BackgroundQuery:=False
End With
Thanks