| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing Excel Macro
I have never written an Excel Macro. Where do I start?
I want to take data from one spreadsheet, and insert it into another on a monthly and cumulative basis. I have version 2000. Mac |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Writing Excel Macro
The best way to learn to do that is to do your actions manually, and record
them via ToolsMacrosRecord new macro After having done that, open the VB Editor (ALT+F11), look for a folder Modules in your VBAProject and double-click Module1 (and the next time... you get it) There you can see how Excel translated your actions into VBA. -- Kind regards, Niek Otten "McHarrisco" wrote in message ... I have never written an Excel Macro. Where do I start? I want to take data from one spreadsheet, and insert it into another on a monthly and cumulative basis. I have version 2000. Mac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Relative Ranges in excel macro | Excel Worksheet Functions | |||
| passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
| Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Hybrid Mode
