in reply to Re^3: Merging worksheets in .xls in one Excel sheet
in thread Merging worksheets in .xls in one Excel sheet

Hi Thanks for your code but here the requirement is not to create different sheets in target sheet we need to place all the data in one sheet which all the aother .xlsx files have.
  • Comment on Re^4: Merging worksheets in .xls in one Excel sheet

Replies are listed 'Best First'.
Re^5: Merging worksheets in .xls in one Excel sheet
by poj (Abbot) on Sep 20, 2017 at 15:36 UTC

    Does that mean that each of the different sheets uses a different range of cells ?