Report question

Question: How do I reference to another (open or closed) workbook, and pull values back, in VBA? - Excel 2007