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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use macro?
Hi,
The main way of writing macros is not using the macro recorder, but writing them directly in the macro editor. The macro recorder can only generate very simple macros and its code is usually not very good. Most people use the recorder only as a quick way to recall or learn how to write a certain action in VBA code. But if you have never programmed before, it will prove very difficult to write your own macros. To access the editor go to Tools Macros Visual Basic Editor. From the editor you will also be able to export (save) the macros independently from the Excel sheet. To do so click on File Export File. The code will be saved as a file with .bas extension, which is the visual basic source code extension. You don't need the Editor to open these files, as they can be opened and edited using any text editor (Notepad, Wordpad, Edit, ...). All the things you describe (opening files from one Office program using another Office program and manipulating its contents and so on) can be done, but it is quite a high level of programming and knowledge of the different Object Models underlying each application. The best way to start is having a look at the VBA help included in Excel. You can access it from the Visual Basic Editor. Regards, Alex Guardiet "Jackie" wrote: 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 |
Reply |
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 |