+ Reply to Thread
Results 1 to 4 of 4

Excel VBA – Copy or Move files from one folder to another

  1. #1
    Registered User
    Join Date
    11-09-2018
    Location
    Hyderabad
    MS-Off Ver
    2007
    Posts
    7

    Excel VBA – Copy or Move files from one folder to another

    Am having two folders “A” & “B” in A folder having 1000 files (word & rtf files) I need to copy only 10 files form the 1000 files (A folder) to B (folder). Is there any VBA code in excel for folder searching and copying.

    10 files list is given excel column “B”

    In column, B updated as “MOVED” if document found in A folder and moved to B folder

    In column, B updated as “Does Not Exists” if document not found in A folder and gives an message.


    Please modified the below code and it should be ask for source path and move to specific folder as not by default like below one’s.

    Please do the needful and thanks in advance

    Below code copied from other online sources only.....

    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 02-25-2020 at 03:36 AM. Reason: Code tags

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

    Re: Excel VBA – Copy or Move files from one folder to another

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks

  3. #3
    Registered User
    Join Date
    11-09-2018
    Location
    Hyderabad
    MS-Off Ver
    2007
    Posts
    7

    Re: Excel VBA – Copy or Move files from one folder to another

    Please anyone help me in this regards....

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

    Re: Excel VBA – Copy or Move files from one folder to another

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    As you are new I will add the link for you.Please read forum rules

    https://www.msofficeforums.com/excel...n-another.html

+ 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: 18
    Last Post: 02-18-2019, 07:42 AM
  2. Replies: 1
    Last Post: 01-28-2019, 06:55 PM
  3. VBA for Move copy Delete files from Folder
    By balajisx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2017, 04:26 AM
  4. Copy & Move multiple certain name specific files to another Folder.
    By kandoo1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-22-2016, 11:02 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. Move Excel files from One folder to another
    By yus786 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-04-2013, 05:58 AM
  7. Move Excel files to an Outlook folder
    By ninja0059 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2008, 02:18 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