How to "Name" the TABS in EXCEL when Exporting from SQL Server Reporting Services..?

I was able to export a MAP SHEET from RS to Excel that contains a simply listing of AGENT NAMES that I can click on and it will take me to their respective Excel TAB....I did this by using some options in the Group Formatting inside my RS report....I think it will work for now.

I do like your idea and so I may use it as well.

Thank you for the input.

M

I like that solution too but...
Could it be worked into an SSIS script task (or something..) to enable automation?

The Holy grail would be reports being schedualled and auto emailed to clients with the multiple named tabs, and no input from the developer (me) at all.

- Gav B.
Business Reporting Analyst

I know this is an old question,...but WHERE do I put this CODE in order to have the TEXT NAME in cell A6 appear as the TAB NAME...?

Incidentally,...I have about 90 tables......    : (

In Excel hit [Alt] + [F11] to open up a whole new world called VBA...
It should be pasted into a module which you could call, for example, "RenameTabsWithA1Value" to be nice and descriptive :)

I'm not too hot on VBA though and although I can understand what that code is saying I couldn't instantly implement it...
I'm a bit busy with other things right now (custom SSRS Schedules...) but I might give it a go soon and post back.

VBA is a good thing to be able to grasp, but if you want to get deeper into programming don't spend too much time learning it and skip to VB.NET (as I will be doing)

no worries...I found the answer...thanks anyway...

So have you got it working?

Yes its working, I now have an open question on if its possible to have SQL SERVER REPORTING SERVICES (VISUAL BASIC) code this as part of the actual EXPORT into EXCEL.

But as far as getting the TABS to be named according to what is in Cell A6 for each worksheet...yes...simple code works....

Post a link to that question in here...

I believe I have a some better VBA code for this solution, please see Code Snippet.

This allows for error handling the fact that Tabs can only be named with 31 characters.

- Gav B.
Business Reporting Analyst

Sub RenameTabs_v1()
' Rename all worksheet tabs with each worksheet's cell A1 contents.
'   If Cell A1 has no content then the tab will not be renamed.
'   If Cell A1 has more than 31 charaters then the sheet will be renamed with the first 31 characters.
'   If Cell A1 contains any of the following 7 characters Excel will return an error;
' / \ : * ? [ or ]
Dim i As Integer
For i = 1 To Sheets.Count
    If (Len(Worksheets(i).Range("A1").Value) < 32) Then
        If (Len(Worksheets(i).Range("A1").Value) > 0) Then
            Sheets(i).Name = Worksheets(i).Range("A1").Value
        End If
    Else  Sheets(i).Name = Left(Worksheets(i).Range("A1").Value, 31)
    End If
Next
End Sub

Select allOpen in new window

This has been working fine. But I'll make reference of your comment. Thanks

https://www.experts-exchange.com/questions/24238190/Renaming-TABS-from-a-CELL-of-text-in-my-Worksheets.html