Hi,
I am seeking for <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code which will automatically rename the sheets name from multiple workbooks based on cell value in table.
I've example file in attachment. There're 4000 excel files with different lists' names titles. I generate name of workbooks and it's worksheets' names using macro but I have no idea how to recursively rename a bunch of workbooks' worksheets.
In column G - there're paths to files, column B containg names of lists according to files. Some files contain more than one lists.
Lists which names have to be renamed marked yellow. For example lists with name "false_sample_ad" have to be renamed to "true_sample". BUT. There are some lists titled "false_sample 2017" which should be "true_sample_2"
Any ideas? It's a great routine to open every incorrectly named file and rename it, thus, it has to be automated.
Thanks in advance.
I am seeking for <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code which will automatically rename the sheets name from multiple workbooks based on cell value in table.
I've example file in attachment. There're 4000 excel files with different lists' names titles. I generate name of workbooks and it's worksheets' names using macro but I have no idea how to recursively rename a bunch of workbooks' worksheets.
In column G - there're paths to files, column B containg names of lists according to files. Some files contain more than one lists.
Lists which names have to be renamed marked yellow. For example lists with name "false_sample_ad" have to be renamed to "true_sample". BUT. There are some lists titled "false_sample 2017" which should be "true_sample_2"
Any ideas? It's a great routine to open every incorrectly named file and rename it, thus, it has to be automated.
Thanks in advance.