Scribd Logo
Upload

Welcome to Scribd!

  • 34 views

    Merge Excel Files

    Uploaded by

    jonnie myers
    This document provides a VBA macro code to merge multiple Excel files into one file. The macro allows the user to select multiple workbooks using a file dialog box. It then loops through each selected file, opens it, copies all worksheets to the end of the main workbook, and closes the source workbook. Once complete, all worksheets from the selected files are combined into a single main workbook file.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Merge Excel Files

    Uploaded by

    jonnie myers
    34 views2 pages
    This document provides a VBA macro code to merge multiple Excel files into one file. The macro allows the user to select multiple workbooks using a file dialog box. It then loops through each selected file, opens it, copies all worksheets to the end of the main workbook, and closes the source workbook. Once complete, all worksheets from the selected files are combined into a single main workbook file.

    Original Description:

    xcel

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a VBA macro code to merge multiple Excel files into one file. The macro allows the user to select multiple workbooks using a file dialog box. It then loops through each selected file, opens it, copies all worksheets to the end of the main workbook, and closes the source workbook. Once complete, all worksheets from the selected files are combined into a single main workbook file.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    34 views2 pages

    Merge Excel Files

    Uploaded by

    jonnie myers
    This document provides a VBA macro code to merge multiple Excel files into one file. The macro allows the user to select multiple workbooks using a file dialog box. It then loops through each selected file, opens it, copies all worksheets to the end of the main workbook, and closes the source workbook. Once complete, all worksheets from the selected files are combined into a single main workbook file.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    Merge Excel Files: How to Combine Workbooks into One File

    Merge files with a simple VBA macro

    Copy and paste the following code into the new VBA module. Position the cursor within the code and click start (the green triangle) on the top. That’s it!

    Sub mergeFiles()

    'Merges all files in a folder to a main file.

    'Define variables:

    Dim numberOfFilesChosen, i As Integer

    Dim tempFileDialog As fileDialog

    Dim mainWorkbook, sourceWorkbook As Workbook

    Dim tempWorkSheet As Worksheet

    Set mainWorkbook = Application.ActiveWorkbook

    Set tempFileDialog = Application.fileDialog(msoFileDialogFilePicker)

    'Allow the user to select multiple workbooks

    tempFileDialog.AllowMultiSelect = True

    numberOfFilesChosen = tempFileDialog.Show

    'Loop through all selected workbooks

    For i = 1 To tempFileDialog.SelectedItems.Count

    'Open each workbook

    Workbooks.Open tempFileDialog.SelectedItems(i)

    Set sourceWorkbook = ActiveWorkbook

    'Copy each worksheet to the end of the main workbook

    For Each tempWorkSheet In sourceWorkbook.Worksheets

    tempWorkSheet.Copy after:=mainWorkbook.Sheets(mainWorkbook.Worksheets.Count)

    Next tempWorkSheet

    'Close the source workbook

    sourceWorkbook.Close

    Next i

    End Sub

    You might also like