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???

Please Login or Register  to view this content.

Good evening Sc0tt1e

There are several ways of doing this demonstrated at Erlandsen Data Consulting's pages.
http://www.erlandsendata.no/english/...adfromclosedwb

HTH

DominicB