Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Automation & Cell Color
Message
De
06/02/2003 08:52:29
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
06/02/2003 08:04:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00749775
Message ID:
00749796
Vues:
27
>Hi all,
>
>I would like to change the color of certain cells when I create an Excel report. But can't find the right syntax. The following doesn't work. Could someone please tell me what will work.
>
>.RANGE( "A1").BACKCOLOR = RGB(255,255,128)
>.RANGE( "A1")..PATTERN.COLOR = RGB(255,255,128)
>
>TIA
>Mike

If you save a macro in Excel, what commands are produced?
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform