Xtreme Visual Basic Talk

Xtreme Visual Basic Talk (http://www.xtremevbtalk.com/)
-   .NET Office Automation (http://www.xtremevbtalk.com/-net-office-automation/)
-   -   VB.Net Office Automation FAQ (http://www.xtremevbtalk.com/-net-office-automation/160459-vb-net-office-automation-faq.html)

Mike Rosenblum 04-13-2004 08:46 AM

VB.Net Office Automation FAQ
VB.NET Office Automation FAQ

This FAQ 101 is a listing of handy links for getting started with .NET Automation/Interoperation of Microsoft Office programs such as Excel, Word, Access or Outlook.

The first place to start learning about how to integrate MS Office programs into your .NET application is the tutorial Automating Office Programs with VB.NET. It discusses what you need to know to get started, as well as addressing some of the difficulties with .NET Automation such as execution speed and deployment issues. If you are new to .NET Interoperation/Automation, then this link is a good place for you to begin.

For articles on how to utilize Excel, Word, Outlook, Access, and PowerPoint when programming with Visual Basic .NET, please check out the following links:

(1) Understanding the Excel Object Model from a .NET Developer's Perspective
(2) Understanding the Word Object Model from a .NET Developer's Perspective
(3) Programming Microsoft Outlook with Visual Studio .NET
(4) How To Automate Microsoft Access From Visual Basic .NET
(5) How to use automation to create and to show a PowerPoint presentation by using Visual Basic .NET

Some advanced forums on MS Office programming include:

(1) .NET Office Automation (XVBT)
(2) Visual Studio Tools for Office Forum (MSDN)
(3) COM Add-ins Forum (MSDN)
(4) Interoperation / Office Integration (XDNT)

Microsoft Office Programs are still COM ActiveX Servers, so the best help regarding specific commands or techniques can be often found in the VBA Forums. If your question is .NET-specific, please place your question in the .NET Office Automation forum. But if your question regards the Microsoft Office object model, as called from VBA or Visual Basic 6.0, then the following VBA/VB6 Office Integration forums can be your best bet:

(1) VBA / Office Integration forum (XVBT)
(2) Excel VBA forum (XVBT)

For some general articles regarding MS Office Interoperation from your .NET application, see the following links:

(1) Automating Office Programs with VB.NET
(2) Building Microsoft Office Add-ins with Visual C# .NET and Visual Basic .NET
(3) HOWTO: Run Office Macros by Using Automation from Visual Basic
(4) Develop Microsoft Office Solutions with Visual Studio .NET

For articles dealing with execution or deployment issues and problems:

(1) Office Application Does Not Quit After Automation from VS.NET Client
(2) Microsoft Office XP PIAs Are Available for Download
(3) Office XP Primary Interop Assemblies Known Issues

I hope that the above links help you get started. If anyone has any suggestions for other links regarding .NET Office Interoperation, please send me a private message and we will would be glad to add it.

Happy coding!

All times are GMT -6. The time now is 05:49 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Optimisation provided by DragonByte SEO v2.0.15 (Lite) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
All site content is protected by the Digital Millenium Act of 1998. Copyright©2001-2011 MAS Media Inc. and Extreme Visual Basic Forum. All rights reserved.
You may not copy or reproduce any portion of this site without written consent.