Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Best Regards Thanks ....
Try this
set XLSheet = XLDoc.Worksheets("Sheet1") 'sheet to have name changed
XLSheet.Name = "New NAme"
you will need to explain what you mean as I dont understand what you want
Regards
Alan
Try this
set XLSheet = XLDoc.Worksheets("Sheet1") 'sheet to have name changed
XLSheet.Name = "New NAme"