Dynamically creating new worksheets to an existing excel document

Hi All,

I have an exiting excel workbook say master.xls. Now I need to dynamically create and append a new worksheet to the above master.xls every month end using the Reporting services.

Could you please guide me how dynamically creating the worksheets task can be achieved using the reporting services?

Your any guidance or help in this matter will be highly appreciated.

Thanks in advance

Regards

Raman Kohli

You have a few options.

You could write a VBA macro in your excel book that renders the report as excel and then use the VBA code to move the worksheet from the generated book to your master.xls

Your other option might be to use rs.exe. You will need to create a .rss file, which is basically a VB Script file with access to the RS object model to create the excel download. You could potentially add the code to move the worksheet to your master.xls here too. You then execute this from the command line.

Check this area of MSDN http://msdn2.microsoft.com/en-us/library/ms152908.aspx