Best way to get data from a closed workbook

[rhombus4]

Usually use code in TestCopy but then recently saw testCopy, so was wondering which is the best way

Also in the first version if it contains a password you can use that in the code but wasn't sure how to use in the Get Object version

Sub testCopy()
Dim wb As Workbook

Application.DisplayAlerts = False

Set wb = Workbooks.Open("C:\MyDocs\Test.xls", Password:="myPassword", ReadOnly:=True)

wb.Sheets("Sheet2").Range("A2:F100").Copy
ThisWorkbook.Sheets("Sheet1").Range("A2").PasteSpecial xlAll

wb.Close False
Application.DisplayAlerts = True

End Sub

and

Sub testCopy2()
With GetObject("C:\MyDocs\Test.xls")
  .Sheets("Sheet2").Range("A2:F100").Copy ThisWorkbook.Sheets("Sheet1").Range("A2")
  .Close 0
End With

End Sub

 

[rhombus4]

But how do you get current region of closed workbook into a string using getdata?

 

[rhombus4]

But how do you get current region of closed workbook into a string using getdata?

Does anyone know how to get current region using get data instead of

.Sheets("Sheet2").Range("A2:F100").Copy ThisWorkbook.Sheets("Sheet1").Range("A2")

and also how to use if the workbook has password (password is myPassword)