Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Sheet Formatting
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01087027
Message ID:
01101839
Vues:
14
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform