How to check if one cell is larger than another

[#1]

Hi all,

I would like save a table to .qvd, but want to check if one input cell( a date), is larger than another before saving using a macro.

ie. I've attached the sample app., but want to show a message box if the New RFS date(cell 4) is larger the ROA date(cell 2)

I've experimented with something like:

' set a reference to the object that we are going to export

    set rExportTable = ActiveDocument.GetSheetObject(gsExportInputPhaseDates)

          ' if the first cell is not the same as the FSAM then there are no changes to export, so just get out of here

          set cellrfs = rExportTable.GetCell(1,1)

     set cellroa = rExportTable.GetCell(1,3)

          if (cellrfs.Text) < (cellroa.Text)

                    ' do nothing

          else

                    showResultText "Please enter a valid RFS Date", 1

                    exit sub

          end if

Any help would be appreciated!

Cheers