Private Sub CommandButton1_Click()
Dim strTargetFile As String
Dim wb As Workbook

     Application.ScreenUpdating = False
     Application.DisplayAlerts = False
     strTargetFile = Cells(2, 1)
     Set wb = Workbooks.OpenXML(Filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList)
     Application.DisplayAlerts = True

     wb.Sheets(1).UsedRange.Copy ThisWorkbook.Sheets("Sheet1").Range("A5")
     wb.Close False
     Application.ScreenUpdating = True
     
End Sub

www.KMtronic.com/Software/Temperature/KMtronic-LAN-Temperature-Excel-Example-01.zip