Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

do_you_eally_need_excel_vba_t_aining [2016/05/02 09:34] (Version actuelle)
lashundawallen5 created
Ligne 1: Ligne 1:
 +Recently there has been a tremendous outcry in the Office community swirling around the rumour that Microsoft is removing Visual Basic for Functions from future variations of Office. Business managers are wondering if they need to trouble with Excel VBA training programs if the macro language is on its way out.
  
 +To paraphrase Mark Twain, the rumours of VBA's dying have been drastically exaggerated.
 +
 +Office 2.0eight Ships With out VBA 
 +The controversy began when the latest version of the software suite for the Macintosh, Office 2.0eight, was released without VBA support.
 +
 +The reasons for the change have been rooted in the Macintosh itself. It has at all times been troublesome to keep VBA appropriate with the Macintosh processors. It would have required a substantial amount of effort to keep up support for something that's utilized by no different application than Office.
 +
 +Instead, the Macintosh model of Office helps AppleScript for macro creation. The item models of the two languages are equal so it is a simple matter of adjusting syntax. Nevertheless "​easy"​ does not imply "​straightforward"​ and workbooks with giant, sophisticated macros are going to be difficult to upgrade.
 +
 +VBA Is Protected in Windows Office ​
 +Recently, The Register reported that Office 2.09, the subsequent Windows release of Office, would also not embrace VBA. This was an incorrect report and The Register has since retracted the statement, but not earlier than creating an online firestorm.
 +
 +The reasons for the removal of VBA from Mac Office are irrelevant to a Windows environment. Microsoft has said definitively that VBA might be in Office 2.09 they usually have no plans to take away it from future versions.
 +
 +Should VBA Be Deprecated? ​
 +There'​s good reason for Microsoft to consider abandoning VBA in favour of a more safe macro environment. VBA is without doubt one of the biggest security holes within the Office suite and Microsoft is working to protect Office from all vulnerabilities. Nevertheless the balance between future needs and backward compatibility has at all times been a tricky determination for software program developers.
 +
 +Though VBA could eventually be deprecated from the Windows Office surroundings,​ that does not mean the macros nicely become obsolete. For instance, Microsoft removed XLM macros in favour of VBA in 1995 and but they nonetheless operate even in Excel 2.07.
 +
 +If Microsoft introduces a new, more secure macro language in Office 2.09, VBA will still be an available software and which means there will all the time be a spot for [[http://​www.londonexceltrainingcourses.co.uk|advanced excel training courses]] VBA training in your organization.
 +
 +Even if your small business uses solely Macs, VBA continues to be a part of the picture. Most organizations do not instantly improve so older variations of Office are in use nicely after they cease to be the main edge. While you do upgrade to Office Mac 2.08, you will need Excel VBA training to understand those out of date macros with the intention to rewrite them in AppleScript.