Find and use data from another workbook?

[proepert]

I have two example workbooks to help illustrate my question. Open the workbook called get_status.xls then run the user form. Enter 123456 into the textbox then click the Get Status button.

I want to get info about the item from the workbook called object_status.xls which is on a network drive (known location) and is not open. Do I have to open this workbook to look for data in it?

So I have to find the matching text string, then get the value of the adjacent cell. If the text string is found in cell B5, then return the value from C5. Always look in the B column for the matching string.

After the info is found, close object_status.xls and write the value to the label in the user form (lblResults) in the get_status.xls workbook.

If 123456 does not exist in the object_status.xls workbook, then return "Unknown" to the user form.

I can code enough to open the other workbook, thats all. Thanks for any help you can provide.

Excel 2000, 30 inches of fresh snow