This article describes how to create references to other Microsoft Visual Basic for Applications (VBA) projects, how to verify that the references are correct, and how to programmatically …

Microsoft Visual Basic for Applications (VBA) enables non-programmers to record, create, and edit macros that can automate tasks in Office applications. This article explains where you can …

On the Tools menu on the top toolbar, select References. Under Available References, select the check box for the object library that you want available in your Visual Basic project.

This example uses the GetObject function to get a reference to a specific Excel worksheet (MyXL). It uses the worksheet's Application property to make Excel visible, to close it, and so on.

This article demonstrates how to dynamically add a VBA module to a running Office application from Visual Basic, and then call the macro to fill a worksheet in-process.

Once an object is created, you reference it in code using the object variable you defined. In the following example, you access properties and methods of the new object using the object …

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in …

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in …

References For additional information about getting help with Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base: 163435 VBA: Programming …

Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. For more information, see Show the Developer tab.

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in …