VB Code to perform copy and paste values n closed workbook

Hello:

Please refer to attached files.
I have lots of files in a folder C:\Temp\.
I need a vB Code to perform following task.
In each file in a folder, i need the code to copy and paste Values in sheet1 Range H10:Q40 (Currently this range has formulas).
Basically Copy Range (H10:Q40) and paste at cell H10 values only.

Then delete Sheet2, Sheet3 of the file.
Save the file by adding FINAL at the end of the file name.
So if the file name is 05_2015_Store1.xls then save it as 05_2015_Store1_FINAL.xls

Let me know if you have any questions.
Thanks.

Riz

Hi HahoBe:

Seems to work.
In the example i have uploaded has sheets 1,2 and 3.
However in my actual work sheet names for all files will be the same as DailyMain, DailySales, DailySummary.
Here need to delete DailySales and DailySummary and DailyMain will be the same as Sheet1 in teh above code.
Please help correct code above and let me know if any questions.
Also it would be nice to seperate out the _FINAL files in directory C:\Temp\Final\

Please let me know if you have any questions.
Thanks.

Riz

Hello HahoBe:

I got this part working.
I am working further and will contact you further for further help.
Once again thanks a lot.
Riz