topic Rename Sheet in QlikView https://community.qlik.com/t5/QlikView/Rename-Sheet/m-p/480304#M179478 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-style: inherit; font-family: inherit;">Hi, I have a macro that I exported all my data to a document qlikview excel, I need help to do that within this macro to rename all the leaves I open this same macro, I hope I can provide the code, and that help me to tell me where to place the code within the macro.</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-style: inherit; font-family: inherit;">Best Regards Thanks ....</SPAN></P></BODY></HTML> Wed, 16 Oct 2013 18:51:31 GMT 2013-10-16T18:51:31Z Rename Sheet https://community.qlik.com/t5/QlikView/Rename-Sheet/m-p/480304#M179478 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-style: inherit; font-family: inherit;">Hi, I have a macro that I exported all my data to a document qlikview excel, I need help to do that within this macro to rename all the leaves I open this same macro, I hope I can provide the code, and that help me to tell me where to place the code within the macro.</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-style: inherit; font-family: inherit;">Best Regards Thanks ....</SPAN></P></BODY></HTML> Wed, 16 Oct 2013 18:51:31 GMT https://community.qlik.com/t5/QlikView/Rename-Sheet/m-p/480304#M179478 2013-10-16T18:51:31Z Re: Rename Sheet https://community.qlik.com/t5/QlikView/Rename-Sheet/m-p/480305#M179479 <HTML><HEAD></HEAD><BODY><P>you will need to explain what you mean as I dont understand what you want</P><P></P><P>Regards</P><P></P><P>Alan</P></BODY></HTML> Wed, 16 Oct 2013 21:17:54 GMT https://community.qlik.com/t5/QlikView/Rename-Sheet/m-p/480305#M179479 rustyfishbones 2013-10-16T21:17:54Z Re: Rename Sheet https://community.qlik.com/t5/QlikView/Rename-Sheet/m-p/480306#M179480 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><PRE __default_attr="java" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13819592385631546" jivemacro_uid="_13819592385631546" modifiedtitle="true"> <P>set XLSheet = XLDoc.Worksheets("Sheet1") 'sheet to have name changed</P> <P></P> <P>XLSheet.Name = "New NAme" </P> </PRE></BODY></HTML> Wed, 16 Oct 2013 21:34:39 GMT https://community.qlik.com/t5/QlikView/Rename-Sheet/m-p/480306#M179480 Clever_Anjos 2013-10-16T21:34:39Z