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.
برچسب:
نویسنده: استخدام کار