| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To Automate File Retrieval and Email
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Retrieval | Excel Discussion (Misc queries) | |||
| How to automate with macro multiworksheet File using array variable? | Excel Programming | |||
| automate data retrieval from folder | Excel Programming | |||
| file retrieval | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Threaded Mode
