Indent code, add line numbers, err handling, add number to words and more, expose a .NET library to Microsoft Word, Excel, Power Point macros writers and Access VBA code

Converting an Outlook Form Template (OFT) to a .NET Windows Form in Visual Studio

by ToughDev

How to convert OFT to .NET Windows Form in VS

Automate Chrome / Edge using VBA

by ChrisK23

A method to automate Chrome (based) browsers using VBA

All Articles

top

Microsoft Office

A Complete Excel Programming Sample

19 Dec 2007 by Lyrix

An article on Excel programming, including Excel operations in C# and VBA

.NET

Office

Dev

A Handy-Dandy Little Class for Accessing Excel Worksheet Cells

1 Dec 2010 by Brian C Hart

A class that accepts a reference to an Excel.Worksheet and lets you use an overloaded subscript operator to cleanly and intuitively read/write the Value2 of Excel cells, and get the Excel.Range corresponding to a given cell.

A Serious Outlook Style Navigation Pane Control

15 Nov 2010 by HawVie

A quality rendered Outlook style navigation pane control

A Simple Example of Merge Document (Microsoft Access 2003)

5 Nov 2009 by Md. Marufuzzaman

A simple example of merge document (Microsoft Access 2003)

VBScript

Office

A Tree-View Control Using an MS Access Table and Form

16 Jul 2013 by RB Starkey

How to create a tree-view control using an Access table and form.

A Very Basic Recursive Binary Search Tree For Excel VBA

24 Feb 2019 by WhiskeyBeforeWater

An unbalanced basic recursive Binary Search Tree for Excel VBA with functions (insert, search, delete, in order, pre-order, post-order, minimum, and maximum)

Access - Automate Compile Code, Compact/Repair, and Make MDE

26 Aug 2009 by ColinBashBash

Automate Compile Code, Compact/Repair, and Make MDE for Access.

Access Active Directory - The .NET Way

7 Jun 2007 by Manas Bhardwaj

Accessing Active Directory

Accessing SharePoint UserProfile Services in Infopath 2007

26 Apr 2007 by Saravanan20152

Access UserProfile Services in Infopath 2007.

Activate RMS for Office 365 Subscription (New O365 Admin UI)

16 Mar 2016 by Soptik Dutta

Activate RMS or Information Rights Management for your Sharepoint Online site

SharePoint

Azure

Office

Add Random Quotes in your Outlook Email Signature

29 Nov 2011 by Md. Marufuzzaman

Add random quotes in your Outlook email signature

Add-in Programming

12 Jul 2010 by hamityildirim

Add-in - add-on programming and an example for Outlook add-in regions, views, rules, and reports.

Adding An Image to a Word Document Programmatically (Microsoft Office 2007)

6 Oct 2008 by Abey Thomas

This article is about the details of adding an image to a Word document programmatically.

Adding DOC, RTF, and OOXML Export Formats to the Microsoft Report Viewer Control

31 Jul 2008 by Anton Ponomarev

By following steps outlined in this article, you will be able to get Report Viewer to generate reports in Microsoft Word formats (DOC, RTF, WordprocessingML, and OOXML) when working in the local mode.

Adding DOC, RTF, and OOXML Export Formats to the Microsoft Report Viewer Control: Implementing It Easier Using Private Reflection

18 Aug 2008 by Anton Ponomarev

By following the steps outlined in this article, you will be able to get Report Viewer to generate reports in Microsoft Word formats (DOC, RTF, WordprocessingML, and OOXML) when working in the local mode.

Adding footnotes to a Word document programatically (MS Office 2007 Word)

2 Oct 2008 by Abey Thomas

This is an article about adding footnotes to a Word document (MS Office 2007) programmatically.

Additional custom panel in Microsoft Outlook

25 Jun 2008 by Lukas Neumann

An example of undocumented integration into the user interface of Microsoft Office applications.

AddOn Programming and an Outlook AddIn2

9 Feb 2011 by hamityildirim

AddIn - AddOn programming and An Example for Outlook AddIn Regions, Views, Rules and Reports

JDBC

Office

Outlook

Advanced Excels With EPPlus

23 May 2018 by yuvalsol

Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus

Attaching Files and Creating New Mails in Outlook

11 Dec 2009 by SreeniTheGinie

Code to open the "New Message" window in Outlook and attach items

Authoring Help Files for WPF with Word 2007-2010

12 Oct 2010 by LukasX2

Introduction to a WPF powered help files engine with the option of generating help content from a Word document

Automate multiple Excel instances

25 Nov 2016 by JamesFaix

.NET library to access to any running instance of Excel.

Automating deployment for MS Access Application

30 Jun 2016 by Mani Murthy

Using .Net application to automate the MS-Access Application

Automating MS Excel Documents

25 Oct 2007 by Govardhana Reddy

This article will help demonstrate how to automate and get content from an MS Excel document.

Automating MS PowerPoint Presentations

25 Oct 2007 by Govardhana Reddy

This article will demonstrate how to automate and get content from an MS PowerPoint presentation.

Automating the Deployment of an Office InfoPath Form Templates

2 May 2007 by Srinivas-Miriyala

This tool move the previously-published infopath form templates to a new location.

Basics of OpenXML (Word 2007) for Beginners

3 Jun 2009 by PuneWala

Introduction to the OpenXML format.

Batch Converting and Merging Multiple Documents to PDF Using Open Office and Ghostscript

1 Jun 2008 by ggraham412

An example of how to use Open Office and Ghostscript to convert supported formats to PDF using Open Office and merge them using Ghostscript

Bridging the gap between .NET and Extended MAPI

28 Jun 2007 by Helmut Obertanner

An article about how to access Extended MAPI properties, fields and methods from your .NET applications.

Brute Force Password Search by Interop/Automation

14 Jun 2018 by paolo guccini

How to use the Microsoft Interop/Automation to implement parallel research of a Microsoft Office file password.

Building a Web Message Board using Visual Studio 2008 Part II - Posting messages using Microsoft Word

31 Dec 2007 by Rama Krishna Vavilala

This article uses Visual Studio Tools for Office to build a Word Document Template that can be used to post messages to a message board.

C# Excel - Pivot Table (Filter on Multiple Items)

18 Jul 2010 by Patrick.Hartnett

Add a filter to the Pivot Table where multiple items can be selected.

Cloud Service to Automate Windows Desktop Applications

2 Mar 2011 by Won Dong

To utilize cloud service as an anonymous desktop environment in Amazon S3 and EC2 Windows instances

COM Interop the Hard Way

7 Apr 2007 by keesp

A COM Newbie's Journey Through DLL Hell

Composite Applications: The New Paradigm

10 Apr 2007 by Microsoft Office Business Applications

Composite applications offer a long-sought-after business nirvana whereby empowered technical business users can stitch together componentized business capabilities. In this article, we'll discuss fundamentals and advantages of using composite applications for today's business challenges.

Connecting Custom Web Parts in SharePoint

10 Jun 2009 by Nioosha Kashani

Describes how to connect two SharePoint custom Web Parts using the Visual Studio Extension for Windows SharePoint Services.

Connecting Microsoft Word 2007 to a backend database in an Office Business Application (OBA)

17 Sep 2007 by brucedkyle

In this lab, you use drag and drop functionality to add controls to a Word 2007 template, build logic into those controls, protect the content of the controls from editing and deleting, and add simple data binding to a local database. Then, you’ll add a Fluent Ribbon to Word to browse the data.

ContextMenuStrip Control with Microsoft Office like Visual Style using VB.NET

11 Dec 2011 by Manoj K Bhoir

ContextMenuStrip Control with Microsoft Office like Visual Style using VB.NET

Office

Converting discrete data points into a histogram using Excel VBA

3 Jun 2013 by StewBob

This article gives a method for using Excel VBA to convert discrete data points into a histogram.

Converting Images to Text using Office 2007 OCR, OpenXML and Speech Recognition

19 Feb 2009 by Danie lCampos

This article will show how to integrate the Office 2007 OCR engine with custom applications and use OpenXML and Speech Recognition

Create an Outlook 2007 Form Region by using VSTO 2008

1 Jan 2008 by Helmut Obertanner

In this article, we will create a form region that shows all contacts within the same category.

Create PDFs for Free

3 Jan 2011 by Tim Corey

Learn how to automate Microsoft Word in C# to create PDF files based upon a template document that can be modified at runtime to reflect the dynamic information

Windows

Office

Dev

Creating an Outlook 2010 Add-In

10 May 2011 by Jeremy Hutchinson

Create an add-in that automatically marks items as read when they are deleted in Outlook 2010.

Office

Dev

Creating an Outlook 2010 Add-In with a Custom Send Button

22 Dec 2014 by Turay Melo

This is an alternative for "Creating an Outlook 2010 Add-In"

Creating an Outlook Calendar using WPF (Part 1)

21 Oct 2008 by rudigrobler

Recreate the Outlook Calendar using WPF.

Creation of a Word 2007 document using the Open XML Format SDK

24 May 2009 by Maciej Zbrzezny

A simple “getting started” article that shows the basis of creation of a Word 2007 (docx) document using the Open XML Format SDK 2.0 CTP.

Custom Functions in Excel: Part V, XLL-RTDs

29 Jul 2012 by Steve L. Powell

IntroductionWhy would you want to call an RTD from an XLL? Recall that the way to call an RTD is through the RTD function in Excel, so the user needs to somehow remember how many parameters your function takes and in what order to supply them and even what the function is called. Good luck explaini

Custom Ribbon Help for Office 2010 VSTO Add-ins

6 Dec 2012 by Scott Parkes

Providing custom context sensitive help for VSTO add-in Ribbon controls.

Customizable Text with Replacement Variables

3 Nov 2009 by byapparov

An article on how to use text template with replacement variables in VBA

VB6

Windows

Office

Customize the built-in Outlook Select Names dialog (or any other)

14 Jan 2015 by Helmut Obertanner

In this article, you will learn how to customize the built-in Select Names dialog and use different external data sources for your own dialog.

Data Classification Using VB.NET and Genetic Algorithm

4 Aug 2008 by Amir Emamjomeh

A simple example of how to classify data using genetic algorithm and VB.Net

Database fields merge for any Office product, just with XML

2 Oct 2007 by mc_kappa

Using this simple, yet elegant and powerful code, you can provide to your users efficient Office document merging; simply exploiting XML technology and basic string manipulation.

Database to Excel Spreadsheet

6 Jan 2011 by rwg

Select data from SQL databases into Excel spreadsheet, with headings and formatting

DataSets, XML Schemas, and Excel - Oh My!

24 Apr 2008 by George Zabanah

This article demonstrates the amazing transformation power of the DataSet with agnostic XML schemas, XML, and Excel Read/Write (all with colourful XML rendering using XmlBrowser).

DBSheets

3 Nov 2007 by rkapl

Excel based solution for modifying Database data

Dealing with Excel objects

26 Sep 2007 by Ganesh_IT

This article outlines the issue faced by most developers when it comes to dealing with Excel objects. Here, you will find code that will help in getting rid of Excel objects from the memory once they are no longer required.

Deploying Office 2003 Solutions with Auto-update Functionality

6 May 2010 by Barath Balachandran

A method to send future updates/upgrades of your Office 2003 solutions to your end user seamlessly without any user intervention.

Determining if Excel is in Edit mode

29 Aug 2007 by walt_bael

A small code sampe for determining if Excel is in edit mode.

Determining if Excel is in Edit mode with Win32 Interop

13 Apr 2009 by Viktor Hamori

In this article, one can find a possible solution how to check or to be notified if the Excel Application is in Edit mode

Developing COM Add-ins for Microsoft Office in VB.NET

29 Oct 2007 by Andrei Smolin

This article describes the ways a VB.NET developer can create a COM Add-in for Microsoft Office 2000, 2002 (XP), 2003, and 2007 in order to customize Office applications including adding UI elements and event handling.

Developing MS Project application using Asp.net/VB.net

3 Sep 2007 by ihsanps

Developing a microsoft project application using asp.net

Developing Outlook 2003 Addin on VSTO SE under Vista + 2007 Office

20 Apr 2007 by Paul Dedyul'kin

How to compile and debug 2003 VSTO Addins under Vista + 2007 Office

Development of iPhone client application for SharePoint 2013

3 Apr 2013 by Komin Dmitry

How to write iPhone application to authenticate to SharePoint and read the contents of a list provided by the SharePoint REST API.

DevExpress Document Server – Automate Office Without Microsoft Office Automation

10 Sep 2013 by Dirk_Strauss

DevExpress Document Server – Automate Office Without Microsoft Office Automation

Office

Disaster Recovery Plan In MOSS 2007

10 May 2008 by Tariq Younas

Article describes how to make backup and recovery plan of MOSS 2007.

Displaying Charts in SharePoint using Excel Services

18 Dec 2007 by Zabiullah Sheik Ismail

An article on how to display charts in SharePoint using Excel Services

Windows

Office

Dev

Document and Code Generation by LINQ and XSL

3 Aug 2008 by Dave Elliott

An article on how to generate source code as well as populate Excel Spreadsheets.

Download SharePoint Zipped List Items

25 Oct 2008 by Mohamed Zaki

This custom UI Action for SharePoint extends the lists action menu to allow users to zip document library items and download all of them with or without version.

Drag and drop Outlook attachments

19 Jun 2008 by Javed Akhtar Ansari

This article demostrates how to do drag and drop Outlook attachments on a tree view node and describes the private Clipboard format of Outlook.

Driving Microsoft Word, using VOLE

10 Aug 2007 by Matt (D) Wilson

An alternative take on describing the VOLE Automation library

Easily Retrieve Email Information from .EML Files -- Revised

30 Apr 2010 by BillJam11

C# classes that upload an EML into a System.Net.Mail.MailMessage

Edit Microsoft Word Document From Your Application

14 May 2009 by Rudra Sankar

Create & edit Microsoft Word document from Windows application Form by using C#

C#3.0

C#2.0

Office

Efficient Software Development

30 Nov 2008 by mc_kappa

Describes the theory of how software development can be simplified even for mission critical applications

Embedding .PNG Images into a RichEdit Document

11 Apr 2019 by Jose A Pascoa

Although most Windows programmers have already used the RichEdit Control, many of them are not aware of all its capabilities. One such capability is image embedding.

Excel Add-in for Exporting Data to XML

21 Jan 2015 by Syed Umar Anis

ExcelXMLExport is a Microsoft Excel 2010 / 2013 Add-in that generates XML data from Excel sheet.

Excel and VBA - Query ListObject Directly

9 Nov 2014 by Allen C. Copeland Jr

A guide on querying Excel ListObjects (Tables) by creating a state-machine out of synthesized objects that resemble a query language.

VBA

Office

Design

Excel Files in JavaScript, the Simple Way

25 Jul 2017 by Jose Segarra

A front-end library to create Excel files, including formatting and styling cells

Excel Pixelating Image Creator

30 Aug 2017 by simonp_ca

Use Excel worksheet's cells as pixels to render real image (for fun and experiment)

Excel, Jira, Rest API end to end example

12 Apr 2016 by bradyguy

An end to end view of how to integrate Jira REST API's with Excel.

Excel-addin for Database Querying by User Defined Functions

2 Nov 2007 by rkapl

DBFuncs is an Excel-addin for database querying by user defined functions

Export DataSet to Multiple Excel Sheets

12 Dec 2008 by Ming_Lu

Exporting multiple tables in a DataSet to multiple sheets in an Excel file

.NET

Office

Dev

Export Image to Excel using c#

11 Oct 2013 by ASP.NET Community

Here am trying to show how we can export an image to excel file.References Used: Microsoft.Office.Interop.Excel;Link for downloading the dlls

MS-Excel

Office

export

Export Tabular Data in PDF Format through the Web

13 Oct 2011 by Dr. Song Li

This article presents an example to export tabular data in PDF format through the web.

Exporting a DataGridView to an Excel/PDF/image file by using Reporting Services report generation

20 Aug 2008 by Andriy Protskiv

ReportExporters is a library for easy exporting of a DataGridView to Excel/PDF/image file types by using Reporting Services report generation.

Extending Excel with .NET

15 Jul 2009 by Rolf Jaeger

This article demonstrates how to automate Excel using VS2008 rather than VSTO or VBA

Extending Office 2007 with Tangram Extension Tools for Application

24 Dec 2007 by sunhui

A new method for Extending Microsoft Office 2007 User Interface using MFC/ATL and .NET technologies.

Fetching Data from Microsoft Excel using SQL

30 Jul 2007 by Rashutosh Paul

How to fetch data from Microsoft Excel using SQL

Fix Local Disk (Q) Added by Office 2010 Beta

28 Jun 2010 by huongwin

An article about how to fix Local Disk (Q) added by Office 2010 Beta

Office

Dev

Generalized DataGridView Export to Excel with Theme and Formatting

6 Nov 2009 by Dan Mos

An article on exporting any datagridview contents to a Excel file, with theme and formatting or a *.CSV (no theme)

Generate Access Reports from Tables

24 Jun 2014 by Bhis

Back in 2008, I was doing some freelance work and had a chance to work on this MS Access Report project. The client dealt with employee benefits, claims, and payment reimbursements.

Generate Word documents from Word templates using the Word 2007 XML object model

16 Dec 2007 by Praveen Bonakurthi

How to generate Word documents from Word templates using the Word 2007 XML format.

Generate XPS from Word documents with VB 2008 and WPF

9 Mar 2008 by Alessandro Del Sole

An alternative way to create XPS documents via Visual Basic code and VSTO assemblies.

Google Map WebPart

23 Apr 2008 by Simon Bonello

A Google map WebPart.

Office

ASP.NET

Dev

Hadoop For .Net & AngularJS Developers

29 Dec 2015 by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

Javascript

.NET-Compiler-Platform

Help System Automation

26 Sep 2007 by Amr M. K.

Word Document Automation

Hiding and Storing/caching of Application Specific data in MS Word 2003 documents

9 Oct 2008 by batra.vinita@gmail.com

Proof of concept on how the application specific (small/large amount of) data can be stored in ms word document as well as how it can be made hidden from end user’s eye.

Hosting an Electronic Form with a Windows Form

21 Nov 2009 by logicchild