Microsoft Excel VBA Software and Microsoft Excel Macro Design
Taking Spreadsheet Design in New Directions
Taking Spreadsheet Design in New Directions
Since 1998, EMAGENIT has been involved with Microsoft Excel VBA software design and has created software solutions for companies and organizations like:
NASA Award for Microsoft Excel Software Design
EMAGENIT received an award from NASA for its Microsoft Excel macro design for the Mars Rover. We helped NASA redesign its interfaces and calculation tools used in the design of its Mar's rovers in Microsoft Excel for easier use and efficiency. Click on the graphic to the left to see how we did it.
Example of a Simple Worksheet Dashboard Built from Data Validation, Conditional Formatting, ActiveX Controls, Charts and Excel Array Formulas.
Microsoft Excel Worksheet and Formula Design - Worksheet and Formula Topics
Example of a reporting tool in Excel that processes data, creates charts then places them in PowerPoint.
Microsoft Excel VBA Software Design - Automated Report Topics
Example of One of Our Dashboards from Our Tek-Tasks Scheduling Software.
Microsoft Excel Macro Design - Microsoft Excel Dashboard Topics
Example of Our Access Table Maker That Manages and Loads Worksheet Data into an Access Database.
Microsoft Excel VBA Software Design - Data Integration, Systems Integration, Folder /File Management Topics
Example of a Simple Dashboard That Queries Multiple Text Files and Constructs Collated Data Tables.
Microsoft Excel Macro Design - Data Processing and Data Mining Topics
Example of Our Worksheet Table Encryption That Encrypts and Automatically Decrypts Data When Calculation Occurs.
Microsoft Excel VBA Software Design - Microsoft Excel Security Topics
What is an Microsoft Excel Macro
An Excel macro is a computer program that is written or recorded and is stored in a workbook file. When run, it can perform a series of automated tasks in Excel such as automated chart creation, formatting, data processing, pivot table construction... the list is endless. Microsoft Excel macros are also capable of executing sophisticated logic instructions as well as performing iterative tasks like going through a folder for a specific file or scanning Excel for an open workbook or a specific worksheet for a value. The word Macro is actually misleading being confused with the earlier Macro language that Microsoft Excel used in the early 90's. The macros back then where stored on what looked like an Excel worksheet, these sheets being called Macro Sheets. They still exist in Excel today, if you right mouse click over a worksheet tab and select Insert/MS Excel 4.0 Macro. The code on these sheets look like a series of formulas. One of these old style sheet is illustrated directly to the right. An Excel macro today is actually a Visual Basic procedure, which is written in VBA which stands for Visual Basic for Applications (What is VBA). So people use the terms VBA macro, Excel macro, Excel VBA macro, Excel VBA... to describe the newer VBA code.
Where are Excel VBA Macros Stored?
When commanding Microsoft Excel, you usually write a Sub procedure or in some instances a Function procedure. These procedures are stored in a workbook file in a module and can be viewed in the VBA Editor by pressing the Alt+F11 key while in Excel. When the workbook file storing the VBA macro is distributed, the code also goes along with the workbook. When the workbook is opened, its Excel VB A code is opened. When a workbook is closed, the VBA procedures are closed. Once a macro is saved in a workbook and the workbook reopened, the VBA macro must be enabled for it to run. Microsoft Excel will prompt you with a run dialog box or a run button which is underneath the formula bar. When Excel VBA code is saved in an Excel 2007 workbook and above, the workbook file must be saved out as an Excel Macro-Enabled Workbook or the code will be lost when the book is closed.
What are the Capabilities of Excel VBA
An Excel VBA Macro is not only capable of automating the Excel environment, it can also command other programs that are VBA compatible. In other words, you can be in Excel and command Word, Internet Explorer and SQL server in the same procedure. A macro can also talk to other computer languages like C, VB.NET, FORTRAN basically any language that is VBA compatible. What this brings to the table is being able to access capabilities and speed that VBA does not process. Do not underestimate the power of Excel VBA, they have Excel at their command, other programs, other languages and can do the most sophisticated mathematics and analysis that you want to do. Developing VBA macros in Microsoft Excel takes about a sixth of the time as other traditional programming environments (sometimes quicker) and can flat out do things that are impossible in other computer languages without a great deal of effort. There are many EMAGENIT projects that started as band-aids till bigger systems were developed and then took over as the main programs because the other systems could flat out not be developed.
Why Recording a Microsoft Excel Macro Does Not Accomplish Your Goal
A lot of books and consulting
companies push that being able to record a macro in Excel is
all you need to put together a program. In some instances,
consulting companies will claim to know how to write macros
for Excel and actually just switch on the recorder and edit
the code a little. Plugging that all you need to know is how
to use the Macro Recorder to control Excel is a very false
misleading statement. The Macro Recorder is really an
ineffective tool when used to try to build an Excel Macro
from scratch. The biggest failure comes in the way it
records the object expression (path) to what you are trying
to control in Excel. Object oriented programming revolves
around the single concept that you create an object
expression (think of the way you drill down Windows
Explorer) identifying what you are trying to control then
tell that object (program element) what to do. The recorder
does not record code this way, it uses an active strategy
which means it will generate code that will toggle workbook
to worksheet to get you into position, then use a Selection
command most of the time to identify what you want to
control. The following is the way the Excel Macro recorder
Instructions: Please fill in your contact information.
Copyright © 2002-2017
EMAGENIT All Rights Reserved