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
