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

Advanced Excels With EPPlus

23 May 2018 by yuvalsol

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

.NET

MS-Excel

Office

OpenXML

pivot-table

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

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

The Ultimate Toolbox Application Skins

24 Aug 2007 by The Ultimate Toolbox

The Ultimate Toolbox supports Office XP, Office 2003, and Classic application skins

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, 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 Pixelating Image Creator

30 Aug 2017 by simonp_ca

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

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

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.

Simple POCO Mapper for EPPlus

18 Nov 2023 by Erik Drent

A simple POCO mapper for EPPlus

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.

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.

Simple Metro Style Application with WCF service and MS Excel Database

16 Apr 2013 by Muhammed Anseer K K

Creating a metro style application with WCF

Word and Excel Documents View in IFrame using TreeView control

29 Jan 2012 by rish_wins

Office Documents View using TreeView

Office

Microsoft Office Version Detector

8 Nov 2012 by aalvarez13

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

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"

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.

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.

Introduction to Office 365 - Administration Center

25 Nov 2013 by vivekthangaswamy

This is an introduction to Office 365 (Administration center)

Office

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

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.

PowerPoint timer (addin)

27 Oct 2012 by hevesir

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

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.

The Six Hat Send Mail Class (Easily Send Email Using VBA)

2 Jul 2016 by Six Hat Solutions

Easily Send Emails From Your Microsoft Applications Using VBA and the SendGrid API

Outlook Automation

19 Jun 2009 by Rolf_atSC

This article shows how to automate Outlook using VS2008 rather than VSTO or VBA

VBA Composite Control Object Model

25 Feb 2011 by Joel C Graff

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

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

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.

Migration Toolkit for SQL Data Services(SDS)

3 Mar 2009 by Won Dong

Process and toolkit to migrate data to Microsoft SQL Data Services

XML

Office

DBA

OfficeQuery using XLINQ

17 Jan 2010 by Danny Hauptman

Using XLINQ to search through a Word2007 zipped document.

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.

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

PowerPoint template generator

7 Aug 2014 by roli.hof

This article describes a windows forms application which automates MS Office PowerPoint 2007 in order to replace predefined text of a template with your input

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

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.

MebhiChokiDAR – Tweet Sentiment Analysis and More Using Microsoft Flow

22 Mar 2019 by Rajat-Indiandotnet

How to do sentiment analysis using few clicks and see live graphical representation using Power BI live feed

Indian Prime Minister 2019 Live Poll – Analysis using Microsoft Form, Microsoft Flow and Power BI Live

30 Mar 2019 by Rajat-Indiandotnet

Live Poll – Analysis using Microsoft Form, Microsoft Flow and Power BI Live

Office

COM

PowerBI

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.

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.

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)

IMSL® C# with Excel and VSTO: An Introduction and Walkthrough

7 Jan 2008 by Visual Numerics, Inc.

This document focuses on the combination of VSTO 2005 and Visual Studio 2005 Team Edition.

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

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

VBE CreateToolWindow

5 Jan 2012 by Sam Gerené

Create a custom dockable window in the VBA editor.

Utilize Outlook 2010 add-in to copy email attachments to SharePoint

16 Mar 2012 by Scott Traube

This article gives a quick method for looping through all attachments in a single email message and uploading to SharePoint 2007 or 2010.

Office

Dev

Outlook 2007 Calendar Preview

20 Mar 2012 by Ron Levy

A form region with a calendar preview for outlook 2007

Office

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

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.

How to Import and Export Excel XLSX in Go Language

30 Dec 2019 by Ri Xu

This post shows you how to import and export Excel XLSX in Go language.

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.

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.

Using an Access, MySQL, PostgreSQL or SQLite Database from VBA

16 Jan 2018 by Pragmateek

Using an Access, MySQL, PostgreSQL or SQLite Database from VBA

Add Random Quotes in your Outlook Email Signature

29 Nov 2011 by Md. Marufuzzaman

Add random quotes in your Outlook email signature

VSTO Excel and Word Add-In C#

29 Jun 2015 by syed shanu

Driving Microsoft Word, using VOLE

10 Aug 2007 by Matt (D) Wilson

An alternative take on describing the VOLE Automation library

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

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

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

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.

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

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

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.

A Serious Outlook Style Navigation Pane Control

15 Nov 2010 by HawVie

A quality rendered Outlook style navigation pane control

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.

SharePoint Report Viewer Page Hacks

22 Sep 2009 by Marian Dumitrascu

An alternate way to view Microsoft Reporting Services reports in SharePoint.

Javascript

Office

ASP.NET

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.

COM Interop the Hard Way

7 Apr 2007 by keesp

A COM Newbie's Journey Through DLL Hell

Reusable Class to Generate Excel Files

20 Mar 2009 by Sergio Romero

A class that generates an XML string as an Excel file

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.

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.

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.

WPF C# Ribbon Control Library

25 Jun 2008 by Derek Bartram

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

MS Access Databases Queries Editor

26 Jul 2009 by Yasser Daheek

A very productive, easy to use tool to edit your Sql Queries against MS Access Databases

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.

SharePoint Forms Based Authentication Using DotNetNuke as User Store

11 Aug 2008 by Marian Dumitrascu

Use DotNetNuke user store and management for SharePoint web applications that use Forms based authentication.

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.

DBSheets

3 Nov 2007 by rkapl

Excel based solution for modifying Database data

Token Replacement in Office Documents

12 Nov 2009 by Rahul Singla

A new productive way of producing Office documents with dynamic content substitution.

Very Simple Library to Work with Excel in .NET

23 Aug 2008 by Shayan Elhami

Provides a very easy to use library (using Interop, Attributes and Reflection) to work with Excel files in .NET

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

Office Programming Helper Indent VB Code

4 Sep 2023 by NewPast

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

VBA

Office

WPF Color Picker Like Office 2007

17 Jan 2010 by Saraf Talukder

A simple to use Color Picker with advanced color palette for WPF Applications with look and feel of Office 2007 color picker

Office

WPF

color

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

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

26 Aug 2009 by ColinBashBash

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

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

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.

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.

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.

Import Data from Excel into SQL Server Using SSIS

16 Dec 2011 by Keshav Singh

In this video article

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

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.

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

ProSysLib: Dissecting the Process

22 Nov 2010 by Vitaly Tomilov

Access detailed information about the current process the easiest way.

Professional System Library: Introduction

22 Nov 2010 by Vitaly Tomilov

A simplified and unified way for accessing most frequently used information about Process, System, and Environment.

How to Deliver an Email with an Attachment of the Active Working Document from Microsoft Office Word

4 Sep 2011 by Md. Marufuzzaman

We discuss Microsoft Office Word 7 addIn, which is able to deliver an email with little text and able to attach the current document as a Zip/Compress file or standard Microsoft Office Word document file format & send the email from Microsoft Office Word Interface.

Programmatically create a browser enabled InfoPath form

12 Feb 2009 by Simon Bonello

How to programmatically create a browser enabled InfoPath form.

Creating an Outlook Calendar using WPF (Part 1)

21 Oct 2008 by rudigrobler

Recreate the Outlook Calendar using WPF.

MS Office OLE Automation Using C++

5 Apr 2009 by Naren Neelamegam

A simple guide to automate MS Word and MS Excel using C++.

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