Renaming Files with Excel VBA

by

I think you could do something like this, using the Name function to rename the files, however, you will probably need to make sure the 2 columns have the complete file path, i.e. “C:\Temp\ABC.jpg”

Dim Source As Range
Dim OldFile As String
Dim NewFile As String

Set Source = Cells(1, 1).CurrentRegion

For Row = 1 To Source.Rows.Count
    OldFile = ActiveSheet.Cells(Row, 1)
    NewFile = ActiveSheet.Cells(Row, 2)

    ' rename files
    Name OldFile As Newfile

Next

More Related Contents:

  1. excel vba compare & copy worksheets from 2 excel files
  2. How to avoid using Select in Excel VBA
  3. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  4. Convert Text to Date?
  5. Run Excel Macro from Outside Excel Using VBScript From Command Line
  6. Importing text file into excel sheet
  7. Loop through each cell in a range of cells when given a Range object
  8. Checking for #N/A in Excel cell from VBA code
  9. Non-web SQL Injection
  10. Error: “Could Not Find Installable ISAM”
  11. Filling any empty cells with the value above
  12. Is there a way to slow down a Web Scraper so it will pick up the code?
  13. Create a folder and sub folder in Excel VBA
  14. One-dimensional array from Excel Range
  15. How to delete multiple rows without a loop in Excel VBA
  16. Excel vba to create every possible combination of a Range
  17. Run a Macro from Another Workbook
  18. Sorting a dictionary by key in VBA
  19. Handle “No cells were found” error when filtered range is empty
  20. VBA paste as values – how to
  21. Excel: the Incredible Shrinking and Expanding Controls [closed]
  22. What are the benefits of using Classes in VBA? [closed]
  23. Writing a VLOOKUP function in vba
  24. Generate Word Documents (in Excel VBA) from a series of Document Templates
  25. Handle cancellation of InputBox to select range
  26. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  27. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  28. Create folder path if does not exist (saving from VBA)
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment