store excel in specified location

I want to populate the data from DataSet to Excel file and then the Excel file should be directly s开发者_如何学编程tored to a particular path like C:\ and the save pop up message should not appear. Please give me specific reply on how to store it on specified location as I am able to populate the Excel and to store I am getting the pop up message window which I don't want.

Have you consider, implementing this?

It's pretty straight forward if read.

Here is the solution that you are looking for