Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation & Cell Color
Message
From
06/02/2003 08:58:26
 
 
To
06/02/2003 08:52:29
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00749775
Message ID:
00749799
Views:
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?

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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform