How to get the value of one cell in a worksheet

[asmith555]

I am new with excel vba. I am trying to get the value of a single cell in a specific worksheet. Also I am trying to dynamically open another workbook. Get a value from a single cell and close the workbook. Can anyone give me a heads up on how to do this.

 

[PHV]

Something like this ?
Dim WB As Workbook
Set WB = Workbooks.Open("\path\to\file.xls")
MsgBox "Cell value = " & WB.Sheets("sheet's name").Range("A1").Value
WB.Close False
Set WB = Nothing

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886