I have a spreadsheet that has query tables looking at another workbook. How
do I get a value from a specific cell at the same time?
I don't know how to reference this book that is"already open". OK if it is
open, how do I pull a simple date?

Thanks!