locked
macro Copy a specific worksheet from multiple workbooks in a folder without opening the workbook RRS feed

  • Question

  • Hello Everyone.

    I am new to vba , my issue  I have a folder on drive C:\ BACKFILES2018 in which there are different excel files with extensions xls,xlsx, xlsm.

    Note that these workbooks have also other sheets in it,my  goal is to copy all sheets with the name of  Infos_Container  from these workbooks to a new workbook.

    Attached testfile and expected results for one file only as all the Infos_Container has same format data

     Row 1 and 2 can be deleted  as well as  column A  as  removing filter.

    If the output results can be merged as one sheet for data analysis is also welcome  or merge all the sheets Infos_Container in one workbook

    Can anyone assist .

    thank you

     Searching on the web have given me the  closest similar answers of what I was looking for

    https://stackoverflow.com/questions/43601085/copy-a-specific-worksheet-from-multiple-workbooks-without-openeing-the-workbook


    https://drive.google.com/file/d/1Re86oqHxI6TVLJqeWlcbc3em3S4iqUZn/view?usp=sharing
    https://drive.google.com/file/d/1e33ugk0ikfvVkIzPG3mcxBlv0EBefKZS/view?usp=sharing



    Sunday, January 6, 2019 7:38 AM

All replies