I have 50 excel files which has to be imported and appended. Which i have done using a macro but the challenge is each excel sheet has a report date in the header . Which needs to be validated like for example if i am running the code for july the report date  should be july 1 else those excel files should be thrown as exception which has a different report date. (ie. report date should be 1st of every month) ... View more