Hi All,
Is it possible to rename the worksheet name for multiple excel files in a specified folder path. Should rename all sheet names to a default value (example: ABC).
Hi All,
Is it possible to rename the worksheet name for multiple excel files in a specified folder path. Should rename all sheet names to a default value (example: ABC).
Last edited by KarthickDijo; 06-16-2023 at 01:43 AM.
Hi there,
Yes that is possible with a macro.
The code below will open a file picker. Select the folder, then all the files you want to rename the sheets.
Change the sheet name from ABC to whatever default you want.
Note: The files can only contain one sheet each as each sheet must have a unique name. If there are multiple sheets, the first one will be renamed.
![]()
Please Login or Register to view this content.
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks