September 23, 2005 at 9:03 am
Does anyone know a way to export pages to and excel workbook and update the page tab titles to a data driven title so it can be more meaningful than sheet1, sheet2, etc...
I have managed to get page breaks where I need them, but will have a query returning a varying number of subjects (or pages) that I want to tag correct titles on the page tabs.
Any help would be appreciated - Thanks.
September 25, 2005 at 7:14 am
I haven't gotten this to work yet, tried setting the (html) tooltip and naming the table, all with no success. I tried to see if RS2K5 has changed but had some trouble transferring the excel file, so can't confirm or deny at this stage. I'm now at the stage of having to write a macro to do the name change post-export which is less than optimal. Maybe we should all send this through on the sqlwish email address?!?
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply