I need another way of updating and reading a closed workbook

I am currently using the below code to open, update (or read) data to/from a closed spreadsheet. Even with the screen updating set to false I still see the document opening and closing, it is also taking quite some time to open the document.

Is there another way of connecting to the document without having to open and close it???

' Sheets("Sheet1").Range("B42").Value = C:\Users\Scott\Documents\CMC\Database.xlsm				

DataBPath = Sheets("Sheet1").Range("B42").Value
Set wbdbb = Workbooks.Open(DataBPath)
Set HR1 = wbdbb.Worksheets("HR")