Results 1 to 14 of 14

VB Code to Move Files

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to Move Files

    Hello:

    Please refer to attached file.
    I have lot of Stores and i have created Folder for each Stores to store scanned files
    Main folder for each store is in C:\Dropbox\
    and each store have sub folders listed in cell C6 down

    For example :
    Store1

    C:\Dropbox\Store1
    C:\Dropbox\Store1\BankStatement
    C:\Dropbox\Store1\CDI
    C:\Dropbox\Store1\DQStore_Rep

    and so on...

    Now I scanned all invoices etc for all stores once a week.
    All Scanned files for all stores will be at location in cell E4:
    C:\Dropbox\1Scanned\

    Each scanned file will have names as follows:

    mm-dd-yyyy-StoreName-Catagory.pdf

    I need a VB Code to move the files to correct StoreName and correct category folder.

    For Example:

    10-22-2015-Store1-BankStatement needs to be moved from C:\Dropbox\1Scanned to C:\Dropbox\Store1\BankStatement
    10-22-2015-Store3-CDI needs to be moved from C:\Dropbox\1Scanned to C:\Dropbox\Store2\CDI

    Let me know if you have any questions.
    Thanks.
    RM
    Attached Files Attached Files
    Last edited by rizmomin; 10-22-2015 at 05:24 PM.

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: 05-29-2015, 10:40 AM
  2. VBA code to move multiple files to different folders based on the file name
    By MissaLissa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2015, 10:19 AM
  3. Macro to move code to cell, print, then move down the list to the next code
    By MilesDeep in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2014, 04:59 PM
  4. Replies: 2
    Last Post: 02-10-2014, 11:52 AM
  5. [SOLVED] VBA Code to Move Excel files from one folder to another
    By MHamid in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-04-2013, 12:33 PM
  6. Excel Macro Code Request for List files and Move specified directory
    By ganeshinscribe in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-19-2012, 08:38 AM
  7. Problem with code - move files to another directory
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-14-2011, 10:06 AM

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