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 Simple List Class for VBA Projects

16 Dec 2013 by Stefan Huy

For those who badly miss a .NET like List in VBA

VB6

MS-Excel

VBA

Office

A Simple List Class for VBA Projects

16 Jan 2016 by Glenn Lloyd

This is an alternative for "A Simple List Class for VBA Projects"

A Simple Way to Export DataGridViews/Lists to Excel

1 Nov 2012 by Pasan Eeriyagama

This article focuses on a Very simple and Robust way to export Data to EXCEL

A SOA Approach to Dynamic DOCX-PDF Report Generation - Part 2

16 Jan 2012 by Erion Pici

Generating automatized PDF reports based on Docx templates and Business-Logic XML-serialized data

Add dynamic content controls to a word document

21 Apr 2012 by pramod.hegde

Create dynamic content controls at run-time.

Office

Addin With Useful Macros & Easily Accessible From Custom Ribbon Tab

13 Aug 2012 by Sachin Chandanshive

Addin Containg Useful Macros & Easily Accessible From Ribbon Menu

Additional Helper Methods to the ExcelDataReader Package

10 Aug 2015 by E.F. Nijboer

ExcelDataReaderHelper: Functionality similar to LinqToExcel using the ExcelDataReader package

Adobe Photoshop CS4 and VBScript programming reference viewing

5 Jun 2011 by RedDk

Ever try to use the Adobe .pdf references for scripting and VBScript? This is a reference viewing tweak.

VBScript

Office

Automate Chrome / Edge using VBA

3 Nov 2021 by ChrisK23

A method to automate Chrome (based) browsers using VBA

Windows

VBA

Office

Automatically Format Foreign Words in a Word Document

24 Jun 2015 by Steven de Jong

Many professionals have to use foreign-language terms in their documents (e.g. English terminology); this macro automatically formats these terms.

Automatically Readloud Sender and Email Subject in OUTLOOK

17 Jan 2015 by Liju Sankar

Read Loud Email Sender and Subject as soon as you received an email in OUTLOOK

Avoid Sending Mail from the Wrong Account

14 Dec 2015 by bradyguy

Don't send your mail out using the wrong account

Windows

Office-Automation

Office

Beginner's Guide to PowerPivot for Excel

16 Jul 2013 by KumarM.NET

This tip explains the features of PowerPivot, a Business Intelligence tool provided by Microsoft. This is integrated with Office 2010 and provides capabilities to represent the data in various formats to business users.

C# How To Read .xlsx Excel File With 3 Lines of Code

29 Jul 2014 by dietmar paul schoder

Read rows and cells from an xlsx-file: quick, dirty, effective.

C# Storable Box Control 1.4.0.4

6 Mar 2015 by Darkencrow

A multi-drawer style collapsable UI container

Converting a Microsoft Word document to a text file in C#

5 Jan 2014 by Thomas Daniels

This Tip explains how to convert a Microsoft Word document to a text file in C#, using the Microsoft Word Object Library

MS-Word

Office

Dev

Converting Column Numbers to Range Headers and Vice Versa

2 Sep 2020 by Darren G441

Two functions to help manipulate Excel sheets with VBA by converting Column Header letters to 1 based numbers and back

Copy data from all tables in Access 2003

1 Jul 2013 by KumarM.NET

How to copy data from all tables in Access 2003.

.NET

Office

MS-Access

Copy Rows Within Excel Sheets via VBA

3 Oct 2014 by Gautham Prabhu K

Copying entire row within Excel sheet using VBA in Microsoft Office 2010 and higher

VBA

Office

Dev

Create an Excel spreadsheet from Datatable

13 Jul 2016 by Jerry Burch

Quickly create a spreadsheet from Datatable using Interop and the Clipboard

Create Folders Using Data from Excel File

22 Aug 2014 by brpulsani

How to create folders using data from Excel file

Office

VS2010

Visual-Studio

Create PowerPoint presentation using PowerPoint template

15 Apr 2012 by pramod.hegde

Convert *.potx file to *.pptx file.

Office

Create Reports in Microsoft Dynamics CRM 2011

30 May 2013 by Fazal Abu

Learn how to create reports in Microsoft Dynamics CRM in this tutorial

DataSet to Excel File Conversion using ExcelLibrary

15 Jan 2012 by Robby Tendean

ExcelLibrary implementation sample to convert DataSet to Excel file in VB.NET

DataSet to Excel File Conversion using ExcelLibrary

1 Feb 2012 by Robert Hutch

Hi,another alternative is this Excel C# / VB.NET component that has limited free version that can be used in commercial applications and unlimited professional version.Here is an Excel VB.NET code how to export DataSet to Excel:Dim ef = New ExcelFile()For Each dataTable As...

Edit Word Documents using OpenXML and C# Without Automation/Interop

28 May 2015 by koolprasad2003

This tip explains how to use Word Automation using OpenXML and C# without Word Interop.

Enhance Your Office App Development

12 Jan 2016 by Tim Cadenbach

Edit, Run and Develop JS Code directly within JavaScript

Javascript

Office

EPPlus Basics and Snippets (Cheatsheet for generating OpenXML Spreadsheet Files using EPPlus)

26 Aug 2016 by B. Clay Shannon

In which the esteemed and humble author selflessly - indeed quasi-heroically! - presents a grab bag of snippets to use when utilizing the open-source EPPlus library to create spreadsheet files

Excel - Displaying Your Top Row as the Column Header

22 May 2017 by Bassam Abdul-Baki

This allows you to display in Excel column names other than A, B, C or 1, 2, 3 (R1C1) format.

Windows

MS-Excel

Office

Excel Automation with SAP Generated Report

28 Nov 2014 by ehab_nour

Processing SAP generated Excel file as a report to get some information

Excel Interop, Subscripts and Superscripts

17 Aug 2017 by Dennis Wu CA

A demo that generates a simple Excel spreadsheet with subscripts and superscripts

Excel Molar Mass Calculator - Molecular Weight

8 Mar 2020 by NewPast

Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator

Excel To DataBase Table

3 Nov 2012 by Sarvesh Kushwaha

Export Excel to SQL database table (Sample Code)

Office

LINQ

ASP.NET

Export GridView Data to Excel using OpenXml

15 Apr 2012 by pramod.hegde

ASP.NET GridView to Excel conversion.

Office

ASP.NET

Export MS-Outlook Messages as EML or MS-Word Files With Attachments as Separate Files

16 Sep 2016 by axuno

Take this ready-to-use VBA module for MS-Outlook, that lets you export all mail messages selected in the current Outlook email browser to the file system.

Extract Embedded Files from Microsoft Office Documents

11 Jun 2014 by Kees van Spelde

How to extract embedded files from Microsoft Office documents

Extract Image Files from Database Image Data

20 Feb 2014 by PallavSingh

Converting data column (contains OLE db image binary Format) to image file (.jpg)

Fixing the Time Bar on Outlook 2013 Calendar

6 Mar 2014 by bradyguy

Outlook 2013 does not advance the current time in the calendar view; here is a hack fix.

Windows

Office

Generate Excel Chart from Data in .NET Applications

3 Dec 2013 by LazyCoder0

This tip describes how to generate Excel charts from data in .NET applications using Office Automation.

Get Outlook 07 email & attachments entry ID using C#.NET

24 Apr 2010 by Md. Marufuzzaman

Introduction...

Windows

Office

Visual-Studio

Getting the Office 2010 button like Gradient

17 Jun 2011 by VallarasuS

Here is how you can achieve Gradients used in Office 2010 Buttons with a glow at the bottom.

Getting the Office 2010 button like Gradient

20 Jun 2011 by adolfobarallobre

Here is code for an alternate:public class OfficeButton : Button{ public OfficeButton() : base() { } private Color mGradientGlowColorColor; // the Color field public Color GradientGlowColor // the Color property { get { return...

Handling Excel Lists with Interop

29 Sep 2015 by HP2M

This tip covers handling two Excel lists using Interop.

Help for the Access 2000-2003 developer with 'Out of Memory' issues or problematic codebase

24 Dec 2010 by Mike Baldini

The following code filters the specified database

VBA

Office

MS-Access

How to Add a Pivot Table to a Spreadsheet Using Excel Interop and C#

27 Jul 2016 by B. Clay Shannon

The most straightforward way to add a Pivot Table to an Excel sheet based on data already on the sheet, using Excel Interop and C#

How to Add an Image to an Excel Sheet

14 Nov 2015 by B. Clay Shannon

Adding an image to an Excel spreadsheet

.NET

Office

Dev

How to add SMS functionality to websites

8 Apr 2012 by Ozeliltd

SMS tools for business.

.NET

Office

SMS

How to Change the Owner of the PowerApp

3 Jul 2020 by Deepthi Viswanathan Nair

This tip explains how to change the owner of the PowerApp in Office 365

PowerShell

Office

PowerApps

How to Check Whether Outlook is Installed in the System or Not

5 Dec 2013 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

After the tip on Excel, Word and Powerpoint, here we will explore the trick to verify whether Outlook is installed in the client's system or not by C#.

How to Create a PivotTable with Filterable Rows and Columns using Excel Interop

25 Oct 2016 by B. Clay Shannon

An as-simple-as-possible real-world example of creating a pivot table using Excel Interop (C#)

.NET

Office

Dev

How to Hide a Range of Rows in Excel with C#

12 Nov 2015 by B. Clay Shannon

Hiding Excel Ranges (span of rows and columns) using Excel Interop (C#)

.NET

Office

Dev

How to Insert Spaces Between Words Even When They Begin or End with "Strange" Characters Using C# and the DocX Library

7 Jan 2014 by B. Clay Shannon

Inserting spaces between words using C# and the DocX Library

How to Make Rest API Calls in SharePoint Hosted App for Office 365/SharePoint Online ?

1 Sep 2017 by Britto selva pandian J

Things to remember while using Rest API calls on SharePoint hosted App for Office 365/SharePoint Online

How to Remove Extra Spaces and Add Missing Spaces Between Sentences in .docx files using C# and the DocX Library

3 Jan 2014 by B. Clay Shannon

Make sentences having one and only one space between them

How to Replace a List of Words in a .DOCX File using the DocX Library

16 Dec 2014 by B. Clay Shannon

Replace words in .docx files using the DocX Library

How to Set the Background and Foreground (Font Text) Colors on an Excel Range

14 Nov 2015 by B. Clay Shannon

Set the cell and font colors to an Excel Range in C# in three lines of code

.NET

Office

Dev

How to Set Up IMAP in Outlook 2013

4 Jun 2014 by Joan M

Avoiding problems when XLIST is not supported in your mail server

Office

How to: Get Data from Multiple Workbooks using One OleDbConnection?

3 Jan 2014 by Maciej Los

This tip shows how to get data from multiple workbooks using one OledbConnection.

SQL

Office

ADO.NET

Implementing CTPs in Excel 2010 and 2013 with Excel-DNA

13 Dec 2015 by Philippe Herremans

This tip describes a VB.NET program to implement Custom task panes in Excel 2010 and 2013 using Excel-DNA to integrate .NET into Excel.

Import Export Wizard

16 Mar 2012 by Sachin Chandanshive

Read / Write data from CSV to Excel

Improve spelling and grammar of your Articles and Tips

24 May 2010 by Patrick Kalkman

Use the tool "After the Deadline" to improve your spelling and grammar

HTML

Office

Insert/Access/Format/Filter/Se...

13 Nov 2013 by Debopam Pal

Export Advanced Excel 2007 Report

Interoperability with .NET Platform

22 Feb 2015 by Soufiane Rabhi

Communication between .NET and other programming languages

Make Outlook E-mail and Appointment Alerts 'top most'

16 Dec 2015 by maxitone

Use this if you're working in a fullscreen RDP session - for example - to see new e-mail or appointment alerts

VBA

Office

Outlook

Merge PowerPoint Presentations (PPTX) & save as PDF

5 Feb 2014 by LazyCoder0

This article describes how to merge PowerPoint Presentations (PPTX format) and save as PDF in .NET applications using Office Automation (OpenXML SDK).

Merge Presentations

19 Jul 2012 by pramod.hegde

Merge slides from multiple presentations to one at a desired position

Office-Automation

Office

Dev

Microsoft Excel BIFF8 Viewer

16 Jan 2012 by Robby Tendean

A tool for viewing Microsoft Excel BIFF8 binary format

Microsoft Excel BIFF8 Viewer

18 Jan 2012 by Jepy

Replace the last 3 blocks of code with:String.Format("{0:x}", value)

Microsoft Excel: How to Comment Cells

21 May 2015 by Alexey Shtykov

Convert column numbers to range letters and add comments

Microsoft Lync - Dial and Passcode Automation

6 Jun 2012 by Scott Traube

Microsoft Lync auto dial and auto passcode.

Office

Microsoft Office 365 – An Overview

2 Jan 2015 by vivekthangaswamy

An overview of Microsoft Office 365

Office

Migrating Access Jet Data to SQL Server

15 Nov 2013 by Mike Winiberg

GOTCHAs and tips useful when migrating a complex Access JET application to SQL Server 2012

Modern Authentication to Retrieve Project Context Project Online

7 Aug 2019 by Javeed Shaik 430

Problem Statement: Modern Authentication to retrieve Project Context Project Online

MPP Viewer

15 Jun 2011 by Vivek Krishnamurthy

MPP Viewer is a simple viewer for Microsoft Project files. I works well with 2000/2003/2007 file formats.

MS Access to MS Word

31 Jan 2013 by Mike Rosen

Export OLEObject (Word Document) to Word Document.

Office

Non-Recursive JSON Parser for VBA

27 Jun 2012 by Vinolarium

Sample code for parsing JSON with deep-nested schemas in VBA.

Office 365 / 2019 / 2016 can't start properly giving error 0xc0000142 after trying to update itself at startup solution

2 Apr 2021 by Joan M

How to be able to launch office apps that refuse to start giving the 0xc0000142 error

Office365

Office

Open Links in a New Window in SharePoint 2010

6 Feb 2014 by Ted D Wagner

Using JQuery to modify a list anchor tag to open in a new window.

Operating on Excel Cells and Cell Ranges with C#

11 Nov 2015 by B. Clay Shannon

How to obtain a reference to a range of Excel cells for manipulation and then do so (operate on the range)

Outlook email html signatures

16 Jul 2016 by Joan M

How to modify the web page that configures your mail signature.

Windows

Office

Programmatically create SharePoint Timer Job

14 May 2015 by NikiGrly

How to develop,deploy and debug a simple Timer job application

PyOOCalc - Python Libre/Open Office Calc Interface API (UNO)

20 Dec 2015 by The Purple

Create Libre/Open Office Calc documents, reports on Python

Quick-and-Dirty Testing of Microsoft Access Queries

28 Jan 2014 by B. Clay Shannon

How to query Microsoft Access tables

Read and Write Excel File Dynamically

7 Jul 2013 by Behrooz Bahrameh

This tip describes how to read Excel files and make an array of objects from Excel.

.NET

Office

Read Excel using NPOI

5 Nov 2015 by cwfong

Get Excel cell values as string

Reading Outlook Emails / Contents using JavaScript

12 Jan 2015 by Balakrishnan Dhinakaran

Add email from Microsoft Outlook to SharePoint list using simple macro, JavaScript

Reduce System Load and Speed Up Your Computer

27 Dec 2013 by IPI Paul

Reduce system load and increase performance

Rename Attachments in Outlook

7 Apr 2013 by Som Shekhar

Rename attachments before sending any email

Office

Safe Coding

26 Aug 2009 by Henry Minute

Never code whilst holding scissors. That is not what is meantby the 'cut' in cut and paste.

Simple DocX Editor in Native C#

28 Sep 2013 by Kumar Kisalaya

Basic DocX editing in C# without using OpenXML or Office Interop

Solve Black Squares on Word Titles

13 Sep 2013 by Joan M

How to remove black squares that replace numbers in titles on Word

Office

SP Beginners Part 1 – Create a Web Application on Farm and Getting It Functioning in Visual Studio

15 May 2015 by NikiGrly

Steps to create a web application on your farm.

SQL Import Data from Excel

21 Apr 2012 by pramod.hegde

Excel sheet to SQL DB

ADO.NET

Office

ASP.NET

Taking a Hybrid Automatic and Manual Approach to Set Precise Excel Column Widths in C#

12 Nov 2015 by B. Clay Shannon

How to Auto-Widen Excel Columns but then Override Over-long Columns, Shortening them

.NET

Office

Dev

Type-Ahead Suggestion Box using Listbox

2 Mar 2015 by Shibasis Sengupta

Outlook email recipient type type-ahead feature using Listbox

Update Rules; Don't Miss Emails From Actual People!

14 Feb 2014 by PopeDarren

Update Rules With Exception on Reply and Forward

VB6

Office

VBA Code for Parsing US Address Information

25 May 2018 by Clifford Nelson

VBA Code that will take a string and attempt to pull out the company name, street address, city, state, zip code, phone number, and web address

Office

Design

Dev

VBA: Excel / Word to PDF Encrypted / Password Protected

19 May 2015 by algor-AG

VBA: Excel / Word programmatically save document as PDF encrypted / password protected.

Webix Integration with Online Geographical Maps

21 Nov 2013 by sonic_youth

This tip will tell you how to add popular web maps such as Google, Nokia, OpenStreet and Yandex maps into a Webix app with just several lines of code.

Working with Excel Using C#

18 Dec 2013 by Nanda Kumar Chintam