+ Reply to Thread
Results 1 to 4 of 4

How to rename file of email, pdf, excel in a folder?

  1. #1
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    How to rename file of email, pdf, excel in a folder?

    My folder (C:\) has file of email, pdf, excel including but not limited to:

    ABCcompany1query1A.msg
    DEcompany2query2A.pdf
    FGHcompany3query3A.xls
    NoNeedToRename.xls


    How to rename file as follows (delete "Company" and replace to "reply")?

    ABC1reply1A.msg
    DE2reply2A.pdf
    FGH3reply3A.xls
    NoNeedToRename.xls

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: How to rename file of email, pdf, excel in a folder?

    Hi london7871

    How to rename file as follows (delete "Company" and replace to "reply")?
    Your request and result do not match...
    I assume you are wanting to replace "company" with "" (Nothing) and "query" with "reply"
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to rename file of email, pdf, excel in a folder?

    Thanks sintek.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: How to rename file of email, pdf, excel in a folder?

    Glad I could assist. Thanks for rep+

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 01-21-2014, 10:52 AM
  2. [SOLVED] Rename each file in the folder
    By Aquamore in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-10-2013, 03:51 PM
  3. [SOLVED] get file, copy and rename to common folder
    By zhaype in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2013, 07:57 PM
  4. [SOLVED] import every file in the folder and rename sheet to the imported file name
    By vivek_work in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-04-2012, 02:46 PM
  5. Rename File Names & Repost to Designated Folder
    By Surfmaster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2012, 01:45 PM
  6. Rename file and Create new file with new folder with macro/vba
    By rizki96 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-11-2011, 08:01 AM
  7. Macro using file dialog opener - Cannot delete or rename folder when excel macro is
    By startrekremo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2011, 01:57 AM
  8. rename & copy *.xls file in the folder then move
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-13-2011, 12:22 PM

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