hey folks,

here's the deal. i need a macro that can sit on a sheet in a master
workbook and when i type a number (a filename) into a cell, lets say
cell D3, and then press enter, i need this macro to automatically open
the file i just typed. for instance, if i type in "406" into the cell
D3. when i press enter i want file 406.xls to open and minimize (so
that i can have access to information in that workbook).

thanks