MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to merge workbooks

  Asked By: Jesse    Date: Dec 16    Category: MS Office    Views: 1502

Im having a hard time doing this. Does someone have a VBA code
for excel that can search for file names of workbooks that are similar
in one local folder and combine all of the searched workbooks found in
that folder into one single consolidated workbook? For example: in the
folder: "ExcelFILES" i have 3 files namely "emp_Names", "emp_Salary",
and "workload". In this case, the filter that I want to be using is
"emp_" and the code needs to be able to just select the two files
starting with "emp_" which are "emp_Names" and "emp_Salary", and
combine their contents into a single workbook, while disregarding the
"workload" excel file.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on How to merge workbooks Or get search suggestion and latest updates.