retrieving cell value from a query linked workbook
 

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!

retrieving cell value from a query linked workbook
 

It should be:

Range("MyLocalRange").Value =
Workbooks("MyRemoteWorkbookName").Range("RemoteRan ge").Value

retrieving cell value from a query linked workbook
 

Have not thought of that.
Thanks!

"Greg Glynn" wrote:

Correction:


Range("MyLocalRange").Value =
Workbooks("MyRemoteWorkbookName").Sheets("RemoteSh eetName").Range("RemoteRange").Value