How to use macro to run excel, word, powerpoint, outlook, IE, etc?
 

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