Determining Excel Formats quickly.
Hello,
I have an excel file that is automatically loaded into a database. However,
from time to time, the file rejects due to format errors. I can not tell what
these formatting errors are from just looking at the data. Is there a
function, validation or macro that I can use to ensure the workbook is
formatted correctly before the system picks it up to prevent rejection of the
file?
|