Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auto excel borders
Message
De
23/02/2013 08:41:44
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01566801
Message ID:
01566808
Vues:
68
>Does anyone know how to place a border around a group of cells in excel automation.
>so far so good.
>thanks
>k
>
>oRange = oWorkbook.Sheets[1].range("A1", "B2") 
>oRange.Interior.ColorIndex = 41
>oRange.Font.Name= "corbel"
>oRange.Font.Size= 11 
>oRange.Font.Italic = .T.
>oRange.Font.Bold = .T.
>oRange.font.ColorIndex = 19
>
Check out the Borders collection. Here's the Help for the 2007 version, but it shouldn't be terribly different, whatever version you're using: http://msdn.microsoft.com/en-us/library/office/bb210096%28v=office.12%29.aspx

Tamar
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform