Lately there has been a tremendous outcry in the Office community swirling around the talk that Microsoft is removing Visual Basic for Applications from future adaptations of Office. Business managers are wondering if they should bother with Excel VBA training programs if the macro language is on its way out. To paraphrase Mark Twain, the rumours of VBA’s death have been greatly overstated .
The debates began when the latest version of the software suite for the Macintosh, Office 2008, was released without VBA support.
The reasons for the change were rooted in the Macintosh itself . It has always been difficult to keep VBA compatible with the Macintosh processors. It would have demanded a big deal of powers to maintain support for something that is used by no other application than Office.
Instead , the Macintosh version of Office supports AppleScript for macro creation . The object models of the two languages are equivalent so it is a simple matter of changing syntax. However “simple” doesn’t mean “easy” and workbooks with large, complex macros are going to be difficult to improve .
Recently , The Register said that Office 2009, the next Windows release of Office, would also not contain VBA. This was an wrong report and The Register has since retracted the statement, but not before making an online firestorm.
The causes for the removal of VBA from Mac Office are extraneous to a Windows environment . Microsoft has stated definitively that VBA will be in Office 2009 and they have no plans to remove it from future adaptations .
There is good reason for Microsoft to consider leaving VBA in favour of a more secure macro environment. VBA is one of the biggest security holes in the Office suite and Microsoft is working to prevent Office from all vulnerabilities. It is widely disputed on Microsoft Excel training courses. However the balance between future needs and backward compatibility has always been a obstinate decision for software developers.
Although VBA may eventually be deprecated from the Windows Office surrounding , that doesn’t mean the macros well become obsolete . For instance , Microsoft removed XLM macros in favour of VBA in 1995 and yet they still Though VBA may ultimately be criticized from the Windows Office surrounding , that doesn’t mean the macros well become obsolete . For example , Microsoft removed XLM macros in favour of VBA in 1995 and yet they still operate even in Excel 2007.
If Microsoft introduces a new, more secure macro language in Office 2009, VBA will still be an accessible tool and that means there will always be a place for Excel VBA training in your organization . If Microsoft releases a new, more secure macro language in Office 2009, VBA will still be an available tool and that means there will always be a place for Excel VBA training in your organization . You may consider also Excel training London.
Even if your business employs only Macs, VBA is still part of the picture. Most organizations don’t immediately improve so older versions of Office are in use well after they cease to be the leading edge. When you do upgrade to Office Mac 2008, you are going to need Excel VBA training to learn about those obsolete macros so that you can rewrite them in AppleScript.
You can get an additional information about Excel VBA training by visiting Microsoft Excel training courses and Excel training London
