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

Microsoft Office Version Detector

8 Nov 2012 by aalvarez13

This is an alternative for "Microsoft Office Version Detector".

Windows

Office

Visual-Studio

Dev

Reading Online CSV File and Manage it into Microsoft SQL Database

7 Aug 2012 by Abdul Quader Mamun

How to read an online Excel file and manage it in Microsoft SQL database

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.

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.

MOSS Change Password Feature for FBA

28 Dec 2008 by Akrumooz

This feature enables a MOSS user to change his/her password when forms based authentication is enabled

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.

VBScript / Excel 2007 - An easy way to access DBF files

17 Dec 2007 by alex turner

Excel 2007 does not seem to support DBF files, here is a VBScript workaround.

This will not be in BI (Purchasing a BI tool, you do not get this)

17 Apr 2016 by Alex_2979

A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.

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

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

Help System Automation

26 Sep 2007 by Amr M. K.

Word Document Automation

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.

How to programmatically create an Outlook home folder page in the Outlook Today style

4 Aug 2008 by Andrei Smolin

Outlook Today is a sample of a custom Outlook home folder page. In this article, you will learn how to create such a page in VBScript and in .NET (VB, C#, C++).

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.

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.

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

Mail Merges in the Cloud: using Aspose.Words for Cloud

11 Jul 2013 by Aspose

Mail Merges in the Cloud: using Aspose.Words for Cloud

The 2007 Microsoft Office System and Other Platform Technologies for Building Composite Applications

15 Jun 2007 by Atanu Banerjee

A composite application is a collection of software assets assembled to provide a business capability. These assets can be deployed independently, enable composition, and leverage specific platform capabilities. Microsoft Office's comprehensive platform for this is Office Business Applications (OBA)

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.

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.

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

How to Use Exchange Web Service in C++ With gSOAP

24 Sep 2017 by Bethany_Sanders

How to connect EWS with gSOAP to send, delete, and retrieve emails.

C++

Mobile

Office

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.

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

Use Visual Studio 2008 C++/CLI to Automate Excel

24 Jul 2008 by bollwerkj

This article shows you how I got Excel to work using C++/CLI in a Windows Forms Application

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.

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.

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.

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

Restoring Two-Way Synchronization on SharePoint Lists Using Excel

6 Dec 2010 by carl.b.anderson

The SharePoint List Synchronizer for Excel 2007 and 2010, presented here, allows Excel users to open SharePoint Lists in two-way sync in 2007 and 2010 versions. This very powerful feature used to work directly in Microsoft Office Excel 2003 but the update ability was deprecated in 2007.

Using Attributes in Excel Add-in Framework for Validating and Exporting Data

21 Sep 2012 by Clifford Nelson

Demonstrates how to use attributes during run time in a serious application to improve maintainability.

Office

Dev

Network Assessment - A Guide to Infrastructure Planning

25 Jan 2008 by code-frog

A simple guide meant to take the reader through a series of questions that will help them plan for and manage their business network.

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

26 Aug 2009 by ColinBashBash

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

Searcharoo 2007 (Medium Trust and Office 2007 indexing)

28 Apr 2007 by craigd

Remove Binary Serialization to solve Medium Trust problem; index OpenXML document formats in ASP.NET/C# free search engine

VBScript for Sending IP Information to an E-mail Address

6 Oct 2007 by Cristian Amarie

VBScript for sending IP information to an e-mail address

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)

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

OfficeQuery using XLINQ

17 Jan 2010 by Danny Hauptman

Using XLINQ to search through a Word2007 zipped document.

Using Template Bookmarks for Automating Microsoft Word Reports

31 May 2018 by Darryl Bryk

A C# method is discussed for using bookmarks in Microsoft Word templates to automate reports.

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.

Worksheet Forms using WPF style architecture

21 Jun 2016 by Dave “DWC” Curry

This tutorial will show you a good starting point for a WPF style framework which aims to make creating and maintaining Excel-worksheet-forms easier.

Outlook Drag and Drop in C#

28 Jul 2008 by David Ewen

How to drag and drop multiple Outlook mail messages or message attachments to a C# WinForm.

Reading an Outlook MSG File in C#

8 Jul 2010 by David Ewen

How to read an Outlook msg file in C# without the Outlook object model

.NET

.NET2.0

Office

Multithread in MOSS page by implementing PageAsyncTask

24 Apr 2008 by David Meng

To implement PageAsyncTask for web part rendering in parallel instead of RegisterWorkItem.

WPSC in MOSS 2007 - "Cannot retrieve properties at this time. "

24 Apr 2008 by David Meng

How does WPSC register Web Parts differing from SharePoint 2003.

Office

ASP.NET

Dev

How to build a WSS custom list item ID field

23 Feb 2009 by David Meng

Introduces a way to create a key column in a SharePoint list.

Unleashing the Full Power of Regular Expressions in Microsoft Office Documents

16 Jun 2008 by David Saelman

Part 1: A method of utilizing Regular Expressions to perform power searches in Microsoft Office Documents using .NET and the Microsoft Office Primary Interop Assemblies

WPF C# Ribbon Control Library

25 Jun 2008 by Derek Bartram

A WPF / C# Library for implementing Office 2007 Style Ribbon Interfaces

MOSS 2007 Department and People Viewer Part 1/2

24 Jun 2008 by Dietmar Kurok

Showing People grouped by departments in an own style (XSLT) and without limits in count of results and paging. Only intensively using build-in Webparts.

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

How to Read and Write Excel Files in C++ via ADO

10 Nov 2010 by Dmytro Skrypnyk

Using ADO for Access to XLS and XLSX files in C++

Upload and convert PowerPoint, Excel, Visio, Word to HTML on ASP.NET

28 Dec 2012 by Don Ashworth

Upload a Microsoft Office Power Point, Excel, Visio, or Word File to webserver, of which will be converted to HTML and hosted as a document link on the page in which it was uploaded.

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.

VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007

2 Mar 2017 by Dracula

VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007

Using VBA to run Outlook Rules for one or more accounts

3 Mar 2017 by Dracula

Run all rules for all accounts on all messages; also useful as Outlook Rule debug tool.

Using Knockout.js for SharePoint Web Part Templating: Part 1

29 Dec 2013 by Drasko Popovic

How to template web parts with Knockout.js framework

Using .NET 3.0 to Automatically Generate Word 2007 Documents

26 Aug 2007 by Dungtran

This article describes how to automatically generate Word 2007 documents using .NET 3.0

MiniCRM

4 Jan 2008 by emadns

Notify your contacts with this Outlook 2007 add-in.

Simple POCO Mapper for EPPlus

18 Nov 2023 by Erik Drent

A simple POCO mapper for EPPlus

Managing transactions with Access

23 May 2007 by FrankNight

This is an Add-in for Microsoft Access that allows writing and execution of SQL statements with transaction control

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.

Office Web Component v11.0 Spreadsheet And AJAX Interoperatibility Part 1

18 May 2008 by Gautam Sharma

This article demonstrate, how OWC and AJAX can be used to store spreadsheet content as XML data into database.This XML in turns rendered as spreadsheet in OWC control from database source.

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).

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

How to List your Outlook PST Details (file name/location, PST (old/new) version, size, etc.)

26 Oct 2011 by gndzero

A fast way to display the details of all PSTs currently loaded into Outlook

Outlook add-in using VC++ ATL/COM

5 Feb 2013 by Gokulnath007

To get instant control over Outlook and various operations of outlook.

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 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.

Visual Studio Tools for Office 2008 Ribbon Designer with XLINQ for Yahoo

5 Dec 2007 by hackman3vilGuy

See the new Ribbon Designer in Visual Studio 2008 allowing you to graphically create ribbons for your Office add-ins. Add images from the Yahoo Image Search API and analyse the content of your document

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.

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

A Serious Outlook Style Navigation Pane Control

15 Nov 2010 by HawVie

A quality rendered Outlook style navigation pane control

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.

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.

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.

How to create your own map on Google Maps

22 May 2012 by hevesir

A simple way to create your own Google map from several locations.

PowerPoint timer (addin)

27 Oct 2012 by hevesir

Timer clock for PowerPoint 2007 (PPT add-in).

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

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

3 Sep 2007 by ihsanps

Developing a microsoft project application using asp.net

ImageUpdater

27 Apr 2011 by Imran S Mohamed

This article contains information on how to update an image placed in an Image placeholder in a Word document and maintain the size of the inserted image (Microsoft Office 2007) using Open XML 2.0.

Updating Charts in Word Document using OpenXML

29 Apr 2011 by Imran S Mohamed

This article contains information on how to update a chart in a Word document.

What’s In Your Toolbox? Deliver Great User Experiences with the Right Tools

1 Apr 2010 by J. Ambrose Little

Your boss says he wants your next app to look like Windows 7, have the work scheduling features of Microsoft Project and display crisp conditionally-formatted, filtered data like Microsoft Excel. You look in your toolbox, and hope it contains Infragistics’ latest NetAdvantage® for .NET 2010 Volume 1

Step by step approach to create Timer Job Using SharePoint Apps

4 Feb 2015 by Jabeen Begum

Create a timer job using SharePoint App model, CSOM and azure webjobs

SharePoint2013

Azure

Office

Querying Database with Microsoft Excel

2 Jan 2013 by Jacques Bach

An easy way to deliver data with MS Excel

Automate multiple Excel instances

25 Nov 2016 by JamesFaix

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

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.

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

VTD-XML: XML Processing for the Future (Part I)

17 Apr 2008 by Jimmy Zhang

Introduce VTD-XML, the future of XML processing

Programming XPath with VTD-XML

10 Jun 2010 by Jimmy Zhang

Learn to take advantage of VTD-XML's stateless XPath capability to achieve unmatched efficiency and flexibility

How to Create a Table with Fields in an Access Database (ADOX and JET SQL)

12 Apr 2010 by Joao Tito Livio

Creating a simpleTable with fields in an Access Database using ADOX and JET SQL

Office

ADO.NET

VBA Composite Control Object Model

25 Feb 2011 by Joel C Graff

A method for managing complex, event-driven interactions between controls

The Four Steps of Programming

18 Oct 2010 by John Paul Walker

How to think like a programmer

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 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

How to Read and Write ODF/ODS Files (OpenDocument Spreadsheets)

28 Jul 2011 by JosipK

This article will explain the basics of ODF format, and specifically its implementation in spreadsheet applications (OpenOffice.org Calc and Microsoft Office Excel 2007 SP2). Presented is a demo application which writes/reads tabular data to/from .ods files.

COM Interop the Hard Way

7 Apr 2007 by keesp