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

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

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.

Programmatically Adding Table of content with title in MS-Word C#

20 Apr 2015 by Mario Z

Hi, try this:var application = new Application();var document = application.Documents.Open(FileName: @"C:\Sample In.docx");var tocRange = document.Range(0, 0);var toc = document.TablesOfContents.Add( Range: tocRange, UseHeadingStyles: true);toc.Update();var...

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

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)

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"

Justin‘s VSTO Knowledge Base: 01, First VSTO Application

7 May 2011 by izualx

Justin‘s VSTO Knowledge Base: 01, First VSTO Application

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

XSLT to transform Excel XML worksheet to "named" nodes

10 Jun 2014 by Anamera

This XSLT will output an Excel worksheet containing a CSV type of record collection in a more usable XML format.

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"

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

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.

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.

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

Merge Presentations

19 Jul 2012 by pramod.hegde

Merge slides from multiple presentations to one at a desired position

Office-Automation

Office

Dev

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

Reading Outlook Emails / Contents using JavaScript

12 Jan 2015 by Balakrishnan Dhinakaran

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

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 Formular Symbol Help

4 Mar 2015 by ZurdoDev

It's I10, as in column I row 10.In fact if you go into edit mode in a cell like that you should get highlights around each of the cells that are involved and you should see all 3.The formula is subtracting cell I10 from cell C10 and then subtracting that from cell F10.

Office

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.

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

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

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.

upload & Read an .doc file in web page

7 May 2011 by IncredibleRam

hello there following links may help you sort out your problem.Convert Office Word Document to HTML and display it in browser in ASP.NetFile Denial - Let authorized users download files from your site - and keep unauthorized users out!Protect Your Downloadable Files Using HTTP...

Microsoft Lync - Dial and Passcode Automation

6 Jun 2012 by Scott Traube

Microsoft Lync auto dial and auto passcode.

Office

PowerPoint timer (addin)

27 Oct 2012 by hevesir

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

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

14 Feb 2014 by PopeDarren

Update Rules With Exception on Reply and Forward

VB6

Office

Visual basic 6 - Export to Excel 2010/2013 not working

11 Apr 2014 by Maciej Los

You did not provide enough information about your issue, especially about the reason of that behaviour. You did not provide your code too. Well, we can only guess...First of all, i'd suggest to read about Using early binding and late binding in Automation[^], Early and Late Binding (Visual...

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.

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

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

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

Outlook Automation

19 Jun 2009 by Rolf_atSC

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

open a word doc

14 Mar 2010 by Richard MacCutchan

Office.Interop...

C#3.0

Office

Content Controls and Open XML 2.0 SDK

23 Jul 2010 by atverma

In this blog, I’ll focus on Content Controls and Open XML 2.0 SDK from the experience I gained in the last 2 months.

VBA Composite Control Object Model

25 Feb 2011 by Joel C Graff

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

word automation problem in c#.

9 Mar 2011 by Sergey Alexandrovich Kryukov

As you're new to the topic, I'm not sure you need exactly Word automation, which is only one approach to Word-related programming. Better start from this point: http://msdn.microsoft.com/en-us/library/ee342218.aspx[^].—SA

MS-Word

Office

Utility to Generate Word Documents from Templates Using Visual Studio 2010 and Open XML 2.0 SDK - Part 4

24 Jan 2012 by atverma

Utility to Generate Word Documents from Templates Using Visual Studio 2010 and Open XML 2.0 SDK - Part 4

Import Export Wizard

16 Mar 2012 by Sachin Chandanshive

Read / Write data from CSV to Excel

import MS Excel to datatable

30 Apr 2012 by Pandvi

Try the following codes: do { rowIndex = 2 + index; row = dt.NewRow(); row[0] = Convert.ToString(((Microsoft.Office.Interop.Excel.Range)workSheet.Cells[rowIndex, 1]).Value2); row[1] =...

.NET

Office

Software Banner c# like office

8 May 2012 by OriginalGriff

If you mean the borderless form that appears when you start them, and stays until they are fully loaded, they are called Splash Screens, and a simple google will get you loads of ways: https://www.google.co.uk/search?sourceid=chrome&ie=UTF-8&q=splash+screen+c%23[^]The first two links are here,...

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

910801 - how to have a help assistant like the one in office?

22 Oct 2012 by Akinmade Bond

Microsoft Agent says:Beginning with Windows® 7, Microsoft Agent will not be included or supported in future versions of the Microsoft Windows operating system. We encourage Microsoft Agent application developers and redistributors to evaluate their activities in light of this decision.But if...

Office

MS Access to MS Word

31 Jan 2013 by Mike Rosen

Export OLEObject (Word Document) to Word Document.

Office

Open XML reading XML

14 Feb 2013 by Sergey Alexandrovich Kryukov

To start with, please see my past answers. Some part of them is devote to the cases when you want to work with Office documents directly. I did not do it (why?), but I know where to get some code. Please see:Convert Office-Documents to PDF without interop[^],Hi how can i display word file in...

XML

C#4.0

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

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

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

How can a server get remote access to office installed on the other machine?

29 May 2015 by Richard Deeming

Considerations for server-side Automation of Office[^]Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office...

Javascript

Office

Microsoft

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.

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

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.

Excel Interop, Subscripts and Superscripts

17 Aug 2017 by Dennis Wu CA

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

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

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.

Integrating SharePoint with OutSystems

22 Aug 2018 by Chris A. Johnson

By Chris Johnson @ kolaberate.com Integrating SharePoint with Out Systems Introduction This article is about accessing your Office 365 SharePoint application via the SharePoint API to fetch or update its resources specifically using REST API services from OutSystems.

How to make dynamic drop down list?

17 Jun 2019 by CHill60

This is simply achieved using VLOOKUP. For example in cell B2 of your empty sheet put the formula =VLOOKUP($A2,Workers!$A:$C, 2, 0) and in cell C2 of your empty sheet put the formula =VLOOKUP($A2,Workers!$A:$C, 3, 0) Note that it is better (quicker) to use INDEX and MATCH[^] if you have a lot...

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

Outlook vcs format

10 Jan 2010 by Rod Kemp

The easiest way to get the format for a meeting request is to create the meeting on Outlook but don't send it, instead save it as an ics file and this will give you the format.As you can see it is a bit more complex than an simple appointment also you may have to experiment a bit especially...

Office

OfficeQuery using XLINQ

17 Jan 2010 by Danny Hauptman

Using XLINQ to search through a Word2007 zipped document.

How can I display two or more icons in systray using C# and WPF(or WinForms) like Office 2010 beta's "Send a smile/frown"?

11 Mar 2010 by Vineeth P Joseph

Its not very difficult to add multiple Icons in system tray using c#.We can also handle the events . First of all you create two(or more) NotifyIcon in your application.private System.Windows.Forms.NotifyIcon NotifyIcon1;private System.Windows.Forms.NotifyIcon NotifyIcon2;After that...

Office

WinForms

WPF

C#, Visual Studio Express 2008, OpenXML SDK, and multipage word document

9 Jun 2010 by #realJSOP

Why don't you create a master copy of the (empty?) table, clone it when you need to, and add the cloned table to the document. Not knowing exactly why this is a problem, I can't suggest anything better.You could also just create a class that builds the table for you with the data you...

.NET

.NET3.5

Office

Finding the index of recent files in Office 2007? Where are they stored?

18 Sep 2010 by LloydA111

http://www.gmayor.com/clear_recently_used_file_list.htm[^]

Office

general

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.

How to use Infopath 2007 with VS 2008

18 Jan 2011 by Orcun Iyigun

You can deploy forms server without deploying sharepointhttp://office.microsoft.com/en-us/formsserver/FX100490391033.aspx[^]also that link might help;http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_23064445.html[^]

Microsoft office document imaging 12.0 library with c# (VS 2008)

15 Feb 2011 by Alok d gr8

Hello,I am trying to convert a jpeg image to text using OCR library with the source code provided on below linkConverting Images to Text using Office 2007 OCR, OpenXML and Speech Recognition[^]But i get the below annoying exception every time i do...

Office

How can I format an MS Excel sheet to an image and save it to server

25 Feb 2011 by Espen Harlinn

Excel is a desktop application - using it like this is usually not a bright idea since IIS runs as a windows service - you usually don't have access to the windows station[^].Use something like EPPLUS[^] to access data from the spreadsheet. You can use iTextSharp[^] to create a pdf, or a...

Open XML how to add custom data to a paragraph

1 Apr 2011 by pankajupadhyay29

check following links hope it will work for you--Using Custom XML Part as a data store[^]A discussion on msdn on same problem[^]

.NET

MS-Word

Office

Formatting excel columns already formatted as text (in c++)?

14 Apr 2011 by Richard MacCutchan

saRet.Create...

Office

MFC

Formatting excel columns already formatted as text (in c++)?

14 Apr 2011 by Espen Harlinn

You might find this interesting:ExcelFormat Library[^]RegardsEspen Harlinn

Office

MFC

What is purpose of Visual Studio Office in .NET

25 Apr 2011 by Abhinav S

See http://msdn.microsoft.com/en-us/library/3295w01c%28v=vs.80%29.aspx[^]http://msdn.microsoft.com/en-us/library/8553caee%28v=vs.80%29.aspx[^]

Visual-Studio

Office

VS2008

What is purpose of Visual Studio Office in .NET

26 Apr 2011 by Nish Nishant

I reckon your question is why do we have project wizards for Office based projects in Visual Studio. If so, their primary use is to create add-ins for Word, Excel, Powerpoint and other Office applications. You could do that without the wizards too, but this way is easier.

Visual-Studio

Office

VS2008

upload & Read an .doc file in web page

7 May 2011 by Wonde Tadesse

To be honest Microsoft Office automation is not recommended. Read Recommendation for sever side automation of Office[^].In order to view MS word online then you may have to go with third part controls. Like Telerik Editor control.[^]. It just like monster resume upload control. Or use google...

Not able to use access 97

7 Jun 2011 by OriginalGriff

Your first port of call should be Google: It found this as the top site when fed your error message:http://support.microsoft.com/kb/141373[^]

Office

word automation problem in c#.

26 Jun 2011 by Alimjan Yasin

I used the replacing methods, since I don't know how to save the format of word file ,it is better to analys it at sentences level and replace every single sentences by its translation. one more reason is there is no avaiable solution for that perpouse.

MS-Word

Office

word automation problem in c#.

26 Jun 2011 by Slacker007

Every MS Office product has an object model. A table in a Word document is nothing more than an object of a class. Google the object model for a Word document and you will see a lot of hits for this...I don't know all of them off the top of my head. I usually do Office Automation through VBA...

MS-Word

Office

[Solved] Generating Word Document with OpenXML SDK... document opens in compatibility mode?

9 Nov 2011 by Trajan6

Just a little bit late, but I wouldn't do it with an external dependency like an XML-File.My suggestion is:private static void AddSettingsToMainDocumentPart(MainDocumentPart part) { DocumentSettingsPart settingsPart = part.AddNewPart(); settingsPart.Settings = new Settings( ...

XML

MS-Word

Office

Utility to Generate Word Documents from Templates Using Visual Studio 2010 and Open XML 2.0 SDK – Part 2 (Samples Updated)

12 Jan 2012 by atverma

This is the second post of this series.

To extract cell values from excel file

19 Jan 2012 by Dagma D

I want the code that will extract the cell values of an excel file???Plz help!!!

Office

How to Read Comments in an Excel File using OpenXML approach

25 Jan 2012 by YKK Reddy

Hi,i solved using the below mentioned code.SpreadsheetDocument spreadSheetDocument = SpreadsheetDocument.Open(/* Excel File Name */, true);WorkbookPart workBookPart = spreadSheetDocument.WorkbookPart;List lstComments = new List();foreach (WorksheetPart sheet in...

Does .doc metadata contain Mac Address or any unique id?

31 Jan 2012 by Sergey Alexandrovich Kryukov

Strange idea, but looks pretty disturbing. Please see my comment to the question.Let's see if it is possible to investigate.The *.docx document format is Open Office XML, it is open and standardized under ECMA-376 and ISO/IEC 29500, please see http://en.wikipedia.org/wiki/Docx[^]....

Office

is there a problem if i uninstall office 2010 and then install office 2003 instead?

8 Apr 2012 by Brainy Girl

hi,i have Microsoft 2010 installed on my win7 pc, and i want to remove it and install Microsoft 2003 instead.can this operation make problems to me or not.

Office

Create PowerPoint presentation using PowerPoint template

15 Apr 2012 by pramod.hegde

Convert *.potx file to *.pptx file.

Office

import MS Excel to datatable

30 Apr 2012 by Mohamed Mitwalli

Hi , check this linkExcel Data into datatable[^]Best RegardsM.Mitwalli

.NET

Office

Open XML Excel-Create BarChart

23 Aug 2012 by pramod.hegde

ChartSpace object is the main object in chart creation. Chart object and many properties to it are added later point of time.Whenever you are dealing with Office Open Xml please have Open XML SDK 2.0 Productivity Tool installed in your system. Create a chart in excel manually. Open up the...

.NET

Office

chart

How to use Extended MAPI

29 Aug 2012 by Joan M

This is due to the "new" security concerns of apps sending mails without user concern.In order to send e-mails I've tried to use that extended API, but at the end this requires you to have a mail client installed and the extended api will be focused on that client so the day you'll change...

Office