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
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