Application.ScreenUpdating = False
Workbooks.Open Filename:="c:\Test\BD.xlsx"
i = 1
j = 1
With ActiveWorkbook.Sheets(1)
Do While .Cells(i, 3) <> ""
i = i + 1
Loop
Do While .Cells(j, 7) <> ""
j = j + 1
Loop
ThisWorkbook.Sheets(1).Cells(1) = .Cells(i - 1, 3)
ThisWorkbook.Sheets(1).Cells(2) = .Cells(j - 1, 7)
End With
ActiveWorkbook.Close False
Application.ScreenUpdating = True