AW: Datei öffnen
01.06.2010 17:39:33
Peter
Hallo Rainer
Die Datei aus der ich den Dialog starte hat immer den selben Namen nur die Datei wo ich die Daten auslese, die über die getopenApplikation ermittelt wird ist von der Struktur her gleich aber immer einen anderen Namen. Deshalb das im Makro der Name der Datei nicht auftauchen
Hier mal mein Kompletter Code (teils mit Makrorekorder augezeichnet)
Speed-gn-1.xls dieser Name wechselt.
Gruß Peter
Sub Makro2()
neuDatei = Application.GetOpenFilename("Eskalation,*.xls")
If neuDatei = False Then Exit Sub
Workbooks.OpenText _
Filename:=neuDatei, _
Origin:=xlWindows
Range("F2").Select
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("A4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("D2").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("B4").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range("A4").Select
Application.CutCopyMode = False
Selection.Copy
Range("B4").Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Windows("Speed-gn-1.xls").Activate
Range("E2").Select
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("D4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("B4").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("E4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("B5").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("F4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("D6").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("G4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("D7").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("H4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("D8").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("I4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("D9").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("J4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("D10").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("K4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("L4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("D11").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Range("K4").Select
ActiveSheet.Paste
Windows("Speed-gn-1.xls").Activate
Range("D1").Select
Windows("Eskalationstabelle SW und Mitte.xls").Activate
Rows("4:4").Select
Application.CutCopyMode = False
Selection.NumberFormat = "0.00"
With Selection.Font
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
End With
Selection.Font.Bold = True
Selection.Font.Bold = False
Range("A4,J4").Select
Selection.NumberFormat = "m/d/yyyy"
Range("E4,G4,H4,I4,K4,L4").Select
Range("L4").Activate
Selection.NumberFormat = "General"
Range("B4").Select
Selection.Copy
Range("C4:L4").Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Columns("D:D").ColumnWidth = 10.57
Columns("D:D").EntireColumn.AutoFit
Columns("D:D").ColumnWidth = 27.14
Columns("D:D").ColumnWidth = 30.57
Range("E4").Select
Columns("F:F").ColumnWidth = 28.14
Range("E4,G4,H4,I4,K4").Select
Range("K4").Activate
Range("E4,G4,H4,I4,J4,K4,L4").Select
Range("L4").Activate
Selection.NumberFormat = "General"
Range("M4").Select
Range("A5").Select
End Sub