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