batch rename

Hello, I am using a macro to rename all my file in a folder with a specific cell value, the macro also rename the sheetname with the same cell value. It works fine for what I need, the only drawback is that the macro is sometime terribly slow. 1) Could someone give me some tweak to speed-up a...

Hello, I am attempting to batch rename files using the following macro created in VBA: Sub RenameFile() Dim z As String Dim s As String Dim V As Integer Dim TotalRow As Integer TotalRow = ActiveSheet.UsedRange.Rows.Count For V = 1 To TotalRow...

hi all i am new here, this is my first post. i am a school photographer an just about to go online with my small business. Challenge : i have a text file with i.e. 400 random numbers and i have a folder with pictures of 400 kids. i have 6 pic of each kid and i order to be able to auto upload...

Can anyone here tweek this macro for renaming Excel files based on a cell's contents? I use it to rename all the files in a folder based on the text that exists in cell B1. Can you add some more code which would give me a prompt to enter 7 more characters to put right before .xls? Here is the...