Data grabbing from another file

  • Using this code to grab data from another workbook and insert it into a worksheet. It works but it's pretty slow. Looking for a way to speed it up. Any help would be much appreciated, Thanks!




    Code
    1. Private Function GetData(path, File, Sheet, Address)
    2. Dim Data$
    3. Data = "'" & path & "[" & File & "]" & Sheet & "'!" & _
    4. Range(Address).Range("A1").Address(, , xlR1C1)
    5. GetData = ExecuteExcel4Macro(Data)
    6. End Function