Excel VBA - save worksheet to new file without formulas

Need some assistance to complete this VBA code, I've taken it as far as my limited knowledge will get me.

Scenario: I have a master workbook which pulls in data from two other spreadsheets exported from a program (to save copy/pasting), I then need to export only 1 sheet and save as a new file and the VBA code below does the job perfectly.

Sub savesheet2()

Application.ScreenUpdating = False
ActiveSheet.Select
ActiveSheet.Copy
ThisFile = Range("A2").Text
Dim fileName As String
fileName = "C:INTERNALACCOUNTS" & ThisFile
ActiveSheet.SaveAs fileName:=fileName, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Application.ScreenUpdating = True

End Sub

What I need to include is coding to remove the formulas (export values only) and retain conditional formating from the masterwork book.

Any assistance would be greatly appreciated.

Recent Questions...