Changing Cells' Background Colors in Excel via LabVIEW Platform.

[dp_wave]

Hello!

I would like to be able to change specificifically located cells' background colors in Excel files after "running" a LabVIEW VI. This can be easily accomplished when you're working within the Excel application (i.e. Position the cursor to the wanted cell & click FORMAT --> CELLS --> PATTERNS --> COLOR). Does someone know how these same actions can be realized via a LabVIEW VI, without going into the Excel application?

Thank you!

[smercurio_fc]

Is this without the Office Reporting toolkit (or whatever it's called)? If so, you need to use ActiveX. This isn't difficult, but you need to dig down into the ActiveX documentation to find the object. An easy way to find this out is to record a macro doing what you want to do, and you usually get the objects being used. Attached is a simple example (LabVIEW 8.20)

[dp_wave]

I believe it's without the OR toolkit as I am using version 6i? The Active X palette comprises Container, Variant, & Automation Refnum. Thanks for the example but unfortunately I can't display it since I'm using 6i.

[smercurio_fc]

Well, the best I can do is to save it back to 7.1.1. I don't have 7.0 to be able to save it back to 6i. I'm posting a picture of the code that you can use to try to replicate it.

Message Edited by smercurio_fc on 08-27-2007 03:03 PM

[dp_wave]

Smercurio...Thanks for your efforts...I'll try to make it happen in 6i with your code!

[dp_wave]

FYI.

I downloaded evaluation LV8.5 & works perfect...Thanks again!