Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Export to Excel With Coloured Rows
Message
 
To
11/02/2013 05:02:59
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01565703
Message ID:
01565722
Views:
58
Harsh:
Here's the code that you need. This code executes after you have exported the data to Excel, and opened the Excel file in FoxPro via automation.
FOR x = 1 TO oExcel.ActiveSheet.UsedRange.Rows.Count
	IF (filed remarks of my Table has "N" Value)
		oExcel.ActiveSheet.Rows(x).Font.Color = -1003520 && This is the code for blue.  Look up the code for your shade of red.
	ENDIF
ENDFOR
Previous
Reply
Map
View

Click here to load this message in the networking platform