Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / productivity / Office

Office

Office

Great Reads

by Lyrix
An article on Excel programming, including Excel operations in C# and VBA
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.
by HawVie
A quality rendered Outlook style navigation pane control
by Md. Marufuzzaman
A simple example of merge document (Microsoft Access 2003)

Latest Articles

by Lyrix
An article on Excel programming, including Excel operations in C# and VBA
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.
by HawVie
A quality rendered Outlook style navigation pane control
by Md. Marufuzzaman
A simple example of merge document (Microsoft Access 2003)

All Articles

Sort by Score

Office 

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