Visual Basic for Applications

Discontinuation of the VBA Licensing Program

Since 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.

Turbocharge Your Apps with Visual Studio Tools for Applications
Visual Studio Tools for Applications delivers an advanced environment for application customization built on the Microsoft .NET Framework – now in use by millions of developers worldwide.

Product Information

Frequently Asked Questions about VBA
See the answers to the most common questions about Visual Basic for Applications.

VBA Language References
Find links to download the VBA language references, for Office 2003 as well as links to online versions of the language references for prior versions of Office.

Visual Basic for Applications 6.5 SDK Changes from Prior Release

Read about the features, benefits, and enhancements of VBA 6.5 SDK from the prior release.

VBA 6.5 SDK Access

No Evaluation CD is available for the VBA 6.5 SDK, but there are two other methods for access.

Articles and Whitepapers

Convert 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

VB6 Converting File information
I was wondering if VB6 can read .text document numbers then VB will display the lowest, largest, total number used in the file and the average use of numbers.The problem I have is that I know you can open files into VB (or well open the file and display i... more

copy
Thanks for your help guys.I am now working better,

Thanks again.

One other question..please
I have a website with pictures in Adobe Flash 10.
Can i copy these pictures.

thanks

how to remove the content of a cell, but keep the formula by macro?
Hello thanks for reading.I have about 100 cells that are updating from variety of different workbooks.I need to have a remove button, in case of any wrong stuff typed in to the cell, instead of delete button on key board, user should be able to click on r... more

Licensing and Support

The “Everything We Could Find on Microsoft VBA” List
A resource list of VBA-related newsgroups, blogs, etc.

Licensing VBA
Licensing VBA enables you to distribute your VBA-enabled application to customers.

Technical Support for VBA
Learn about the technical support options available to you before, during, and after the VBA licensing process.

VBA Partner Program
When you license VBA, you automatically become a member of the Microsoft VBA Partner Program. Read about some of the benefits you'll get as a partner.

Licensing Partners
See the companies which have licensed VBA and the products they have VBA-enabled.

Recent VBA KB Articles

Before installing the Office 2007 suite Service Pack 2, you cannot use Microsoft Visual Basic for Application (VBA) to modify a chart that you have inserted in PowerPoint 2007 or Word 2007