I have a requirement where we get 5 excel files into a shared drive. Each excel has like 14000 records in it, All we have to do is get all the data from all 5 files and append/paste the data into new excel file (Template). I was able to do this task using MS Excel VBO with less records like 4000 records in each file and if it exceeds 4000, I see the error message as - "System.OutOfMemoryException". Did anyone of you faced this before, Please suggest if you know anything related to this.