Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Automation & Cell Color
Message
De
06/02/2003 08:58:26
 
 
À
06/02/2003 08:52:29
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00749775
Message ID:
00749799
Vues:
28
>>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?

Hi Hilmar,

Excuse me? I have no idea how to use/create/save Excel macros. I can insert data to a cell/range. Change the border & font. Beyond that, I come here to ask for help.

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

Click here to load this message in the networking platform