Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use macro?
Hi All,
I have some work that need to be done on every Thursday so I am thinking if it is possible to write a macro to do all these things automatically. Below is what I need to do: 1. I will receive an email with a particular title "test" on every thur morning 2. there is an attachment with this email (a zipped excel file) 3. save and unzip on desktop 4. open the excel file and do some data analysis (calculation, pivot table and graphs, etc 5. copy the graphs to a powerpoint file 6. zip the file and email to a group of people (using outlook) I would like to ask: 1. the only way I know to write a macro is using the "record a new macro" function in excel. Is there any other way to do that? 2. How to save the macro as a separate file? It is because everytime after recording a macro, I can only save it within the excel file. 3. how to use macro to operate excel, word, powerpoint, outlook, IE? 4. can I write a macro to search for an email with a particular subject in outlook? 5. Besides this newgroup, can anyone give me some great website which provides very practical tutorials in using macro? I am not an expert in using macro. I know that there are a lot of questions and I would greatly appreciate for your help. Cheers, Jackie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |