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

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