ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Writing Excel Macro (https://www.excelbanter.com/excel-worksheet-functions/58078-writing-excel-macro.html)

McHarrisco

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

Niek Otten

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





All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com