AW: Makro in Symbolleiste sucht eine andere Datei?
02.06.2008 13:20:00
Volker
Hallo,
hier ist das Makro das mir diese Probleme bereitet:
Sub Makro1()
Selection.Insert Shift:=xlDown
End Sub
Sub Makro2()
ActiveCell.Columns("A:A").EntireColumn.Select
Selection.ColumnWidth = 20
ActiveCell.Offset(0, 1).Columns("A:A").EntireColumn.Select
Selection.ColumnWidth = 50
ActiveCell.Offset(0, 1).Columns("A:A").EntireColumn.Select
Selection.ColumnWidth = 12
ActiveCell.Offset(0, -1).Range("A1").Activate
With ActiveSheet.PageSetup
.PrintTitleRows = ""
.PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftHeader = "Aufmaß-Nr.: &B"
.CenterHeader = "Seite &S"
.RightHeader = "&D"
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = Application.InchesToPoints(0.78740157480315)
.RightMargin = Application.InchesToPoints(0.393700787401575)
.TopMargin = Application.InchesToPoints(1.5748031496063)
.BottomMargin = Application.InchesToPoints(0.78740157480315)
.HeaderMargin = Application.InchesToPoints(0.511811023622047)
.FooterMargin = Application.InchesToPoints(0.511811023622047)
.PrintHeadings = False
.PrintGridlines = False
.PrintNotes = False
'.PrintQuality = 180
.CenterHorizontally = False
.CenterVertically = False
.Orientation = xlPortrait
.Draft = False
.PaperSize = xlPaperA4
.FirstPageNumber = xlAutomatic
.Order = xlDownThenOver
.BlackAndWhite = False
.Zoom = 100
End With
End Sub
Sub Makro3()
ActiveCell.Offset(0, -1).Range("A1").Activate
Selection.Copy Destination:=ActiveCell.Offset(0, 1).Range("A1")
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.Replace What:=":", Replacement:="=", LookAt:= _
xlPart, SearchOrder:=xlByRows, MatchCase:=False
ActiveCell.Offset(0, -1).Range("A1").Activate
End Sub
Sub Makro4()
Application.Goto Reference:="C3:C3"
Selection.NumberFormat = "#,##0.00"
'Selection.NumberFormat = "#,##0.00"
End Sub
dieses ist in der mappe.xlt enthalten. Wie kann ich den Pfad abändern?
Danke euch