Excel vba rename files based on list

If there are multiple files that you want to rename, first, you can list the old file names in a column of worksheet, and then enter the new filenames that you want to replace with. Free software Rename-It! I wanted to be a bit organized and have all the related files for each video tip in its own folder.

This meant creating new folders and then naming them based on each tip in my post. Since I already had my tip titles listed in an Excel sheet, this was the perfect task for a little bit of VBA. I set up a named range in my sheet called MakeFolderPath as an input for a folder path. This is where you can put the location you want to create all your folders.

You might already have the folders set up but need to rename them to some new naming convention. When I was setting up my folders, I have the forethought to prefix them with a number including leading zeros so that sorting them alphabetically arranged them in the order I wanted them to appear. The named range to read the path is called RenameFolderPath and the table containing my list of folder names and their corresponding new name is called RenameFolderNames.

We just need to reference our New Name and we can do that using an Offset from the Original Name since it is one column to the right of the Original Name. Doing this manually would be a very tedious task. Copy tip title into clipboard. Open the file explorer and right click to create a new folder. Download Example File. If you want to hide every other row in your current worksheet, how This post will show you how to use a VBA Macro to save an Excel file and overwrite any existing file without a prompt so that you are going to get the little window that says file already exists do How do I count cells that contain odd numbers through the use You can count the number of negative numbers in your data using easy functions How do I count the number of cells that are not blank in a particular How do I count cells that are less than a specific You should also read How do I ask a good question?

Add a comment. Active Oldest Votes. ReadLine 'Debug. Improve this answer. Community Bot 1. Regarding speed: you might get better performance by 1 reading as binary using a specific buffer size e. I expect that reading line-by-line may protect you from the case where a "dumb" buffer splits the text you are searching for, but perhaps you instead do multiple readlines and then do a search on a bigger chunk. The bash script works on Windows. The reason to port to VBA is to get a routine that is encapsulated within the Excel file itself.

Given the user base, this Excel file is going to be in several hands and I don't want to tie it to the "perfect environment".