Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Sheet Formatting
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01087027
Message ID:
01101839
Views:
16
This works:
With loExcel.ReplaceFormat.Font
        .FontStyle = "Bold"
        .Size = 11
        .Name = 'Tahoma'       
    EndWith
	
	loExcel.Cells.Replace("TOTALS:", "TOTALS:", xlPart, xlByRows, .f., , .f., .t.)
	loExcel.application.WorkBooks(1).save()
Except that the only thing that is getting formatting is the TOTALS: word (not the whole row). Anyway, it's a step forward <g>
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform