I would like to use a macro to do the following:

After Excel is opened, run the macro to do the following:

1.Open up the workbook j:project\market.xls
2.Prompt me to select a worksheet (they are named May 1, May 2, etc€¦)
3.After selecting the worksheet, email range A10:D100 to
4.Close the workbook with no changes


Is this possible ? Thank you in advance