title: Duplicate workbook and execute macro in that file
body: <p>I would like to create a VBA code that copies the workbook in a separate workbook (workbook2) and converts in that second workbook all the formulas to values, the coversion should not be done in workbook 1 (the active one). I found a code that does the conversion but I don't know how to make it execute it in workbook 2. Then I should save this workbook 2. Any Ideas? Below the code</p>
  
  <pre><code>Sub ConvertFormulasToValuesAllWorksheets()
  On Error Resume Next
      Dim ws As Worksheet, rng As Range
  
  
  
      For Each ws In ActiveWorkbook.Worksheets
  
      For Each rng In ws.UsedRange
  
          If rng.HasFormula Then
  
              rng.Formula = rng.Value
  
          End If
  
      Next rng
  
      Next ws
  
      ActiveWorkbook.SaveAs Filename:= _
      "C:\Users\myusid\Desktop\myfolder\workbook2.xlsx" _
       , FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False ' need to 
       change the name of the folder
       Application.DisplayAlerts = True
  
  
        On Error GoTo 0
        End Sub
  </code></pre>
  
  <p>Thanks.</p>