Forum Discussion

awhawh's avatar
awhawh
Contributor
8 years ago

Excel comparison cell by cell using Text method returning hash characters

Hi,   I'm trying to compare two excel files cell by cell and then calling aqString.Compare to do the actual comparison on the text returned. I've got the mechanism working; however, the 'Text' meth...
  • shankar_r's avatar
    shankar_r
    8 years ago

    Hi,

     

    Are you using which method to get the cell value using Range("A1") or Cell(1,1)? 

     

    both has property called Value2 or Value_2 to get cell value can you try these.

     

    If still face any issues, post your code here.

shankar_r's avatar
shankar_r
Community Hero
8 years ago

Hi,

 

Are you using which method to get the cell value using Range("A1") or Cell(1,1)? 

 

both has property called Value2 or Value_2 to get cell value can you try these.

 

If still face any issues, post your code here.

  • awhawh's avatar
    awhawh
    Contributor
    8 years ago

    Thanks, Shankar.

     

    Value2 doesn't actually display the date in a date format, unfortunately, but it does at least recognise the difference in the dates which is the main thing