+ Reply to Thread
Results 1 to 3 of 3

Macro to pull data from files in the folder with skipping processed ones when using again

  1. #1
    Registered User
    Join Date
    11-07-2016
    Location
    Poland
    MS-Off Ver
    2010
    Posts
    3

    Macro to pull data from files in the folder with skipping processed ones when using again

    Hi all,

    I adjusted the code I found on the Internet to pull data from the files in the folder and put them in one master sheet.

    However, the numer of files will grow very quickly every week, so for that reason I would like to implement in the code that macro will skip the files that were already processed. I would like to do it by the looking up the file name in the master sheet (column U).

    Please find the code below:

    Please Login or Register  to view this content.
    I tried to make it by If and GoTo statement but I have very little knowledge in VBA and I have no idea how to actually formulate it skip files which names are already in master sheet.

    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,060

    Re: Macro to pull data from files in the folder with skipping processed ones when using ag

    You can check the list of files in column U for the file name - code below - or you could just move the files out of the folder after you run the macro, into a folder named "Processed" or some other variation.

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,534

    Re: Macro to pull data from files in the folder with skipping processed ones when using ag

    Add this to the Do-Loop (not tested)

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. [SOLVED] List all .xl* files in folder then pull value from cells of each
    By NMullis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2016, 06:20 PM
  2. [SOLVED] Looking for Macro to pull folder name and folder size of a specific location.
    By TheDirtyDrunk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2016, 09:19 AM
  3. Pull data from csv files added into a network folder
    By aaron_burr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-23-2014, 11:42 AM
  4. i need a macro to pull excel files from a folder and print them
    By kmraz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2013, 06:53 PM
  5. [SOLVED] Macro to pull in files from folder that is unknown
    By SeaniGeld in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2013, 02:23 PM
  6. [SOLVED] Excel macro to pull retrieve data from multiple workbooks in a folder
    By tech_frk in forum Excel Programming / VBA / Macros
    Replies: 39
    Last Post: 03-07-2013, 08:04 PM
  7. Macro to Vlookup and pull data from standard workbooks of a folder to a target one
    By Silver.blue in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2011, 05:38 PM

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