Hi All,
I have a form with 2 dropdown (say: cmbA and cmbB) and 1 checklistbox (say: chkbox) and a button(say: btnsubmit). When I select drop down values (cmbA and cmbB), clicked on chkbox and after that when click on btnsubmit, application has to check the cmbB name in a excel sheet (Sheet1) (here sheet1, sheet2 are nothing but cmbB dropdown values, I am talking in terms of naming convension).
Once Checked in the excel sheet, it has to verify the data if not in a correct format (say: in excel sheet date of birth is written in MM-DD-YYYY format but I have check the excel sheet data as per my programing logic in DD-YYYYY-MM format) display one message says that these many particular records are in a correct format and these are not. If the user want to put data in correct format he/she has to click on 'OK' and automatically the wrong format data will convert into correct format After that generate a log file which says that these many records and line no. of excel sheet has been modified. Please help if any one has any idea, or give me some examples. Any input is highly appreciated. Thanks in advance...