You have to open the workbook to do that, but VBA can handle all that as long as you identify the target sheet properly, too.
Option Explicit
Sub ImportDataWithFormulas()
Dim wsDEST As Worksheet, wbDATA As Workbook
Set wsDEST = ActiveWorkbook.Sheets("Sheet1")
Application.ScreenUpdating = False
On Error Resume Next
Set wbDATA = Workbooks.Open(" C:\Users\Kevin\Google Drive\Work\formula.xlsm")
If wbDATA Is Nothing Then
MsgBox "The Formula.xlsm workbooks was not found."
Application.ScreenUpdating = True
Exit Sub
End If
wbDATA.Sheets("MyFormulaSheet").Range("A1:Z10").Copy wsDEST.Range("A1")
wbDATA.Close False
Application.ScreenUpdating = True
End Sub
Bookmarks