+ Reply to Thread
Results 1 to 3 of 3

Use a userform to file files into preexisting folders

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Use a userform to file files into preexisting folders

    Is there a way to set up a userform that functions as such:

    Select a folder housing several photos with file names including numbers. i.e #1Photo
    Select a folder that houses pre-existing subfolders with names such as "1_TextTweet", "2_TextInsta", "3_TextTweet", etc.
    Have the photos from selection 1 file into the corresponding numbered folder from selection 2? i.e: #1Photo would file into 1_TextTweet

    Does that make sense?


    Thank you!!!

  2. #2
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Re: Use a userform to file files into preexisting folders

    So, I've done some more digging and testing and I think I have the first steps. I have code to find the first path (where the photos are housed) and paste it to a text box, then find the second path (where the folders where the photos need to be sorted into are located) and paste into a second text box. Now I think I need to figure out the code to get the 2 paths to work together: #1Photo to file into folder with a 1 in it.

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

  3. #3
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Re: Use a userform to file files into preexisting folders

    Anything? I don't necessarily need to use a userform, I would just prefer it. Thanks!

+ 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. Copy Files from one folder to different folders based on pdf file name
    By jtammyg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2014, 11:49 AM
  2. Copy Files to Folders Based on Specified File Names and Directories.
    By mamero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2013, 12:08 PM
  3. Replies: 1
    Last Post: 09-12-2013, 09:23 PM
  4. Move selected files to folders the correspond to file names
    By autbadass in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2013, 09:59 PM
  5. Replies: 2
    Last Post: 01-04-2013, 07:22 AM

Tags for this Thread

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