+ Reply to Thread
Results 1 to 10 of 10

Copy & Move multiple certain name specific files to another Folder.

  1. #1
    Registered User
    Join Date
    06-15-2016
    Location
    canada
    MS-Off Ver
    2013
    Posts
    63

    Copy & Move multiple certain name specific files to another Folder.

    I have looked through the forum but couldn't find what I am looking for.

    Anybody has a code where it looks for defined specific names on one folder and then copies it to another folder.

    any help would be greatly appreciated!

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Copy & Move multiple certain name specific files to another Folder.

    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    06-15-2016
    Location
    canada
    MS-Off Ver
    2013
    Posts
    63

    Re: Copy & Move multiple certain name specific files to another Folder.

    Quote Originally Posted by Tinbendr View Post
    Please Login or Register  to view this content.
    Thanks, but from what i see, your code looks for extension and then copy/move. I want certain files to be copied since there are a lot of items in the folder with the same extensions.

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Copy & Move multiple certain name specific files to another Folder.

    Change filterstring to any legal wildcard pattern.

  5. #5
    Registered User
    Join Date
    06-15-2016
    Location
    canada
    MS-Off Ver
    2013
    Posts
    63

    Re: Copy & Move multiple certain name specific files to another Folder.

    Quote Originally Posted by Tinbendr View Post
    Change filterstring to any legal wildcard pattern.
    Your code compiles but does not copy files from one folder to another. It runs but does not do anything.

    ps

    I have 2 files that I need from inside a folder

    RB1.pdf
    RB2.pdf

    Would this work?

    Please Login or Register  to view this content.

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Copy & Move multiple certain name specific files to another Folder.

    Please Login or Register  to view this content.
    or just this code
    Please Login or Register  to view this content.
    Last edited by Tinbendr; 06-21-2016 at 04:07 PM.

  7. #7
    Registered User
    Join Date
    06-15-2016
    Location
    canada
    MS-Off Ver
    2013
    Posts
    63

    Re: Copy & Move multiple certain name specific files to another Folder.

    Please Login or Register  to view this content.

    Runs but doesn't do anything

  8. #8
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Copy & Move multiple certain name specific files to another Folder.

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    06-15-2016
    Location
    canada
    MS-Off Ver
    2013
    Posts
    63

    Re: Copy & Move multiple certain name specific files to another Folder.

    Thanks for the help, but It does the same thing. Maybe I am doing something wrong, dunno.

  10. #10
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Copy & Move multiple certain name specific files to another Folder.

    Add a line to see what path name you're generating.

    F8 and step through the code until you pass the debug line. (Be sure to turn on the immediate window.)

    Please Login or Register  to view this content.
    Make sure the name shown matches the actual path.

+ 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] Macro to move all files from one folder to multiple folders
    By mhbealey in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 12-23-2015, 08:35 PM
  3. VBA - Move a specific number of files from one folder to another
    By MonkeyDeath in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2015, 12:25 PM
  4. VBA to copy specific cells from all files in a folder
    By Mehul Jaganiya in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-05-2014, 04:55 PM
  5. Macro to move files from one folder to multiple
    By mishaq in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2014, 04:27 AM
  6. Extract specific column data from specific sheet from multiple files in a folder
    By piggyfox in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-31-2013, 11:51 AM
  7. [SOLVED] Copy 10 rows from specific files in a folder
    By GDM69 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-07-2012, 10:13 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