C
carl
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
roject\market.xls
2.Prompt me to select a worksheet (they are named May 1, May 2, etc…)
3.After selecting the worksheet, email range A10100 to [email protected]
4.Close the workbook with no changes
Is this possible ? Thank you in advance.
After Excel is opened, run the code to do the following:
1.Open up the workbook j
roject\market.xls2.Prompt me to select a worksheet (they are named May 1, May 2, etc…)
3.After selecting the worksheet, email range A10
100 to [email protected]4.Close the workbook with no changes
Is this possible ? Thank you in advance.