Click here to Skip to main content
15,867,330 members
Everything / Productivity Apps and Services / Microsoft Office

Microsoft Office

Office

Great Reads

by yuvalsol
Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
by bollwerkj
This article shows you how I got Excel to work using C++/CLI in a Windows Forms Application
by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
by The Ultimate Toolbox
The Ultimate Toolbox supports Office XP, Office 2003, and Classic application skins

Latest Articles

by Erik Drent
A simple POCO mapper for EPPlus
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
by ToughDev
How to convert OFT to .NET Windows Form in VS
by ChrisK23
A method to automate Chrome (based) browsers using VBA

All Articles

Sort by Score

Microsoft Office 

7 Jul 2013 by Behrooz Bahrameh
This tip describes how to read Excel files and make an array of objects from Excel.
20 Feb 2014 by PallavSingh
Converting data column (contains OLE db image binary Format) to image file (.jpg)
16 Jan 2016 by Glenn Lloyd
This is an alternative for "A Simple List Class for VBA Projects"
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.
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
17 Jun 2011 by VallarasuS
Here is how you can achieve Gradients used in Office 2010 Buttons with a glow at the bottom.
19 Jul 2012 by pramod.hegde
Merge slides from multiple presentations to one at a desired position
12 Jan 2015 by Balakrishnan Dhinakaran
Add email from Microsoft Outlook to SharePoint list using simple macro, JavaScript
19 May 2015 by algor-AG
VBA: Excel / Word programmatically save document as PDF encrypted / password protected.
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
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.
6 Jun 2012 by Scott Traube
Microsoft Lync auto dial and auto passcode.
14 Feb 2014 by PopeDarren
Update Rules With Exception on Reply and Forward
17 Jan 2015 by Liju Sankar
Read Loud Email Sender and Subject as soon as you received an email in OUTLOOK
14 Dec 2015 by bradyguy
Don't send your mail out using the wrong account
25 Oct 2016 by B. Clay Shannon
An as-simple-as-possible real-world example of creating a pivot table using Excel Interop (C#)
16 Mar 2012 by Sachin Chandanshive
Read / Write data from CSV to Excel
13 Aug 2012 by Sachin Chandanshive
Addin Containg Useful Macros & Easily Accessible From Ribbon Menu
31 Jan 2013 by Mike Rosen
Export OLEObject (Word Document) to Word Document.
28 Nov 2014 by ehab_nour
Processing SAP generated Excel file as a report to get some information
22 Aug 2014 by brpulsani
How to create folders using data from Excel file
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.
12 Nov 2015 by B. Clay Shannon
How to Auto-Widen Excel Columns but then Override Over-long Columns, Shortening them
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.
17 Aug 2017 by Dennis Wu CA
A demo that generates a simple Excel spreadsheet with subscripts and superscripts
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
15 Apr 2012 by pramod.hegde
Convert *.potx file to *.pptx file.
1 Nov 2012 by Pasan Eeriyagama
This article focuses on a Very simple and Robust way to export Data to EXCEL
3 Nov 2012 by Sarvesh Kushwaha
Export Excel to SQL database table (Sample Code)
1 Jul 2013 by KumarM.NET
How to copy data from all tables in Access 2003.
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.
6 Feb 2014 by Ted D Wagner
Using JQuery to modify a list anchor tag to open in a new window.
6 Mar 2014 by bradyguy
Outlook 2013 does not advance the current time in the calendar view; here is a hack fix.
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.
20 Dec 2015 by The Purple
Create Libre/Open Office Calc documents, reports on Python
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
2 Apr 2021 by Joan M
How to be able to launch office apps that refuse to start giving the 0xc0000142 error
5 Jun 2011 by RedDk
Ever try to use the Adobe .pdf references for scripting and VBScript? This is a reference viewing tweak.
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...
18 Jan 2012 by Jepy
Replace the last 3 blocks of code with:String.Format("{0:x}", value)
7 Apr 2013 by Som Shekhar
Rename attachments before sending any email
30 May 2013 by Fazal Abu
Learn how to create reports in Microsoft Dynamics CRM in this tutorial
13 Sep 2013 by Joan M
How to remove black squares that replace numbers in titles on Word
4 Jun 2014 by Joan M
Avoiding problems when XLIST is not supported in your mail server
21 May 2015 by Alexey Shtykov
Convert column numbers to range letters and add comments
14 Nov 2015 by B. Clay Shannon
Set the cell and font colors to an Excel Range in C# in three lines of code
3 Jul 2020 by Deepthi Viswanathan Nair
This tip explains how to change the owner of the PowerApp in Office 365
3 Nov 2021 by ChrisK23
A method to automate Chrome (based) browsers using VBA
29 Jul 2014 by dietmar paul schoder
Read rows and cells from an xlsx-file: quick, dirty, effective.
15 Apr 2012 by pramod.hegde
ASP.NET GridView to Excel conversion.
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#.
15 Nov 2013 by Mike Winiberg
GOTCHAs and tips useful when migrating a complex Access JET application to SQL Server 2012
16 Dec 2013 by Stefan Huy
For those who badly miss a .NET like List in VBA
11 Jun 2014 by Kees van Spelde
How to extract embedded files from Microsoft Office documents
13 Nov 2013 by Debopam Pal
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.
12 Nov 2015 by B. Clay Shannon
Hiding Excel Ranges (span of rows and columns) using Excel Interop (C#)
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).
15 Jan 2012 by Robby Tendean
ExcelLibrary implementation sample to convert DataSet to Excel file in VB.NET
16 Dec 2014 by B. Clay Shannon
Replace words in .docx files using the DocX Library
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
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.
16 Jan 2012 by Erion Pici
Generating automatized PDF reports based on Docx templates and Business-Logic XML-serialized data
28 May 2015 by koolprasad2003
This tip explains how to use Word Automation using OpenXML and C# without Word Interop.
10 Aug 2015 by E.F. Nijboer
ExcelDataReaderHelper: Functionality similar to LinqToExcel using the ExcelDataReader package
18 Dec 2013 by Nanda Kumar Chintam
Demonstration of Excel manipulations using C#
21 Apr 2012 by pramod.hegde
Create dynamic content controls at run-time.
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
28 Sep 2013 by Kumar Kisalaya
Basic DocX editing in C# without using OpenXML or Office Interop
3 Jan 2014 by Maciej Los
This tip shows how to get data from multiple workbooks using one OledbConnection.
3 Oct 2014 by Gautham Prabhu K
Copying entire row within Excel sheet using VBA in Microsoft Office 2010 and higher
5 Nov 2015 by cwfong
Get Excel cell values as string
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#
29 Sep 2015 by HP2M
This tip covers handling two Excel lists using Interop.
24 Dec 2010 by Mike Baldini
The following code filters the specified database
6 Mar 2015 by Darkencrow
A multi-drawer style collapsable UI container
22 Feb 2015 by Soufiane Rabhi
Communication between .NET and other programming languages
24 May 2010 by Patrick Kalkman
Use the tool "After the Deadline" to improve your spelling and grammar
3 Dec 2013 by LazyCoder0
This tip describes how to generate Excel charts from data in .NET applications using Office Automation.
12 Jan 2016 by Tim Cadenbach
Edit, Run and Develop JS Code directly within JavaScript
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...
26 Aug 2009 by Henry Minute
Never code whilst holding scissors. That is not what is meantby the 'cut' in cut and paste.
2 Mar 2015 by Shibasis Sengupta
Outlook email recipient type type-ahead feature using Listbox
14 May 2015 by NikiGrly
How to develop,deploy and debug a simple Timer job application
14 Nov 2015 by B. Clay Shannon
Adding an image to an Excel spreadsheet
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)
21 Apr 2012 by pramod.hegde
Excel sheet to SQL DB
2 Jan 2015 by vivekthangaswamy
An overview of Microsoft Office 365
27 Jun 2012 by Vinolarium
Sample code for parsing JSON with deep-nested schemas in VBA.
28 Jan 2014 by B. Clay Shannon
How to query Microsoft Access tables
8 Mar 2020 by NewPast
Excel, Pure VBA Macro: Molecular Weight/Molecular Mass Calculator
16 Jan 2012 by Robby Tendean
A tool for viewing Microsoft Excel BIFF8 binary format
8 Apr 2012 by Ozeliltd
SMS tools for business.
13 Jul 2016 by Jerry Burch
Quickly create a spreadsheet from Datatable using Interop and the Clipboard
16 Jul 2016 by Joan M
How to modify the web page that configures your mail signature.