file rename

  1. C

    Save and Rename PDF via URL

    Morning Everyone, I have looked all over for a solution, or even one I can cobble together, but it has been too many years, and it seems a lot has changed in terms of the complexity of offered solutions since I last visited! :( I have list of URLs in excel that all have a PDF as an endpoint...
  2. L

    Merge and Rename Worksheets Based on Matching Cell Values

    Good morning, I have excel files in directories that I need to rename based on the value in specific cells in each worksheet and need help with a macro code to achieve this. I would like the macro to loop through the folders and rename each file based on the value it finds in the indicated...
  3. R

    VBA Batch File Renaming

    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...
  4. L

    VBA - Iteration to copy & rename files in folder

    I have about 30 files to copy to a new folder & rename the files with the date format ddmmyyyy added at the end of the filename before the Ext identifier ie filename.doc? to filename ddmmyyyy.doc? (I also need to modify actual files and want to do this via a macro iteration but one step at a...
  5. J

    Folder & File Reorganization - Error 13 Mismatch

    I was trying to help my HR department out real quick with a folder reorg/rename project. My code below works great for all of the pdf files, bur errors out with Microsoft files. Yes, it is a very brute force method, but the idea was a one-time use... Any help would be appreciated. Option...
  6. C

    Rename files in multiple folders and copy to new folder

    For the last year I have been downloading cash register X1 and Z1 files onto an SD card. Each night's files (X1 & Z1) are stored in a new folder with the naming convention "RP + [DATE]", (EX: RP120910, [YYMMDD]). I have 265 folders!!!<br><br> I need to go through each folder, select the Z1 file...
  7. J

    File Renamer

    I found the following script which renames files, can someone please help with a script which will highlight each cell that wasn't changed as yellow. Sub ReName() Dim r As Range, msg As String For Each r In Range("a1", Range("a" & Rows.Count).End(xlUp)) If (r.Value <> "") * (r.Offset(...
  8. C

    File replication/copy and find replace text/numbers within doc

    Hi , i have a word doc that i need to replicate/copy multiple times. I need only to change three numbers in the header of the word doc that will be supplied for the rest of the docs through an excel file with 3 columns holding the new set of numbers to be added to different cells in the word doc...
  9. P

    Rename Fils from Excel Spsheet?

    I have appx 25k files in several folders numericaly named ???.mp3 I have a corresponding excel spreadsheet which contains all the same number of filenames in the text version. How do I use the names in the excel spreadsheet and rename the files?? Can anyone help me with this? Thanks in advance

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top