HI,
I have a folder that contains about 30 Excel files. Each file has only one worksheet which is named the same as the file name, Which is a monthly export by month. I need the worksheet name in each file to read "Balance Sheet". How can I change all the worksheet names in 30 files at once?
Thank you, LC
I have a folder that contains about 30 Excel files. Each file has only one worksheet which is named the same as the file name, Which is a monthly export by month. I need the worksheet name in each file to read "Balance Sheet". How can I change all the worksheet names in 30 files at once?
Thank you, LC