I would like to use VBA to do the following:



After Excel is opened, run the code 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.