+ Reply to Thread
Results 1 to 5 of 5

Script to have a .TXT file or .CSV file find files in a specific folder?

  1. #1
    Registered User
    Join Date
    10-13-2014
    Location
    treatises csecogy
    MS-Off Ver
    2010
    Posts
    4

    Script to have a .TXT file or .CSV file find files in a specific folder?

    I have a list of cells in a .CSV or .TXT file (NAME: "EXAMPLE.FILE" that contain file names (roughly 4-6K).

    I then have a folder (NAME: "EXAMPLE.FOLDER") on my computer that contains roughly 40K items (upwards to nearly 50K).

    The "EXAMPLE.FILE" needs to CALL upon the "EXAMPLE.FOLDER" and place those files from the "EXAMPLE.FILE" into ANOTHER folder (NAME:"EXAMPLE.FOLDER.2").

    So, to sum:

    "EXAMPLE.FILE" contains:
    48993-dfhdn.JPG
    dnunb-sss.JPG
    222ffn-8.JPG

    "EXAMPLE.FOLDER" contains:
    1.JPG
    48993-dfhdn.JPG<<<
    yyyyyy-1.JPG
    dnunb-sss.JPG<<<
    hghhhh-9.JPG
    ppp-9.JPG
    222ffn-8.JPG<<<

    Those with the aforesaid "<<<" need to then be placed "EXAMPLE.FOLDER.2"

    Not sure if Excel or another program can do this. I would prefer a FREE program.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Script to have a .TXT file or .CSV file find files in a specific folder?

    Hi Paugel.

    Welcome to the Forum!

    Anything you post here is free of charge, should you want to pay we have a Commercial Services Forum
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    10-13-2014
    Location
    treatises csecogy
    MS-Off Ver
    2010
    Posts
    4

    Re: Script to have a .TXT file or .CSV file find files in a specific folder?

    Thanks for the reply.

    Any one interested in helping me with this problem? Maybe I am over-thinking this, perhaps?

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Script to have a .TXT file or .CSV file find files in a specific folder?

    Something Like:

    Please Login or Register  to view this content.
    ??
    Last edited by xladept; 10-16-2014 at 07:32 PM.

  5. #5
    Registered User
    Join Date
    10-13-2014
    Location
    treatises csecogy
    MS-Off Ver
    2010
    Posts
    4

    Re: Script to have a .TXT file or .CSV file find files in a specific folder?

    Ha! I apologize, I really do. It is one of those questions where you know what you mean, but you just don't know how to explain it thoroughly!

    My apologies.

    Quote Originally Posted by xladept View Post
    Something Like:

    Please Login or Register  to view this content.
    ??

+ 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. VBA to search files within a folder for a specific string and return file name
    By tjej6987 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2014, 12:41 PM
  2. Import TXT files from a specific folder into Excel - TXT file names change hourly
    By jeepinjeff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2013, 04:08 AM
  3. [SOLVED] macro to save file to specific folder with file name from cell reference
    By mezza89 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2013, 11:32 AM
  4. Macro for copying specific data from excel files in a folder to a newly created excel file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2012, 02:24 PM
  5. Replies: 0
    Last Post: 04-16-2012, 10:57 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