In trying to determine the cell values from an excel doc, all is fine with the exception of "combobox" values (excel format control ?). Cell A10 in an xls file is a combobox. When i use the following:
?oExcel.ActiveSheet.Range("A10").Value
The value is empty, but looking at the doc, there is a value in the combobox. How do u determine the value shown in the combo?