I know I know, there are many threads on exporting to excel, though I haven't seen any going this route.
I'm going off the solution in the following link, though there are a few things I need that are different then what is shown.
http://blogs.msdn.com/b/brian_jones/archive/2008/11/04/document-assembly-solution-for-spreadsheetml.aspx
The solution shown relys on a "Template" file to be location on the client machine, and Hard Codes the Save Path and File Name.
This works, and produces the perfect file in the end, but I need the user to be prompted with the standard Save As diag option. As you'd see with other methods where you export in the form of CSV file.
//Make a copy of the template file
Go to the complete details ...