I'm having to read a spreadsheet, and depending on if the column is indented or not, store the value.
If the field's formatting is indented, I ignore it, it if isn't, I store it.
I read the field's value like this...
VB Code:
myVariable = exll.Worksheets(TabName).Cells(12, 1).Value.ToString
But how can I read how the field is formatted??
So it would end up something to the effect of ...
VB Code:
if ( exll.Worksheets(TabName).Cells(12, 1).FORMAT_IS_CORRECT ?? )then myVariable = exll.Worksheets(TabName).Cells(12, 1).Value.ToString else myVariable = "Skipped Value" End If




Reply With Quote