Sub kolom()
Application.ScreenUpdating = False
Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=True, Comma:=True, Space:=False, Other:=False, FieldInfo:= _
Array(Array(1, 4), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7 _
, 1), Array(8, 1), Array(9, 1)), TrailingMinusNumbers:=True
Rows("1:1").Select
Selection.Delete Shift:=xlUp
ActiveWorkbook.SaveAs Filename:="[COLOR="Red"]D:\Doc\Excel\giro.xls[/COLOR]", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
Dim lr As Long 'laatste rij
Dim lk As Integer 'laatste kolom
lr = Cells(Rows.Count, "A").End(xlUp).Row
lk = Cells(1, Columns.Count).End(xlToLeft).Column
Range(Cells(1, 1), Cells(lr, lk)).Select 'Copy
Selection.Copy
Dim Msg, Style, Title, Response, MyString
ChDir "D:\Doc\Excel"
Workbooks.Open Filename:="[COLOR="Red"]D:\Doc\Excel\Postbank.xls[/COLOR]", Password:=""
Sheets("2007").Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
Workbooks("Giro").Activate
Selection.ClearContents
ActiveWorkbook.Close SaveChanges:=True
Application.ScreenUpdating = True
End Sub