| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
retrieve data from from a variable wrkbook
using an array of workbooks with cloned formats i need to open
workbook based upon a variable name in a cell in another workbook. ie get the value of cell bd27 in workbook "name found in cell a1 o current book -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
retrieve data from from a variable wrkbook
Workbooks(ActiveSheet.Range("A1").Value).Range("BD 27")Value
is what you want -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "bobbythefish " wrote in message ... using an array of workbooks with cloned formats i need to open a workbook based upon a variable name in a cell in another workbook. ie. get the value of cell bd27 in workbook "name found in cell a1 of current book" --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
retrieve data from from a variable wrkbook
please advise on exact syntax to place in cell thanks
bo -- Message posted from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
retrieve data from from a variable wrkbook
Bobby,
I think this is what you want Workbooks.Open ActiveSheet.Range("A1").Value MsgBox ActiveSheet.Range("A2").Value -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "bobbythefish " wrote in message ... please advise on exact syntax to place in cell thanks bob --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieve whole row of data | Excel Worksheet Functions | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| How to save a worksheet seperately in addition to part of wrkbook | Excel Discussion (Misc queries) | |||
| Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
| Retrieve data | Excel Discussion (Misc queries) | |||
Hybrid Mode
