Sub Torque()
'
' Torque Macro
'
' Sneltoets: Ctrl+Shift+T
'
    With ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\tracklog.csv", _
        Destination:=Range("$A$1"))
        .Name = "trackLog"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .TextFilePromptOnRefresh = False
        .TextFilePlatform = 65001
        .TextFileStartRow = 1
        .TextFileParseType = xlDelimited
        .TextFileTextQualifier = xlTextQualifierDoubleQuote
        .TextFileConsecutiveDelimiter = False
        .TextFileTabDelimiter = True
        .TextFileSemicolonDelimiter = False
        .TextFileCommaDelimiter = True
        .TextFileSpaceDelimiter = False
        .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, _
        1, 1, 1)
        .TextFileDecimalSeparator = "."
        .TextFileThousandsSeparator = ","
        .TextFileTrailingMinusNumbers = True
        .Refresh BackgroundQuery:=False
    End With
    ActiveWindow.ScrollColumn = 2
    ActiveWindow.ScrollColumn = 3
    Range("E:E,L:L,M:M,N:N,O:O").Select
    Range("O1").Activate
    Selection.NumberFormat = "0.00"
    Columns("O:O").Select
    Selection.Replace What:="-", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
    Range("E:E,L:L,M:M,N:N,O:O").Select
    Range("O1").Activate
    ActiveSheet.Shapes.AddChart2(332, xlLineMarkers).Select
    ActiveChart.SetSourceData Source:=Range( _
        "Blad1!$E:$E,Blad1!$L:$L,Blad1!$M:$M,Blad1!$N:$N,Blad1!$O:$O")
    ActiveSheet.Shapes("Grafiek 1").ScaleWidth 1.7958333333, msoFalse, _
        msoScaleFromBottomRight
    ActiveSheet.Shapes("Grafiek 1").ScaleHeight 1.8593748177, msoFalse, _
        msoScaleFromBottomRight
    ActiveSheet.Shapes("Grafiek 1").ScaleWidth 1.5614849188, msoFalse, _
        msoScaleFromTopLeft
    ActiveSheet.Shapes("Grafiek 1").ScaleHeight 1.4061626028, msoFalse, _
        msoScaleFromTopLeft
End Sub