Copy paste as values a specific tabs for a list of excel

[onche414]

Hello,

I am new to vba and trying to learn the basics but I have no idea how to perform that task.
I would like to have a code which will open all the excel files in a specific folder and copy paste as values the whole first worksheet of each file and then save the files and close them

Could you please help me ?

Thank you in advance,
Kind regards

 

[mumps]

What is the full path of the folder where the files are saved? What is the extension of the files (xlsx, xlsm)?