Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Automation & Cell Color
Message
De
07/02/2003 10:02:12
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
06/02/2003 10:54:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00749775
Message ID:
00750567
Vues:
25
>Hilmar,
>
>I asked some how to create a macro. I formatted a cell with a background color of RED. Here is what the code says:
>
> Range("A1").Select
> With Selection.Interior
> .ColorIndex = 3
> .Pattern = xlSolid
> .PatternColorIndex = xlAutomatic
> End With
>
>So I tried:
>
>.RANGE( "A1" ).Interior.ColorIndex = 3
>
>This worked. So I did the same for all the other colors I'll need.
>
>Thanks for the help.
>Mike

OK, great. As you can see, you can find out most commands by yourself this way. Some commands require constants that VFP doesn't understand - please read my article.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform