Macro to copy and paste files files as value

Hi ,

I have couple of files in a folder each file contains only one sheet . I am looking for a macro which will open each file and copy paste data as values then save and close file.

Thank you

Let try this code:

Please Login or Register  to view this content.

assume that you have all your workbook in drive "D", once you run the code it will ask you to select a folder that contain all workbooks you want to copy and paste value. Once you select a folders all workbooks in that folder will be open, copy paste value, close and save.

remember that make sure only workbooks that you want to paste value that you can keep in that folder, and please do not include other than workbook because it can generate error.

please let me know if it doesn't work with you.

Thank you for the code ... it is opening file copying data but not pasting as values .
Opens ,copies data and save file.

Hi ,

Its not saving file ...

hi Sharadharani, sorry for late to reply you because i was busy and get no time to come here. Actually i confused to say false and it is suppose to say true here:

Please Login or Register  to view this content.

Thank you So much Kroko ... Its working perfect now