Results 1 to 3 of 3

Thread: VBA Consolidate Multiple Workbooks In To One Single Workbook

  1. #1
    Junior Member
    Join Date
    Dec 2012
    Posts
    3
    Rep Power
    0

    VBA Consolidate Multiple Workbooks In To One Single Workbook

    I have a question about a macro that was posted in the 'Tips and Tricks' section.

    Consolidate multiple workbooks from a folder into one master file VBA

    First, I'd like to say THANK YOU to whomever wrote it, it works FANTASTIC!!

    I'd like to add something to this but don't know where to begin. My excel knowledge is high but VBA skills are nonexistent.

    First, I'd like to add a list of the files that have been consolidated. (I'd be placing this starting in cell K7) This will act as a check to make sure the right number have been consolidated.

    Second, I'd like to be able to start the "Select Source File Folder" in a default directory so you don't always have to browse that location (all the folders will be in one directory on our server).

    If this is possible I'd be extremely grateful!

    Thanks,
    Andrew

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Andrew, welcome to ExcelFox.

    The first one is rather straight forward

    Just add something like
    Code:
    .InitialFileName = "C:\"
    within the
    Code:
    With Application.FileDialog(4).... End With
    construct

    For the second one, so from K7, do you mean to add the names of the files that have been consolidated? which then leads to another question, if you start a new consolidation, all data from K7 to below will be cleared and started afresh...?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Dec 2012
    Posts
    3
    Rep Power
    0
    Thanks for the quick response!

    Yes I'd like the list of the files that were consolidated. The file name includes the users name that created the file, the list will allow a cross check incase someone didn't submit their report. If someone didn't do it they're tracked down, asked to submit their report and then the data will be reconsolidated, this updates the data and should update the list of files used for the consolidation.

    I'm on my iPhone right now, I can give full details tomorrow of what I'm doing if that'd help.

    Andrew

Similar Threads

  1. Replies: 4
    Last Post: 06-18-2013, 01:38 PM
  2. Replies: 1
    Last Post: 06-07-2013, 10:32 AM
  3. Replies: 1
    Last Post: 05-09-2013, 08:56 AM
  4. Consolidate multiple workbooks from a folder into one master file VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 02-26-2013, 09:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •