retrieve data from from a variable wrkbook

B

bobbythefish

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
 
B

Bob Phillips

Workbooks(ActiveSheet.Range("A1").Value).Range("BD27")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)
 
B

Bob Phillips

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)
 
Top