combine imported excel sheet

  • hai all,
    I have the code for selecting multiple text files into a single excel file with multiple sheets
    and i have code to combine multiple sheets into a single sheet


    i want these 2 code into a single one
    please help me how to do that[/CODE]