Hi,
i have a little problem formatting an Excel sheet.
I am using this code:
$oXL.ActiveSheet.PageSetup.LeftHeader = "This is the left header"
$oXL.ActiveSheet.PageSetup.CenterHeader = ""
$oXL.ActiveSheet.PageSetup.RightHeader = @DATE
$oXL.ActiveSheet.PageSetup.LeftFooter = ""
$oXL.ActiveSheet.PageSetup.CenterFooter = ""
$oXL.ActiveSheet.PageSetup.RightFooter = "Page &P of &N"
$oXL.ActiveSheet.PageSetup.Orientation = 2
$oXL.ActiveSheet.PageSetup.Zoom = -1
$oXL.ActiveSheet.PageSetup.FitToPagesWide = 1
$oXL.ActiveSheet.PageSetup.FitToPagesTall = 50
$oXL.ActiveSheet.PageSetup.PrintTitleRows = "$$2:$$2"
$oXL.ActiveSheet.PageSetup.PrintTitleColumns = ""

Everything works fine except the following lines:

$oXL.ActiveSheet.PageSetup.FitToPagesWide = 1
$oXL.ActiveSheet.PageSetup.FitToPagesTall = 50

I have monitored a macro in Excel and there is the following line:

.ActiveSheet.PageSetup.Zoom = False

Maybe that is my problem !? I have tried different variations of the line but nothing worked:

$oXL.ActiveSheet.PageSetup.Zoom = "False"
$oXL.ActiveSheet.PageSetup.Zoom = -1
$oXL.ActiveSheet.PageSetup.Zoom = 0

Any idea ?

Greetings
spocky184