+ Reply to Thread
Results 1 to 3 of 3

Copy and creating a Folder for a certain file

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    nashville, tn.
    MS-Off Ver
    Excel 2013
    Posts
    13

    Copy and creating a Folder for a certain file

    Hello, quick praise and then my question.

    Below is code I got help on that works great. It allowed me to change over

    10,000 folder names from what they were to what they uniquely needed to be.

    AlphaFrog helped me and I wanted to say thanks again.


    Please Login or Register  to view this content.
    My next task is more complicated:

    I have to search each folder and copy anywhere from zero (if the file is

    not in that folder) to 10 or more unique files. The copied files need to be

    put in a folder using mkdir that has the same name as the folder they where

    found in.

    My first step is to create a master directory for all the subfolders to be

    placed in.

    What I am wondering is: using the above code how do I change the

    Please Login or Register  to view this content.
    to also loop thru the subfolders.

    Any help would be great.

    Thanks
    Joe

  2. #2
    Forum Contributor
    Join Date
    10-08-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    386

    Re: Copy and creating a Folder for a certain file

    This will cycle through all sub folders and files in the directory assigned to fldrStart. If you want to go as deep as you can you would need to make this a function that calls itself until it runs out of folders.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-02-2013
    Location
    nashville, tn.
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Copy and creating a Folder for a certain file

    Thanks for the response GaidenFocus:

    Your code is Object which is even more difficult for me to understand.

    I did find this code that I think I can modify to work for looping thru the files in the subfolders.

    Please Login or Register  to view this content.
    I need to keep working on it but for now I think the subfolders will loop thru using the above code.

    Thanks again

    Joe

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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