New tools for Office 11 -- Whither VBA?
[ADT's PROGRAMMERS REPORT, December 17, 2002] -- Developers of applications
for Word and Excel will have new tools and XML-based schemas to work with when
the 2003 version of Office is released.
New Visual Basic and C# tools, within the Visual Studio .NET framework, will
expand Office developers' options beyond what is available with the current
Visual Basic for Applications (VBA) language, according to Microsoft
But when asked if the new tools, code-named Visual Studio Tools for Office,
will replace VBA, Robert Green, lead product manager for Visual Studio, answered
with an emphatic ''no.''
''VBA remains a very important part of the next version of Office,'' Green said
in a pre-briefing on the tools and XML capabilities of the next version of
Microsoft Office scheduled for release mid-2003. ''The VBA code you wrote in
Office XP will run in the next version of Office. And VBA gains some interesting
new capabilities, [including] the ability to call Web services [and] the ability
to work with some of the XML features in Office.''
Added Green: ''What we're announcing today is a set of tools that lets
developers using Visual Studio .NET write Visual Basic or C# code that runs
behind the next version of Word and Excel documents.''
The Visual Studio Tools for Office will allow developers to take advantage of
the productivity features in Visual Studio .NET, he explained. These include the
Visual Studio code editor, which automatically flags errors and does background
compilation as the programmer writes code. Developers will also be able to use
Visual Studio design tools for building forms and working with XML, as well as
the Visual Studio capabilities for code management and debugging, he said.
To read more stories of related interest, please see:
OOPSLA'' by Jack Vaughan at http://www.adtmag.com/article.asp?id=6952
''Tuning in to .NET'' by Lana Gates and Jack Vaughan at http://www.adtmag.com/article.asp?id=6007
''Microsoft's Don Box on SOAP, XML & VB'' by Jack Vaughan at http://www.adtmag.com/article.asp?id=6361
For other Programmers Report articles, please go to http://www.adtmag.com/article.asp?id=6265
Rich Seeley is Web Editor for Campus Technology.