in reply to xlsmerge - Merge worksheets from different Excel files into one Workbook

You know, if you open two workbooks in Excel and right-click on the sheet selection tab, you get a shortcut menu with a "Move/copy sheet..." entry that lets you copy sheets even among workbooks. What advantage does this script have over that method?

  • Comment on Re: xlsmerge - Merge worksheets from different Excel files into one Workbook

Replies are listed 'Best First'.
Re^2: xlsmerge - Merge worksheets from different Excel files into one Workbook
by Corion (Patriarch) on Jun 15, 2010 at 13:05 UTC

    The advantage of all my scripts. I don't have to do menial tasks manually, like merging boilerplate sheets into other workbooks before mailing them.