AW: Nur was ist jetzt der Code? Der gesamte Text? - ja
29.12.2003 13:42:28
Oli
ALso Hier nun der COde:
Sub BVD()
' BVD Makro
' Makro am 23.12.2003 von Alexoudi aufgezeichnet
' Tastenkombination: Strg+b
ChDir "F:\eurodata\5\Temp"
Workbooks.OpenText FileName:="F:\eurodata\5\Temp\ETIKETT.SEL", Origin:= _
xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, _
Comma:=False, Space:=False, Other:=False, FieldInfo:= (Array(1, 1), _
Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1), _
Array(9, 1), Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 1), Array(14, 1), Array(15 _
, 1), Array(16, 1), Array(17, 1), Array(18, 1), Array(19, 1), Array(20, 1), Array(21, 1), _
Array(22, 1), Array(23, 1), Array(24, 1), Array(25, 1), Array(26, 1), Array(27, 1), Array( _
28, 1), Array(29, 1), Array(30, 1), Array(31, 1), Array(32, 1), Array(33, 1), Array(34, 1), _
Array(35, 1), Array(36, 1), Array(37, 1), Array(38, 1), Array(39, 1), Array(40, 1), Array( _
41, 1), Array(42, 1), Array(43, 1), Array(44, 1), Array(45, 1), Array(46, 1), Array(47, 1), _
Array(48, 1), Array(49, 1), Array(50, 1), Array(51, 1), Array(52, 1), Array(53, 1), Array( _
54, 1), Array(55, 1), Array(56, 1))
Columns("B:R").Select
Selection.Delete Shift:=xlToLeft
Columns("B:R").EntireColumn.AutoFit
Columns("C:C").Select
Selection.Delete Shift:=xlToLeft
Columns("D:J").Select
Selection.Delete Shift:=xlToLeft
ActiveWindow.SmallScroll ToRight:=4
Columns("D:I").Select
Range("D20").Activate
Selection.Delete Shift:=xlToLeft
Range("D1").Select
ActiveCell.FormulaR1C1 = "Mitglied O/AO"
Range("E1").Select
ActiveCell.FormulaR1C1 = "DL/ZA"
Range("F1").Select
ActiveCell.FormulaR1C1 = "Regionalverband"
Range("G1").Select
ActiveCell.FormulaR1C1 = "Geschäftsführer"
Range("H1").Select
ActiveCell.FormulaR1C1 = "Ansprechpartner"
Range("I1").Select
ActiveCell.FormulaR1C1 = "Brutto Lohn/Gehalt"
Range("J1").Select
ActiveCell.FormulaR1C1 = "Umsatz p.a."
Range("K1").Select
ActiveCell.FormulaR1C1 = "Auszubildende"
Range("L1").Select
ActiveCell.FormulaR1C1 = "Beschäftigte"
Range("M1").Select
ActiveCell.FormulaR1C1 = "Betriebsrat"
Columns("N:N").Select
Selection.Delete Shift:=xlToLeft
ActiveCell.FormulaR1C1 = "Branche"
Columns("O:P").Select
Selection.Delete Shift:=xlToLeft
ActiveWindow.SmallScroll ToRight:=8
ActiveCell.FormulaR1C1 = "IHK-Bezirk"
Range("P1").Select
ActiveCell.FormulaR1C1 = "ZA BVD: HR-Nr.:"
Columns("P:P").Select
Selection.Delete Shift:=xlToLeft
Selection.Delete Shift:=xlToLeft
Columns("P:P").EntireColumn.AutoFit
Columns("Q:Q").EntireColumn.AutoFit
ActiveCell.FormulaR1C1 = "Eintritt"
Range("Q1").Select
ActiveCell.FormulaR1C1 = "Austritt"
Range("R1").Select
ActiveCell.FormulaR1C1 = "Austrittsgrund"
Range("S1").Select
ActiveCell.FormulaR1C1 = "Beitrag"
Range("T1").Select
ActiveCell.FormulaR1C1 = "Bemerkungen"
Range("T2").Select
Columns("S:S").EntireColumn.AutoFit
Columns("R:R").EntireColumn.AutoFit
Columns("Q:Q").EntireColumn.AutoFit
Columns("P:P").EntireColumn.AutoFit
Columns("O:O").EntireColumn.AutoFit
ActiveWindow.ScrollColumn = 3
ActiveWindow.SmallScroll ToRight:=4
Columns("N:N").EntireColumn.AutoFit
Columns("M:M").EntireColumn.AutoFit
Columns("L:L").EntireColumn.AutoFit
Columns("K:K").EntireColumn.AutoFit
Columns("J:J").EntireColumn.AutoFit
Columns("I:I").EntireColumn.AutoFit
Columns("H:H").Select
Columns("H:H").EntireColumn.AutoFit
Columns("G:G").EntireColumn.AutoFit
Range("D1").Select
Columns("F:F").EntireColumn.AutoFit
Columns("E:E").EntireColumn.AutoFit
Columns("D:D").EntireColumn.AutoFit
Range("A1").Select
Columns("B:B").EntireColumn.AutoFit
Columns("C:C").EntireColumn.AutoFit
Range("A1:T1").Select
Selection.Font.Bold = True
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 90
.ShrinkToFit = False
.MergeCells = False
End With
Range("A1:AD1").Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.ShrinkToFit = False
.MergeCells = False
End With
Range("C1").Select
End Sub
ALso wenn mir jemand helfen kann, ich wäre Dankbar. Die Datei kann ich leider nicht ins Netz stellen, sind vertauliche Daten