Lately there has been a terrible outcry in the Office community whirling around the rumour that Microsoft is removing Visual Basic for Applications from future versions 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 completely overstated .

The controversy began when the latest version 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 keep VBA compatible with the Macintosh processors. It would have demanded a great deal of effort to keep support for thing 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 equal so it is an easy matter of changing syntax. But “simple” doesn’t mean “easy” and workbooks with large, complex macros are going to be difficult to upgrade .

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

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

There is great cause for Microsoft to consider abandoning 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 discussed on Microsoft Excel training courses. But the balance between future needs and backward compatibility has always been a tough decision for software developers.

Although VBA may eventually 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 Although VBA may ultimately 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 operate even in Excel 2007.

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 . 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 . You may think of 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 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

Popularity: unranked [?]

Related posts:

  1. Upgrading Your Skills With Excel VBA
  2. Microsoft Access Functions.
  3. Creating An Excel Database
  4. Microsoft Access Database Knowledge
  5. Microsoft Access Database Functions And Objects

Tagged with: • • • •

Filed under: Computers & Technology

Like this post? Subscribe to my RSS feed and get loads more!