Discontinuation of the VBA Licensing ProgramSince June 1996, when we first announced the Microsoft® Visual Basic® for Applications (VBA) licensing program, we have been offering VBA for licensing to Independent Software Vendors and others who wished to integrate VBA into their own applications. As previously announced, Microsoft does not expect to make significant enhancements to VBA. This does not impact the current support commitments for VBA in any way, and of course, it does not impact any license arrangements that are in force. In particular, this does not impact VBA in Microsoft Office products. Microsoft is investing its application programmability resources in Microsoft® Visual Studio® Tools for Applications (VSTA) and its companion set of tools, Microsoft® Visual Studio® Tools for Office (VSTO). We encourage you to consider VSTA for new applications that require application programmability technology. Summit Software is Microsoft’s vendor for VSTA licensing. As of July 1, 2007, Microsoft will no longer offer VBA distribution licenses to new customers. Existing VBA customers can still purchase additional VBA licenses from Summit Software and Microsoft for existing solutions. |
Product Information
Articles and WhitepapersConvert VBA Code to Visual Basic .NET When Migrating to Visual Studio 2005 Tools for Office
Convert code from Visual Basic for Applications to Visual Basic .NET when migrating to Microsoft Visual Studio 2005 Tools for the Microsoft Office System. This document highlights the reasons to migrate, the major code conversion issues, and additional resources for further details. (March 2005) Overview of Code Snippets Using Visual Studio 2005 Tools for Office
IntelliSense code snippets for Visual Studio Tools for Office provide a quick start for Word and Excel development tasks in Visual Studio, Version 2005 Beta 1, including data import/export, collaboration, and integration with Excel and Word controls. (December 2004) What's New in Visual Studio 2005 Tools for Office
The new features of Microsoft Visual Studio Tools for the Microsoft Office System, Version 2005, include the project system, a visual designer for Microsoft Office Word 2003 and Microsoft Office Excel 2003, view controls, actions pane support, visual data binding, data caching, and server-side programming. (October 2004) Comparing Microsoft Visual Basic for Applications 6.0 and Microsoft Visual Studio Tools for the Microsoft Office System
Create a Microsoft Visual Studio Tools for the Microsoft Office System or Microsoft Visual Basic for Applications 6.0 project: Which is the best choice for your solution? Read this article to discover the ways these environments differ and ultimately work together. (November 2003) Ten Tips for Microsoft Office VBA Library Development
Discover ten tips for writing code that targets the Office Visual Basic for Applications (VBA) version 6.3 library. (July 2002)
| VBA Forum - most recent posts
Accessing a public array?Hello there, I've tried the following:
Creating the Array in ThisWorkbook
Accessing it the normal way
Accessing it through Globals.ThisWorksheet.<Arrayname>(index)
Creating the Array in the same Sheet
Creating the Array within a Sub (which... mais
check if a function exist in a class in vbaHi, Could you please tell me the way i could use VBA to check if a sub can be checked to exist.
I have tried
If Not o.subroutine is Nothing Then
' do anything
else
' do otherthings
End if
However, it gave me compile time error saying the argument is not... mais
Licensing and Support
Recent VBA KB Articles
Most Active VBA Newsgroups |
|
ISV Touchdown Web Seminars |