Naming Worksheet Tabs when report is exported to excel

• Tracy Avis

  Old Hand

  Points: 332

  More actions

  November 8, 2006 at 11:11 pm

  #170960

  Hi

  I have created a report in Reporting Services 2000 that will be exported to excel. I was wondering if there is a way to name the worksheet tabs.

  I have read that this can be done using VB Script/ VBA from Reporting Services to change the tabs. Would someone know how this can be done.

  There may be another way, but one way or the other the tabs on the worksheet have to be changed.

  Thanks

  Tracy

• November 13, 2006 at 8:00 am

  This was removed by the editor as SPAM

• bburton 95542

  SSC Rookie

  Points: 25

  More actions

  January 8, 2011 at 6:22 am

  #1271048

  This is an ongoing issue in my ops reporting group. Upper management wants those worksheets labeled! Anyone out there who can help?

  Thanks