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.

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 Microsoft for existing solutions.

Summit/Microsoft Partnership Information

Effective July 1, 2011, Microsoft will move technical support for both Visual Basic for Applications (VBA) and Visual Studio Tools for Applications (VSTA) in-house. Summit Software will continue to provide business operations support for both technologies. For more information, please see the transition document.

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)

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.

VBA Forum - most recent posts

Visual Basic for Applications

how can i download all the excel files present in a sharepoint using vba?
hiI would like to download all the excel files that are present in a folder in sharepoint to my local disk using VBA. I am able to download by giving the filename manually. But i wanna download all the files without giving the file name. can anybody help... altro

How do I programatically change label captions if I don't know the label control name?
Hi,I am trying to programatically change caption text on 68 labels in a word document.the labels are all named in rows lblBarCode00, lblBarCode001, lblBarCode002lblBarCode02, lblBarCode011, lblBarCode012...lblBarCode21, lblBarCode211, lblBarCode212... altro

Scale Column Width in Excel for different display
Hi All,Need help for setting Column width in excel for display.The file will be used in different computer with different monitor. e.g. 17 inch, 19 inch, 4:3, 16:9, 16:10, etcWhat I want is whenever users open the file, those columns are always occuppi... altro

Technology Resources

ISV Touchdown Web Seminars

ISV Touchdown Webcasts

On-Demand Webcasts

Microsoft sta conducendo un sondaggio in linea per comprendere l'opinione degli utenti in merito al sito Web di. Se si sceglie di partecipare, quando si lascia il sito Web di verrà visualizzato il sondaggio in linea.

Si desidera partecipare?

Informativa sulla privacy