VBA Macro to Copy/Paste as values

[draycut]

Hi Excel Gurus

I have googled this, but I can't seem to find what I am looking for.

I want a VBA macro that takes all the xlsx files in a directory, opens, copies and pastes the content as values and closes again.

Any ideas?

Thank you in advance