Workbooks.Open(Workbooks("2ndWorkbook.xls").Sheets ("Sheet1").Range("A1").Value)

will open the workbook which is sitting in A1 of Sheet1 of workbook named
2ndWorkbook.xls
HTH

"douglass" wrote in message
...
new to VBA.

trying to come up with a line of code that will open a specific worksheet
based on value in cell in another workbook. both workbooks are open.
--
douglass