List box to open file

[lca]

I am very new with HTML and PHP and the code below I have a drop down select box and a submit button which uses PHP (this is from an example) But I need help on how to allow the user to select a report name from the drop down and click the Submit button and open a excel spreadsheet.

 

If "Position" is selected user clicks Submit button and the Excel file opens.  First of all is that possible?  And second then how do I accomplish?  Thanks in advance.

 

 

</body>

</html>

<ol>

<form method="post" action="yourscript.php">

<select name="Reports">

<option value="Positions">Position

<option value="Employees">Employees

<option value="Transfers" selected>Transfers

</select>

</form>

<td> </td>

<td><input type="submit" value="Submit"></td>

</tr>

</form>

</table>

 

</form>