+ Reply to Thread
Results 1 to 4 of 4

Extract Data From Multiple Files

  1. #1
    Registered User
    Join Date
    05-26-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    50

    Extract Data From Multiple Files

    Hi Everyone, I'm trying to extract data from tens of files at once and depending on the file name it should carry out a specific action, i.e. copy specific cells to the master file, or simply ignore the file, and go to the next.
    To clarify things a little bit, 'Data' tab is in the master file and all of the extracted data should be pasted one under another there, but at the moment it doesn't even recognise the file names for some reason, and just skips to the empty msg box. Not sure why that is and would greatly appreciate any help with getting this macro to work.

    Please Login or Register  to view this content.
    Many thanks!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,875

    Re: Extract Data From Multiple Files

    Can you show a clip of what the files look like in explorer.

    Just a note as well: "*Test*"="*Test2*"

    I wanted to see if you could use mid(),left() or right()

  3. #3
    Registered User
    Join Date
    05-26-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    50

    Re: Extract Data From Multiple Files

    Sorry with the 'Test' thing- that was obviously a mistake when trying to create an example. As for the folder with files, it's just a bunch of xls, xlsx & csv files and left/right/mid are more than fine to use based on the names. Thanks!

  4. #4
    Registered User
    Join Date
    05-26-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    50

    Re: Extract Data From Multiple Files

    @Refresh

    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. Macro extract data from multiple files
    By cjs578 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2019, 10:33 AM
  2. [SOLVED] Extract data from multiple external excel files
    By rxk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-03-2016, 11:06 PM
  3. Extract data from Multiple excel files
    By rajani85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2015, 02:48 PM
  4. Extract Data from Multiple Closed Excel Files
    By Gittelman in forum Excel General
    Replies: 2
    Last Post: 07-29-2014, 12:09 AM
  5. Use VBA to extract data from multiple files
    By JCHC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-19-2013, 12:03 PM
  6. [SOLVED] Extract Data From Multiple Excel Files -> One File
    By Michael via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2012, 01:02 PM

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