+ Reply to Thread
Results 1 to 4 of 4

Moving files to another folder based on a list

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    12

    Moving files to another folder based on a list

    Hi,

    I have an excel sheet that populates a list and I need to move files that partially contain the text populated in this list from one folder to another. They are all .xlxs files. The list will contain different text strings every week.

    Thank you!

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Moving files to another folder based on a list

    I am not sure if you mean partial word matching in the filename or in the file's content.

    Provide an example list or attach a file with to and from paths. To attach a file, click the Go Advanced button in lower right of a reply and then click the paperclip icon in toolbar, Browse, and Upload.

  3. #3
    Registered User
    Join Date
    11-25-2015
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    12

    Re: Moving files to another folder based on a list

    Hi,

    I mean a partial match in the filename. The list populates with a number and the filename of the files contain this numberbut also text. EG. List = 12345, 67891. Filename = AAA_AAAAAAAAAA_12345, BBB_BBBBBBBBBB_67891. The filenames always follow the syntax 3 characters underscore 10 characters underscore 5 numbers but their content will change on a weekly basis.

  4. #4
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Moving files to another folder based on a list

    Change the cell A1 and file paths to suit. Right click your sheet's tab, View > Code, and paste.
    Please Login or Register  to view this content.

+ 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. Copying/moving files to a pre-exsiting sub-folder based upon column attribute
    By jlharrin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2016, 11:06 AM
  2. Replies: 1
    Last Post: 12-09-2015, 05:43 AM
  3. Macro - move files to folder based on list in worksheet
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2015, 05:57 PM
  4. move files to folder based on a .igy list
    By henkdevreisch in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-14-2013, 01:42 PM
  5. [SOLVED] Moving files from folder based on the excel data
    By WT2008 in forum Excel General
    Replies: 9
    Last Post: 06-22-2012, 11:48 PM
  6. Moving files folder to folder using macro.
    By azureriders in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2011, 01:04 AM
  7. Moving all but the newest files from one folder to an Archive folder.
    By Zaphius in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2007, 11:48 PM

Tags for this Thread

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