|
|||
|
|
|
|
|
|
Discovering Macros What are macros? Macros are very powerful tools that you create to improve the performance of Excel. The word "macro" stands for "macro commands" . Historically with a simple recorded macro you would only have to hit one key instead of 10 and a series of things would happen like: enter a value, move three cells down, enter a formula, move three cells left, make the font red. Behind the scenes these macros were recorded using a programming language called VBA (Visual Basic for Applications). What are macros for? With VBA you can ask Excel to accomplish the work that you would have done manually. It will do it more rapidly, it will do it without errors and it will do exactly what you need no more no less. Here are the four main reasons why people study and use macros: - with simple macros you will get Excel to accomplish repetitive tasks over and over again. A macro will complete in seconds what would take you hours to do manually. - with more advanced macros you can work with enormous sets of data. With a macro 1,000,000 cells can be calculated in less that 3 seconds. Such a task is virtually impossible with Excel functions and formulas alone. - With Excel and VBA you can develop the applications to finish the job downstream from your centralized databases, accounting programs, CRM, and ERP programs. Large corporations use JDE, PeopleSoft, Oracle, SAP but he final analyses and reports are developed with Excel. Excel is the great equalizer allowing small enterprises to analyse their data as well as the large corporations. - ultimately with VBA for Excel you can develop almost any program that will suit your needs. There are millions of programs available on the market but finding the one that does exactly what you need is like looking for a needle in a hay stack. With macros in Excel you can develop a program that will do exactly what you need. The program can be a special accounting system, an inventory management, a quotation application, a financial data analyzer, a business model or anything that you need and it can extract data from any database anywhere in the world. With Excel you can produce these analysis and reports that are so vital to making the right decision and making it rapidly. The success of your business is the ultimate goal. More than 90% of the data analysis and reporting is done with Excel in small, medium and large enterprises. Even the large enterprises that spend millions of dollars in databases and centralized programs (accounting, sales, production) end up analyzing the data with Excel. VBA for Excel in Three Sections To help you discover VBA for Excel in the optimal order, to make sure that you learn how to walk before you learn how to run this website is divided in three sections: Section 1: The Programming Environment in Excel Developing a macro with VBA is like writing to Excel to tell it what to do for you. Instead of using your Email program you will use a very user friendly program called the Visual Basic Editor. This first section (10 lessons) shows you how to use this program and the Macro Recorder. Section 2: The Programming Vocabulary and Rules of VBA for Excel The VBA language is almost English (Add, Delete, Close, etc...). Instead of thousands of words though you will need around 50 words to write simple and useful macros. For more sophisticated macros you will need to discover around 150 words. As for the syntax you will not write "Enter 33 in cell A1" you will write "Range("A1").Value = 33". In the 13 lessons of this section you will discover all the words and syntax to develop simple and sophisticated macros. Section 3: The Userforms or Dialog Windows in VBA for Excel When you start developing real programs using VBA within Excel you will want to design and create dialog windows (useforms). With the 10 lessons of this section you will master the science and art of these useful tools to communicate with your users. Enjoy Introduction to website on Excel Macros |
|
|
|
|
