Hi,

I have more than 500 excel files in one folder.
I need to copy the first sheet from each excel file (without formula, just the values) and put in another excel file separately and save with another name (ex. document.xls -> document_1.xls; document2.xls -> document2_1.xls).
So for each excel document I need a copy that contains only the first sheet without forumulas.
Can you give me some ideas how can I do this automatically, please?

Thanks