All:
Does anyone have experience reading Excel merged cells using WinBatch? I'm trying to read text and all I get back is the value 28.0 (whatever that means)
No matter where I click in the merged cells in Excel, It always tells me that I'm in the upper-left most cell of the group (that makes sense), but I get this strange number (28.0) back when I go to that cell and perform a read:
TheCell=oWS.Cells(RowNum,ColNum)
WholeStr=TheCell.value
Message("The cell value is:",WholeStr)
Also, can all the lines of the merged cells be read as one value (WinBatch variable) crlf included, as if it's a paragraph with many lines?
Any suggestions would be greatly appreciated