Best way to access data from another excel workbook

Best way to access data from another excel workbook

What would be the best way to get read-only access to data stored in another excel workbook. There are two posibilities that I'm aware of, each with their pros and cons.