| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
retrieving cell value from a query linked workbook
It should be:
Range("MyLocalRange").Value = Workbooks("MyRemoteWorkbookName").Range("RemoteRan ge").Value |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linked workbook cell returns 0 is source workbook cell is blank? | Excel Worksheet Functions | |||
| Retrieving linked label formula with VBA | Charts and Charting in Excel | |||
| Query linked cell values | Excel Worksheet Functions | |||
| Retrieving cell formatting from closed workbook | Excel Programming | |||
| Retrieving cell formatting from closed workbook | Excel Programming | |||
Linear Mode
