open folder and execute code for xls files except 1 file

Hi All,

I have a folder that contains many xlsx files
in this folder there is an Excel workbook with name Host.xlsx

This excel workbook has a button that contains my macro. ok ? you are with me ..?

What I want is

when I press this button in host.xlsx file
it opens all excel workbooks in that folder and execute my macro code then open next workbook and execute my macro and so on......

You will find 3 files ( host sheet, sheet1 and sheet2 )
when I press fill in button in host sheet:

it will copy the data from sheet1 in tab inv_oracle and paste it into host sheet in tab host
and then copy the data from sheet2 in tab inv_oracle and paste it into host sheet in tab host after the last record inserted before


- macro scenario is to copy data from these workbooks -with specific sheet inv_oracle - and paste it into host.xlsx -
Kindly check the attached file ,tab to be like this to understand my point of view

my code is working but in the same excel workbook I don't know how to amend it to work for mutiple files

Thanks for your help
Regards

Hi,

I have encountered this issue

Regards

find attached picture
Thanks

Thanks a lot man
It works
I don't know how to thanks you