Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel Export - Set tab names

I've searched the forum and don't see a similar question posted so far.  When I use the 'Send to Excel' function, is there a way to set the name of the tab/worksheet? 

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Thanks for pointing me in the right direction.  I found this that really helped me understand how the macro code works.

QlikTip #32: Exporting multiple QV objects to a single Excel document

Now I just have to figure out how it gets implemented in the design of the document.

View solution in original post

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

No, you can only if you use macro (you can find examples on forum)

Not applicable
Author

OK... could you point me to some of those examples?  As I mentioned, I have searched the forum already and wasn't able to find what I was looking for.  I see lots of macros for exporting objects to multiple tabs, but nothing for renaming the sheet tab, and I'm not comfortable enough with writing macros to adapt it myself.

alexandros17
Partner - Champion III
Partner - Champion III

Not applicable
Author

Thanks for pointing me in the right direction.  I found this that really helped me understand how the macro code works.

QlikTip #32: Exporting multiple QV objects to a single Excel document

Now I just have to figure out how it gets implemented in the design of the document.