Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel automation - Unable to set properties
Message
From
05/03/2005 12:02:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Excel automation - Unable to set properties
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
00993022
Message ID:
00993022
Views:
64
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
Map
View

Click here to load this message in the networking platform