Joining excel files

Question

Hi,


I am having trouble joining multiple excel files. on a day to day basis i generate multiple reports that all have the same header row. I want to merge all of the excel files into 1 file from a WinForm. 


I want to be able to Select a directory which contains multiple excels, and then click a button that removes the header from all of the files (apart from the first 1) and then joins them all together, so my end result is 1 excel file.


e.g.

a folder on my desktop contains 3 excel files:

File 1 contains 5 rows (including header)
File 2 contains 10 rows (including header)
file 3 contains 2 rows (including header)

when I click the button on my form, i want it to create a new excel document which contains 15 rows (with 1 header row). so it only keeps the header from 1 file.


is anyone able to help me code this? I am completely new with using microsoft.office.interop.excel and just cant work out how to do it.


Many thanks,

AC