Hello,

I have two xls files: file1.xls and file2.xls

1. File1.xls has been filled by a user via a data base thanks to VB.NET
code. At that level, let's suppose he doesn't know our specific constraints.
2. Each column of file2.xls is associated with "Data Validation" constraints.

I would like to use "Data Validation" of file2.xls to check file1.xls

Is it possible to check by program (via VB code ) if the content of cell
"A1" of file1.xls is OK according "Data Validation" defined in the cell "A1"
of file2.xls (after file1.xls has been fully filled)?

Thank you