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

Simple POCO Mapper for EPPlus

18 Nov 2023 by Erik Drent

A simple POCO mapper for EPPlus

XML

.NET

MS-Excel

Office

Dev

text

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

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.

VBA or Complex formulas?

2 Nov 2019 by stc.reseller

How to stay secure by using Excel formulas instead of writing VBA code?

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.

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

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

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)

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.

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.

Advanced Excels With EPPlus

23 May 2018 by yuvalsol

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

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

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

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

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.

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

Automate multiple Excel instances

25 Nov 2016 by JamesFaix

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

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

Automating deployment for MS Access Application

30 Jun 2016 by Mani Murthy

Using .Net application to automate the MS-Access Application

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.

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

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

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

VSTO Excel and Word Add-In C#

29 Jun 2015 by syed shanu

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

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.

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.

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"

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

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

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.

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

Introduction to Office 365 - Administration Center

25 Nov 2013 by vivekthangaswamy

This is an introduction to Office 365 (Administration center)

Office

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

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

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.

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

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.

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

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.

PHP Web Service WSDL Generator / SOAP Server (Document/Literal)

7 Feb 2013 by LyndonL37

Generates the required WSDL file and SOAP server for receiving data from InfoPath (Document/Literal format).

Outlook add-in using VC++ ATL/COM

5 Feb 2013 by Gokulnath007

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

Microsoft Access Application Development Guidelines

15 Jan 2013 by Marco Sorich

Some guidelines for developing better MS Access solutions.

Querying Database with Microsoft Excel

2 Jan 2013 by Jacques Bach

An easy way to deliver data with MS Excel

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.

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.

Microsoft Office Version Detector

8 Nov 2012 by aalvarez13

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

RefEdit Emulation for .NET

27 Oct 2012 by pablleaf

A simple implementation of a ref edit control for .NET

PowerPoint timer (addin)

27 Oct 2012 by hevesir

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

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

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

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

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.

Outlook 2010 Add-in Custom Classification and Attribution of Emails

21 Mar 2012 by Scott Traube

Outlook 2010 Classification and Attribution of emails.

Windows

Office

Outlook 2007 Calendar Preview

20 Mar 2012 by Ron Levy

A form region with a calendar preview for outlook 2007

Office

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

Word and Excel Documents View in IFrame using TreeView control

29 Jan 2012 by rish_wins

Office Documents View using TreeView

Office

VBE CreateToolWindow

5 Jan 2012 by Sam Gerené

Create a custom dockable window in the VBA editor.

Import Data from Excel into SQL Server Using SSIS

16 Dec 2011 by Keshav Singh

In this video article

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

Add Random Quotes in your Outlook Email Signature

29 Nov 2011 by Md. Marufuzzaman

Add random quotes in your Outlook email signature

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

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.

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.

How to Add a Menu Item in Microsoft Office Word 7/10 Application Context Menu

28 Aug 2011 by Md. Marufuzzaman

How to add a menu item in Microsoft Office Word 7/10 application context menu

Outlook 2007 Add-in Using Microsoft Visual C#.NET- Part 2

26 Aug 2011 by Md. Marufuzzaman

How we can communicate with the Microsoft Office Outlook using “Microsoft.Office.Interop.Outlook” delegate & event.

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.

Office 2010 Button

29 May 2011 by VallarasuS

This article describes how to extend a system button to achieve the Office 2010 button look and feel.

WPF Track Changes Viewer

18 May 2011 by Wajihuddin Khan

Compare two text strings and show them in Word like track changes format

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

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.

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.

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

VBA Composite Control Object Model

25 Feb 2011 by Joel C Graff

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

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

Database to Excel Spreadsheet

6 Jan 2011 by rwg

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

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

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.

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.

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.

A Serious Outlook Style Navigation Pane Control

15 Nov 2010 by HawVie

A quality rendered Outlook style navigation pane control

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

The Four Steps of Programming

18 Oct 2010 by John Paul Walker

How to think like a programmer

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

How to Display Nested List using SharePoint

21 Jul 2010 by RAshmiBhimani

Nested list using SharePoint designer

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.

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.

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

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

Manipulate Docx with C# without Microsoft Word installed with OpenXML SDK

15 Jun 2010 by ricmrodrigues

Use C# and the OpenXML SDK to manipulate docx without MSO.

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

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.

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

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

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

Visio Add-On Getting Started

29 Mar 2010 by Krasnikov, Eugene