Excel Highlight\color Cell via VFP Automation 1

[mikeisvfp]

Hello Experts

How do I highlight\color a cell or better yet an entire row?

 

[Mike Lewis]

Assuming that loRange is the range of cells that you want to highlight:

loRange.Interior.ColorIndex = 6

ColorIndex is an integer: 1 = black, 2 = white, 3 = red, .... 6 = yellow, etc.

For the full list of colours, see the VBA Help, or record a macro and pick the colour from the Fill Color button on the toolbar.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[mikeisvfp]

Hi Mike

I used the example from

http://www.tek-tips.com/faqs.cfm?fid=4266

and I tried the above only change I made was
oSheet.range.Interior.ColorIndex = 6
and Im getting a OLE error

 

[mikeisvfp]

Im sorry I posted the wrong link as to where I got my example from here it is

http://www.tek-tips.com/faqs.cfm?fid=4428

 

[mikeisvfp]

nevermind I think I got it correct me if im wrong, but i tested it and it worked

oSheet.Cells(lnRow,lnCol).Interior.ColorIndex = 6 &&yellow

 

[JRB-Bldr]

The method I use to find out how to do an Excel Automation that I have not done before always begins without ANY VFP involvement.

I manually do what I want to do in Excel (all by itself) and record the actions as a Macro.

Then I can examine the Macro code and see how Excel is doing it.

AFTER THAT I can then introduce code into VFP Automation of Excel that accomplishes the same thing in the same manner.

I am glad you found your answer.

Good Luck,
JRB-Bldr

 

[Mike Lewis]

MikeISVFP,

Yes, that looks OK.

Your reference to oSheet.Cells(lnRow,lnCol) is equivalent to my loRange. It's just a different way of specifying the range of cell(s) that you're working with.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[mikeisvfp]

Thank You Mike

Thank you jrbbldr I will try and record actions as a Macro.
and examine the code produced.

I think I might even consider buying the hentzenwerke book, since i find VFP Automation rather interesting.

Thanks
Mike