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

[karan]

Put this code in the Submit Button Click event:

Please Login or Register  to view this content.

Refer the attached file. Don't forget to change the path of the file to the path on your computer.

Let me know if it worked for you.

Regards,
Karan

[proepert]

Yes that works perfect. Thank you very much.