+ Reply to Thread
Results 1 to 2 of 2

Create folder and move files to that folder based on file name

  1. #1
    Forum Contributor
    Join Date
    12-11-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    517

    Create folder and move files to that folder based on file name

    Hi all, i was wondering if this is possible.
    column G have random numbers. Using VBA, is it possible to create folders in "C:\Test" based on first number in a cell in column G. Once that folder is created then move files that start with that number from C:\Test to the folder created.

    for example
    Column G has value "123456789"
    since first number of the value above is 1, a folder is created in C:\Test\1.
    once that is done, there are files in "C:\Test", the files that start with 12342344 should be moved to Folder C:\Test\1
    just wondering if this is possible

    thanks

  2. #2
    Forum Contributor
    Join Date
    12-11-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    517

    Re: Create folder and move files to that folder based on file name

    Got the 1st part working where folders are created based on first letter of cell value...now just require some help with files that are in C:\Test move them to respective folder based on first number of file name

    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. Replies: 1
    Last Post: 01-28-2019, 06:55 PM
  2. [SOLVED] Loop Through Folder, Create Emails with Sub Folder Names in Subject, Attach files in sub
    By Rschwar23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2015, 10:06 AM
  3. Create FOLDER in subfoldesr and move folders with specific names into FOLDER
    By Amarjeet Singh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2015, 09:46 AM
  4. [SOLVED] VBA Code to Move Individual Files from 1 Folder to a new Folder
    By mike.lawrie448 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-21-2014, 07:05 AM
  5. [SOLVED] Move files from one folder to several others dependent on File name
    By MrSauceBottle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2013, 11:20 AM
  6. 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
  7. Replies: 6
    Last Post: 08-11-2006, 03:41 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