07-13-2015, 12:37 PM
I did a bit...
Ok, maybe you can clear this one by one.
In the below code I have chosen the entire G column in Excel, which includes the empty cells too.
1) How do I choose just the ones with data.
Note: This column is dynamic and so keeps increasing and decreasing.
2) How do I check if a cell is empty? In the below code, I have tried a simple empty quotes method. Is there a better foolproof way?
Macro NC VCC Release Corrections
Ok, maybe you can clear this one by one.
In the below code I have chosen the entire G column in Excel, which includes the empty cells too.
1) How do I choose just the ones with data.
Note: This column is dynamic and so keeps increasing and decreasing.
2) How do I check if a cell is empty? In the below code, I have tried a simple empty quotes method. Is there a better foolproof way?
Macro NC VCC Release Corrections
ARRAY(str) tempCell
int r
int w1=act(win("Microsoft Excel - LR Sales" "XLMAIN"))
ExcelSheet es.Init
es.Activate(1 "VCC Release Spool") ;;Activate Sheet
es.Activate(4) ;;Bring Excel Window Forward
;es.SelectCell("G1")
;'D
es.CellsToArray(tempCell "G:G")
for r 1 tempCell.len ;;for each row
,if tempCell[0 r]=""
Best Regards,
Philip
Philip