Results 1 to 2 of 2

Thread: Consolidate Multiple work sheets and save into a specified file

  1. #1
    Junior Member
    Join Date
    Mar 2013
    Posts
    1
    Rep Power
    0

    Lightbulb Consolidate Multiple work sheets and save into a specified file

    Hi am a new to this forum and have a question on a VBA code. I must inform you all that I am also new, but I am needing to consolidate all workbooks in a file to one spreadsheet. I did refer to http://www.excelfox.com/forum/f13/co...-file-vba-569/ and removed the prompt so that the directory would be found without the message box. For some reason when I run the macro the files are consolidated into my PERSONAL.XSLB file rather than to another active work book

    1. How do I avoid this? What part of the code to I need to change?
    2. How could I get this to be saved into a file template that I have already created, but not complete a "save-as" which I have tried, but this ends up closing my personal macro work book and then I cannot run any other macros without reopening the macro file.

    I hope this makes sense.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Just change
    Code:
    Set wbkActive = ThisWorkbook
    to
    Code:
    Set wbkActive = ActiveWorkbook
    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

Similar Threads

  1. Replies: 1
    Last Post: 06-07-2013, 10:32 AM
  2. 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
  3. Replies: 2
    Last Post: 12-19-2012, 08:28 AM
  4. Copy Sheets To New Workbook And Save
    By Prabhu in forum Excel Help
    Replies: 5
    Last Post: 09-06-2011, 09:35 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
  •