I want to build a simple app, text box and command button to open a excel file with a specific worksheet. lets say i have 20 excel files with 20 worksheets each all with various names, I'm trying to make it so i can enter the worksheet name in my text box click the command button and have vb go find the worksheet and open the file, to that worksheet. any help or code would be greatly appreciated. Thanks!!!