Results 1 to 17 of 17

Changing File Names in Excel Folder

Threaded View

  1. #1
    Registered User
    Join Date
    01-15-2011
    Location
    Clearfield, UT
    MS-Off Ver
    Excel 2016
    Posts
    58

    Changing File Names in Excel Folder

    snb: It worked! Thanks to everyone for their help! It was very instructional, very helpful, and most appreciated!!!
    JPDutch

    I'm wondering if someone could help me figure out how to write a macro that will allow me to change all file names in one folder (I'd like to change the year). The path is as follows:

    H:\SAFETY\FORMS\ 300 & 300A\2011

    The files look like this:

    Branch 007_2010
    Branch 008_2010
    Branch 009_2010
    Branch 010_2010

    I'd like to change the files to this:

    Branch 007_2011
    Branch 008_2011
    Branch 009_2011
    Branch 010_2011

    Any advice you could give me would be appreciated!
    Last edited by JPDutch; 12-03-2011 at 01:21 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1