retrieve data from from a variable wrkbook

  • Thread starter Thread starter bobbythefish
  • Start date Start date
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
 
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)
 
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)
 
Back
Top