+ Reply to Thread
Results 1 to 3 of 3

Rename Files and move them to a cell related location

  1. #1
    Registered User
    Join Date
    12-06-2019
    Location
    Athens, Greece
    MS-Off Ver
    365
    Posts
    6

    Rename Files and move them to a cell related location

    Dear all,
    I have an excel file with the following information. The actual file name is at column A (FILE) but i want to rename it using the following: Column E (KKS) & ( & column F(TITLE) & ) & Rev & Column C (ISSUE).



    FILE DOCUMENT IDENTIFICATION ISSUE DATE KKS TITLE PATH
    483-21-DT-M-00300-Ed001.pdf 483-21-DT-M-00300 1 05-12-19 111915-21-YDS-MDD-EA-00300 P&ID SYMBOLOGY AND GENERAL NOTES PROJECT_483\200 Mechanical Area\221 Systems\221.01 P&IDs
    483-21-FV-D-00001-Ed001.pdf 483-21-FV-D-00001 1 05-12-19 - Monthly Progress Report (NOVEMBER 2019) PROJECT_483\000 Project Management\001 General\001.03 Progress Reports
    483-21-S-M-20250-Ed002.pdf 483-21-S-M-20250 2 04-12-19 111915-21-PA_-MHP-EA-20250 COOLING TOWERS (INDUCED DRAFT) DATA SHEET PROJECT_483\200 Mechanical Area\221 Systems\221.05 Data Sheets

    Then each one of them must be send to a new folder location which is C:\Users\chma\Desktop\F2 - Copy & Column G (but the word PROJECT_483 must be repplaced by the C:\Users\chma\Desktop\F2 - Copy)
    =i.e.
    C:\Users\chma\Desktop\F2 - Copy\200 Mechanical Area\221 Systems\221.01 P&IDs\111915-21-YDS-MDD-EA-00300( P&ID SYMBOLOGY AND GENERAL NOTES)REV1.pdf

    Thank you

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Rename Files and move them to a cell related location

    Please read the yellow banner. Thanks

  3. #3
    Registered User
    Join Date
    12-06-2019
    Location
    Athens, Greece
    MS-Off Ver
    365
    Posts
    6

    Re: Rename Files and move them to a cell related location

    I see 3 of them! I am sorry i am new to it! I don't know how to use the forum properly just yet
    Last edited by Chrysanthiiiiii; 12-06-2019 at 12:11 PM.

+ 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. Rename & move/copy files according to lists using scripts?
    By bcianni in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2019, 12:38 PM
  2. Macro to move files from one folder to another but rename duplicates
    By mark_anthony in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2014, 06:56 AM
  3. Tweak VBA to Move SharePoint Files to a Folder in Same Location
    By n_lindsey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2014, 03:21 PM
  4. Excel to move and rename files
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2012, 07:01 PM
  5. [SOLVED] Move, Rename all files from a folder
    By kinseld5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 12:20 PM
  6. Replies: 1
    Last Post: 10-06-2008, 10:29 PM
  7. Macro to rename and move files
    By Caroline25 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-15-2007, 03:11 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