' If this is not a DateTime If loColumn.DataType.ToString <> "System.DateTime" Then ' We have to avoid doing this on a DateTime as when we have an empty value such as ' 1899-12-30T00:00:00-05:00, it will be changed to 2010-09-09T00:00:00-04:00. ' The loXslCompiledTransform.Transform() cannot support NULL. ' So, we have to remove them from the value. loRow.Item(lcColumn) = oApp.StrTran(loRow.Item(lcColumn), Chr(0), "") End If