Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC: Using Automation to Create and Manipulate an Excel Workbook
Article ID: 142476 - View products that this article applies to.
This article was previously published under Q142476
Moderate: Requires basic macro, coding, and interoperability skills.
This article show you how to use Automation to create and manipulate a Microsoft Excel Worksheet.
This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to your version of the "Building Applications with Microsoft Access" manual.
Create a New Microsoft Excel Worksheet
Create a New Microsoft Excel Worksheet by Using a Bound Control on a Form
For more information about Automation, type "Automation" in the Office Assistant, click Search, and then click to view "Automation with Microsoft Access."
For more information about Automation, search for "Ole Automation," and then "Ole Automation" using the Microsoft Access for Windows 95 Help Index.
Article ID: 142476 - Last Review: January 19, 2007 - Revision: 3.3