Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel automation - Unable to set properties
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement