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

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/

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

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/