Asp.net SSRS 2008 (RDLC) export to Excel Report with Naming of Sheets

[ufsirfi]

I'm working on a VS 2008 asp.net webforms application in which it contains an existing RDLC (Client file, and NOT the RDL Server side file) What the break/fix problem is: Upon exporting to excel, all of the worksheets are not named properly. I have found many examples on exporting data, on SQL Server 2008 R2 feature of RDL (Article said RDLC which is not true as there is no Initial Page / PageName tab etc... in RDLC)Does anyone know about how to either "fix" this or do some sort of post processing to rename the tabs so the customer doesn't end up seeing Sheet1, Sheet2, Sheet3 etc... ?[*]Application is choosing the path of the RDLC file[*]Adds DataSource[*]Chooses xls[*]Does all the ResponsesI see this Stackoverflow link How to get named excel sheets while exporting from SSRS However1. Can't do the Macro2. Can't do the export as SSML3. It is NOT using RDL / SQL Server 2008 R2 SSRS , thus the other answers are misleading for people using the RDLC