Origin Ver. and Service Release (Select Help-->About Origin): 2016 Operating System: Windows
Hi,
I have five worksheets each with different name. From data in each worksheet I then plot ten different graphs (together I get 50 graphs named Grpah1....Graph50). I want to write a script that would rename each graph with the name of the worksheet and add a number to each sequential graph (e.g. G_Book01_01, G_Book01_02, G_Book01_03... then for the next ten graphs: G_Book02_01, G_Book02_02, G_Book02_03..., etc. for the rest of worksheets and graphs). Any idea how to do this?
it works but it gives me too much data in the names. The graph names are composed as [workbook short name][workbook long name][!column][column long name]. I would like simpler and shorter naming: [workbook long name][two digit number] (e.g. Book1_01, Book1_02, Book1_03... Book2_01, Book2_02, Book2_03...)