View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MarMo MarMo is offline
external usenet poster
 
Posts: 34
Default verify external data before importing

Hi there ,

In my small application i'd like to import a .cvs , .xls or .txt file into a
known sheet.

I'd like to verify the file that will be imported before the data is
imported.
for example : headers need to match or number of columns must be 5 , etc

These are the steps to follow :
1) Click a button to import
2) open the file for verification and verify some data with criteria.
3) if verification is correct = import data , else close file and stop
importing.

Can someone help me a little bit with this one? or point me in the right
direction.
Thanks
Marmo