VBA for opening a file from the filename in a cell

[csilabgirl]

Excel 2002

I would like the user to be able to enter a file name into a cell (A1) and then click a button and it will open that file

The file name in this example is M060311 and I have it in cell A1.

In cell A17 I am using formulas to decipher the file name for its location on the server. So in cell A17 I have the file path:

\\Server\chromosomal labs\Integrated Sample Processing System (I-SPS)\Run Files\Minifiler\2011\Jun\M060311

What do I need to write into my VBA code to open this workbook?

Thank you for your help!

 

[Trevor G]

Refer to the cell but you will need to add the extension. Something like this

Workbooks.open range("a17").value & ".xls"

 

[csilabgirl]

AHH, the extension, forgot that. Thank you that worked