While save a table to MS Excel using ActiveX, how to:
1. For the 3rd row, if the value less than 1.67, printing that cell with color 13551615;
2. Freeze the 5th row;
3. Delete sheet 3;
The following pic. captured from Macro, pls help.
Question is how to use activeX method or property to fulfill the three function?
like this property can set the font size of the letters you saved to Excel.
Thank you for already following my suggestion to post your own Question. So here is a followup question to Mike Porter's -- why LabVIEW?
I'm going to digress a bit here -- I have a colleague who wants LabVIEW to be installed on a big Super-Computer that he wants to use because it has some very powerful image-processing software. Why does he want LabVIEW? Because he wants to do a Directory Search for all the files on this machine (which has many terabytes of storage) that match a given pattern. And he knows LabVIEW. "When your only Tool is a Hammer, every Problem is a Nail".
What is it that you want to do in LabVIEW? How does it interact with Excel? It sure sounds like you are using LabVIEW to avoid developing VBA code ...
If you really need to use LabVIEW, look at the Report Generation Toolkit that ships with modern releases of LabVIEW. It is surprisingly easy to use, quite versatile, and may well be able to handle your task.