I have two workbooks. (i.e., "Workbook_Closed" and "Workbook_Open"). I would like to put code in Workbook_Open that will import cells "C2:AA120200" from "Sheet1" of "Workbook_Closed". What is the VBA code to do this for ADO, DAO and RDO. Also which one of these data accesses interfaces is the fastest, most stable and which one would you recommend and why for this process?
You all probably know all about each, but below is a link describing them: