Good afternoon.
In a folder I have several excel files that have a sheet inside them, with the same file name.
Outside the folder I would like to include in a excel file a macro to change the name of the sheet of each file, giving the sheet a same denomination, valid for all files.
It's possible to do it?
Thank you
Ciao Stefano. Could you please explain in more detail by using an example. What is the actual name of the sheet in each of your files? What is the new name that you want to assign to each sheet?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Name file 1: itOriginally Posted by Mumps1
Sheet name: it
Name file 2: fr
Sheet name: fr
after the macro is turned on the name changes as follows:
Name file 1: it
Sheet name: geonames
Name file 2: fr
Sheet name: geonames
Try this macro in a new workbook. The macro assumes that only the files that you want to change are in the source folder and that the index number of the sheet you want to change is 1: for example: Sheet1("it"), Sheet1("fr"). Change the folder path in the code to suit your needs.
Please Login or Register to view this content.
Good morning.
The macro does not work well.
Also, is possible to change the macro code so that i can select the folder that contains the files (this folder is in the "GEONAMES" folder) and delete the blank sheets?
I attach a sample file.
link:
https://www.dropbox.com/s/fu2zhrl6ob...umps1.zip?dl=0
Try this macro. Your files are very large so be patient with the amount of time it takes to run the macro. When the 'Select Folder' window opens up, you will be able to choose the sub folder. Make sure that only the files you want changed are in that subfolder.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks