VB.NET Office Automation FAQ

I saw this article on a forum, i think it is a very useful article regarding Office Automation

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 fully utilize the Excel object model, Word, and Outlook 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

(We still lack a resource for utilizing the Access object model in .NET, so if someone knows of a good source, please send me a private message and we will be glad to add it.)

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) Creating Office Managed COM Add-Ins with Visual Studio .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

Add Google Search Code on your Website

Add Google Search in your Website
Just Copy & Paste the code below on your Site

<br /><!-- Google CSE Search Box Begins --><br /> <form id="searchbox_009710580702655398188:nkjkxwwxopk" action="http://www.google.com/cse"><br /> <input value="009710580702655398188:nkjkxwwxopk" name="cx" type="hidden"/><br /> <input value="FORID:1" name="cof" type="hidden"/><br /> <input name="q" size="45" type="text"/><br /> <input value="Search" name="sa" type="submit"/><br /> </form><br /> <script src="http://www.google.com/coop/cse/brand?form=searchbox_009710580702655398188%3Ankjkxwwxopk" type="text/javascript"></script><br /><!-- Google CSE Search Box Ends --><br />

Basic SQL Part 1

Select Statement

 

Sample Statement

Select * From Receipt

 

* = Wildcard or to Display all the Field in a Table

Receipt = Name of the Table.

 

Sample OutPut

IMPORTANT NOTICE:
The information in this email (and any attachments) is confidential. If you are not the intended recipient, you must not use or disseminate the information. If you have received this email in error, please immediately notify me by "Reply" command and permanently delete the original and any copies or printouts thereof. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by American International Group, Inc. or its subsidiaries or affiliates either jointly or severally, for any loss or damage arising in any way from its use.

Basic SQL Part 1

Select Statement

 

Sample Statement

Select * From Receipt

 

* = Wildcard or to Display all the Field in a Table

Receipt = Name of the Table.

 

Sample OutPut

IMPORTANT NOTICE:
The information in this email (and any attachments) is confidential. If you are not the intended recipient, you must not use or disseminate the information. If you have received this email in error, please immediately notify me by "Reply" command and permanently delete the original and any copies or printouts thereof. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by American International Group, Inc. or its subsidiaries or affiliates either jointly or severally, for any loss or damage arising in any way from its use.