Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mass filename change

    I need to change the names of a group of files that get carried forward each month to a new month's folder. I'd like to amend the filename now showing as 102 text.xls to 102 text October 2003.xls, and so on each new month. Is there some utility that would enable me to do this, or does it require a batch file, or what? This is on a network, in case that makes a difference. Thanks.

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mass filename change

    TheRename is something I have been using for a fair number of years. It is an incredible timesaver. Make sure that you learn the keyboard shortcuts - otherwise you'll spend a fair amount of time clicking through menus. I can't remember whether it now has an Undo feature, but - as a general precaution - make sure you back all your files up before you start renaming them in bulk. Network use should not be an issue - provided you've got the appropriate permissions. HTH
    Gre

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: mass filename change

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Torquemade

    There are a lot of neat utilities you can grab and have them do the job. The one I use is called Renamer 1.5 and you can grab it and read about if from this web site.

    But since these are Excel files, I would suggest you use VBA to do the work. Head over to the Excel Lounge and I'll help you there

    HTH

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mass filename change

    Thanks. Checked out the site and will probably give this a try. Looks like what I need on-the-nose.

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mass filename change

    Ok..will post a similar question on the Excel forum. Went to the site. In German. Can't read German. Thanks anyway-I'm going to try the other program first.

Posting Permissions

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