I am not into VBA too deep but can take it up and go a few yards to make stuff work for me.
Here's what I want to do : -
I have 4 files that I generate , as part of a report. File 1 through 4 .xls respectively. Each file has 4 tabs ( worksheets ) inside them . I will call them wk1 through 4 respectively. So file 1.xls has wk1.worksheet wk2.worksheet ...wk4.worksheet . There is another 5th file called template.xls that has a worksheet called Master.worksheet .
I would like to '
<> rename the worksheets of all files File 1 through 4 .xls
e.g.
File 1.xls : rename wk1.worksheet to ren1.worksheet etc....
<> Copy master.worksheet to the beginning of all the excel files File1 through 4 .xls
How can I do this , using Macros or any other automatic approach.
Here's what I want to do : -
I have 4 files that I generate , as part of a report. File 1 through 4 .xls respectively. Each file has 4 tabs ( worksheets ) inside them . I will call them wk1 through 4 respectively. So file 1.xls has wk1.worksheet wk2.worksheet ...wk4.worksheet . There is another 5th file called template.xls that has a worksheet called Master.worksheet .
I would like to '
<> rename the worksheets of all files File 1 through 4 .xls
e.g.
File 1.xls : rename wk1.worksheet to ren1.worksheet etc....
<> Copy master.worksheet to the beginning of all the excel files File1 through 4 .xls
How can I do this , using Macros or any other automatic approach.
