General information
Category:
COM/DCOM and OLE Automation
Title:
Excel automation - Unable to set properties
Have a strange problem. A few of our clients can't set the first 10 properties below. Excel comes back with an error that says, "Unable to set the LeftHeader property" then the same thing for each of the next 10. I can run the EXACT same code on several different versions of Excel with no problems. Any ideas?
WITH oXLS.Application.ActiveSheet.PageSetup
.LeftHeader = tSheetName
.CenterFooter = "&P of &N"
.RightFooter = "&D - &T"
.LeftMargin = cnCentimetersToPoints * 1.9
.RightMargin = cnInchesToPoints * 0.27244094488189
.TopMargin = cnInchesToPoints * 0.47244094488189
.BottomMargin = cnInchesToPoints * 0.47244094488189
.HeaderMargin = cnInchesToPoints * 0.236220472440945
.FooterMargin = cnInchesToPoints * 0.236220472440945
.Orientation = xlLandscape
.Zoom = .f.
.FitToPagesWide = 1
.FitToPagesTall = .f.
.PrintTitleRows = "$1:$1" && repeats header on each page
ENDWITH
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only