+ Reply to Thread
Results 1 to 2 of 2

Batch File move files base on part of their name // VBA?

  1. #1
    Registered User
    Join Date
    03-15-2019
    Location
    sloveni
    MS-Off Ver
    2016
    Posts
    26

    Batch File move files base on part of their name // VBA?

    Is it possible for a bat file to move a file (.xlsx) to another folder whit only part of that name?
    Or it is possible to do with vba??

    For example:

    file name to move (.xlsx)
    #Import#0181004401#0000015227_BEI_1300090026_20211206210105
    #Import#0181004482#0000015402_BEI_1300090389_20211208210239
    ...
    --------------

    The files where I want to move the files:
    353556_Lidl_0181004401
    374684_Lidl_0181004482

    ........

    #Import#0181004401#0000015227_BEI_1300090026_20211206210105.xlsx ---> 353556_Lidl_0181004401
    #Import#0181004482#0000015402_BEI_1300090389_20211208210239.xlsx ---> 374684_Lidl_0181004482



    tnx!
    Last edited by pernekde; 12-22-2021 at 03:45 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,110

    Re: Batch File move files base on part of their name // VBA?

    I see that this thread is marked as SOLVED. Did you in fact solve this (if so, care to share the solution?) If not, do you need it to return to UNSOLVED status?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 7
    Last Post: 01-25-2021, 06:01 PM
  2. Replies: 6
    Last Post: 09-16-2019, 11:53 AM
  3. Inputting single file information instead of batch files
    By Fusion187 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-07-2017, 11:17 AM
  4. Batch to copy file using part of file of name
    By ashokunbi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2013, 06:07 PM
  5. Rename Excel files on base of current file name
    By ali84pk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2010, 08:46 AM
  6. search part of file name and move file to folder
    By James580 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-15-2008, 01:56 PM
  7. Batch file to start multiple excel files with auto_open() macro. Delay code needed
    By pierrelap@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-29-2005, 02:05 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