+ Reply to Thread
Results 1 to 6 of 6

vba to copy specific files extension to their respective folders

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    vba to copy specific files extension to their respective folders

    Hi All

    I have on my desktop folder named tools in which there are mixed files of doc ,xlsm,xls,xlsx,jpeg,pdf,csv.

    vba code to copy specific files extension to their respective folders on the desktop all *.xlsm will be paste to AAA folder, xls will paste to BBB folder, xlsx will paste to CCC folder,jpeg will paster to DDD folder, pdf will paste to EEE folder and csv will paste to fff folder.

    thanks if anyone can assist

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,006

    Re: vba to copy specific files extension to their respective folders

    What code have you tried so far ?

  3. #3
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: vba to copy specific files extension to their respective folders

    googling indeed , I did not found similar examples

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,006

    Re: vba to copy specific files extension to their respective folders

    Paste the following macro to a Routine Module :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: vba to copy specific files extension to their respective folders

    thank you for help

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,006

    Re: vba to copy specific files extension to their respective folders

    You are welcome.

+ 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. Files to be moved respective folders
    By Jayakumar1313 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2016, 12:33 PM
  2. Replies: 0
    Last Post: 10-15-2014, 04:37 AM
  3. Use Excel VBA to Copy multiple files from different source folders to different folders
    By mm1234mail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2014, 01:17 PM
  4. VBA code that cut .pdf files and copy in respective folders
    By waqarqrl in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-07-2013, 04:46 AM
  5. Replies: 1
    Last Post: 09-12-2013, 09:23 PM
  6. Copy specific data from different range of files saved in different folders
    By phoenixwright in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 07:47 PM
  7. Create folders and move and copy files into that folders
    By vijaybharthi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-31-2010, 04:01 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