Copy Data from Closed workbook (bbb.xls) to Open workbook (aaa.xls) (Part 2)

[alexnkc]

Hi,

With code below, it enable me to copy data from bbb.xls (to aaa.xls) without opening it.

Sub GetDataFrombbb()
    Range("F4").Formula = "='" & ThisWorkbook.Path & "\[bbb.xls]Sheet1'!$N$11"
    Range("F4").Value = Range("F4").Value
End Sub

How to upgrade the VBA code above so that it able to choose updated data (select $N$11 then perform Ctrl + down and copy)?

Previous Posting link:
http://www.excelforum.com/excel-prog...k-aaa-xls.html