Excel to open file, copy paste as values and save as excel

**Adelin** · 05-08-2017, 11:27 AM

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

**arlu1201** · 05-08-2017, 11:30 AM

Hello Adelin,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

**Doc.AElstein** · 05-10-2017, 06:18 AM

Hi Adelin

Welcome to Excel Forum

This is just the Sub Forum to say hello

Start here, https://www.excelforum.com/ , then look for an appropriate Sub Forum to post your question in:
You must start a new Thread here if you need help:
http://www.excelforum.com/excel-general/
or here:
http://www.excelforum.com/excel-formulas-and-functions/
or if you would consider a macro solution then here:
http://www.excelforum.com/excel-programming-vba-macros/

If you are not sure, then probably the first will do
http://www.excelforum.com/excel-general/

_............................................

Please, also, if you get time, take some time before posting to read the Forum Rules here
http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/forums-rules/
http://www.excelforum.com/developmen...ml#post4606484
It is usually worth it in the long run.

Thanks
Alan