Exporting Worksheets as xlsm with Values not Formulas

I am using an export code to take my worksheets to a destined folder in xlsm format. I am looking to adjust this formula so when the worksheets are exported it is a flat file that just contains the values in the cells NOT the formulas.

Please Login or Register  to view this content.

Thanks guys

I keep getting a compile error expecting End Sub with the one above^^

Thanks dep