VBA to paste special all Excel workbooks in a folder to another folder in the same path

[kishorenaidugurram]

Hi Members,

I have five excel workbooks in a folder that contain formulas in it and need to paste special these workbooks as values into another folder. Appreciate if i can get the VBA code for this.

thanks