2009 30 Oct

Lately there has been a tremendous protest in the Office community whirling around the buzz that Microsoft is removing Visual Basic for Applications from future versions of Office. Business managers are surprising if they should doubt about Excel VBA training programs if the macro language is on its way out. To retell Mark Twain, the rumours of VBA’s death have been greatly exaggerated .

The debates began when the latest adaptation of the software suite for the Macintosh, Office 2008, was released without VBA support.

The causes for the change were rooted in the Macintosh as it is . It has always been hard to hold VBA compatible with the Macintosh processors. It would have required a big deal of effort to maintain support for something that is used by no other application than Office.

In exchange for it , the Macintosh version of Office maintains AppleScript for macro making . The object models of the two languages are alike so it is a simple matter of changing syntax. But “simple” doesn’t mean “easy” and workbooks with large, complicated macros are going to be hard to improve .

Recently , The Register reported that Office 2009, the next Windows release of Office, would also not include VBA. This was an erroneous report and The Register has since forswore the statement, but not before making an online firestorm.

The reasons for the removal of VBA from Mac Office are extraneous to a Windows environment . Microsoft has stated conclusively that VBA will be in Office 2009 and they have no plans to remove it from future adaptations .

There is good cause for Microsoft to think over 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 hardened decision for software developers.

Though 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 deprecated from the Windows Office environment , 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 function 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 company . If Microsoft introduces a new, more secure macro language in Office 2009, VBA will still be an obtainable tool and that means there will always be a place for Excel VBA training in your organization . You may think of Excel training London.

Even if your business uses only Macs, VBA is still part of the picture. Most companies 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 understand those outdated 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


  • Share/Save/Bookmark
Published under Computerssend this post

No User Responded in " Some Ideas Why You Really Need Excel VBA Training "


I wish I had a Kryptonite cross, because then you could keep both Dracula AND Superman away...
by Jack Handy