Results 1 to 4 of 4

macro to copy workbooks from Folder into the appropriate sub-folder

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,776

    macro to copy workbooks from Folder into the appropriate sub-folder

    i have workbook where I list the workbook, Folder and sub-folders

    I would like a macro to copy the workbooks from the specified folder into the appropriate sub-folder.

    I there is no workbook , the it will be indicated in Workookm as yes or No to copy

    It would be appreciated if someone can provide me with the code to do this
    Last edited by Howardc1001; 07-12-2021 at 11:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Merging all workbooks in folder and moving to sub folder
    By TFlemingX in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2019, 05:23 PM
  2. [SOLVED] Copy Range from multiple Workbooks in folder, to Summary Workbook also in same folder?
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-24-2018, 01:22 PM
  3. Linking Two Workbooks in the Same Folder and Excluding the Folder Location
    By 96Mustang460cid in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-29-2017, 02:27 AM
  4. [SOLVED] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2013, 07:59 PM
  5. create a compressed folder or zipped folder then copy workbooks to it.
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2012, 03:56 PM
  6. copy all workbooks in a folder to a different workbook
    By prajesh in forum Excel General
    Replies: 6
    Last Post: 11-22-2011, 01:35 AM
  7. [SOLVED] Copy a cell to all workbooks within a folder.
    By Andy T in forum Excel General
    Replies: 16
    Last Post: 02-02-2005, 08:06 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