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 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)
by RB Starkey
How to create a tree-view control using an Access table and form.
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)
by ColinBashBash
Automate Compile Code, Compact/Repair, and Make MDE for Access.
by Saravanan20152
Access UserProfile Services in Infopath 2007.
by Soptik Dutta
Activate RMS or Information Rights Management for your Sharepoint Online site
by Md. Marufuzzaman
Add random quotes in your Outlook email signature
by hamityildirim
Add-in - add-on programming and an example for Outlook add-in regions, views, rules, and reports.
by Abey Thomas
This article is about the details of adding an image to a Word document programmatically.
by Anton Ponomarev
By following steps outlined in this article, you will be able to get Report Viewer to generate reports in Microsoft Word formats (DOC, RTF, WordprocessingML, and OOXML) when working in the local mode.
by Anton Ponomarev
By following the steps outlined in this article, you will be able to get Report Viewer to generate reports in Microsoft Word formats (DOC, RTF, WordprocessingML, and OOXML) when working in the local mode.
by Abey Thomas
This is an article about adding footnotes to a Word document (MS Office 2007) programmatically.
by Lukas Neumann
An example of undocumented integration into the user interface of Microsoft Office applications.
by hamityildirim
AddIn - AddOn programming and An Example for Outlook AddIn Regions, Views, Rules and Reports
by yuvalsol
Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
by SreeniTheGinie
Code to open the "New Message" window in Outlook and attach items
by LukasX2
Introduction to a WPF powered help files engine with the option of generating help content from a Word document
by JamesFaix
.NET library to access to any running instance of Excel.
by Mani Murthy
Using .Net application to automate the MS-Access Application
by Govardhana Reddy
This article will help demonstrate how to automate and get content from an MS Excel document.
by Govardhana Reddy
This article will demonstrate how to automate and get content from an MS PowerPoint presentation.
by Srinivas-Miriyala
This tool move the previously-published infopath form templates to a new location.
by PuneWala
Introduction to the OpenXML format.
by ggraham412
An example of how to use Open Office and Ghostscript to convert supported formats to PDF using Open Office and merge them using Ghostscript
by Helmut Obertanner
An article about how to access Extended MAPI properties, fields and methods from your .NET applications.
by paolo guccini
How to use the Microsoft Interop/Automation to implement parallel research of a Microsoft Office file password.
by Rama Krishna Vavilala
This article uses Visual Studio Tools for Office to build a Word Document Template that can be used to post messages to a message board.
by Patrick.Hartnett
Add a filter to the Pivot Table where multiple items can be selected.
by Won Dong
To utilize cloud service as an anonymous desktop environment in Amazon S3 and EC2 Windows instances
by keesp
A COM Newbie's Journey Through DLL Hell
by Microsoft Office Business Applications
Composite applications offer a long-sought-after business nirvana whereby empowered technical business users can stitch together componentized business capabilities. In this article, we'll discuss fundamentals and advantages of using composite applications for today's business challenges.
by Nioosha Kashani
Describes how to connect two SharePoint custom Web Parts using the Visual Studio Extension for Windows SharePoint Services.
by brucedkyle
In this lab, you use drag and drop functionality to add controls to a Word 2007 template, build logic into those controls, protect the content of the controls from editing and deleting, and add simple data binding to a local database. Then, you’ll add a Fluent Ribbon to Word to browse the data.
by Manoj K Bhoir
ContextMenuStrip Control with Microsoft Office like Visual Style using VB.NET
by StewBob
This article gives a method for using Excel VBA to convert discrete data points into a histogram.
by Danie lCampos
This article will show how to integrate the Office 2007 OCR engine with custom applications and use OpenXML and Speech Recognition
by Helmut Obertanner
In this article, we will create a form region that shows all contacts within the same category.
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
by Jeremy Hutchinson
Create an add-in that automatically marks items as read when they are deleted in Outlook 2010.
by Turay Melo
This is an alternative for "Creating an Outlook 2010 Add-In"
by rudigrobler
Recreate the Outlook Calendar using WPF.
by Maciej Zbrzezny
A simple “getting started” article that shows the basis of creation of a Word 2007 (docx) document using the Open XML Format SDK 2.0 CTP.
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
by Scott Parkes
Providing custom context sensitive help for VSTO add-in Ribbon controls.
by byapparov
An article on how to use text template with replacement variables in VBA
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.
by Taylor Kobani
A simple example of how to classify data using genetic algorithm and VB.Net
by mc_kappa
Using this simple, yet elegant and powerful code, you can provide to your users efficient Office document merging; simply exploiting XML technology and basic string manipulation.
by rwg
Select data from SQL databases into Excel spreadsheet, with headings and formatting
by George Zabanah
This article demonstrates the amazing transformation power of the DataSet with agnostic XML schemas, XML, and Excel Read/Write (all with colourful XML rendering using XmlBrowser).
by rkapl
Excel based solution for modifying Database data
by Ganesh_IT
This article outlines the issue faced by most developers when it comes to dealing with Excel objects. Here, you will find code that will help in getting rid of Excel objects from the memory once they are no longer required.
by Barath Balachandran
A method to send future updates/upgrades of your Office 2003 solutions to your end user seamlessly without any user intervention.
by walt_bael
A small code sampe for determining if Excel is in edit mode.
by Viktor Hamori
In this article, one can find a possible solution how to check or to be notified if the Excel Application is in Edit mode
by ihsanps
Developing a microsoft project application using asp.net
by Paul Dedyul'kin
How to compile and debug 2003 VSTO Addins under Vista + 2007 Office
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.
by Dirk_Strauss
DevExpress Document Server – Automate Office Without Microsoft Office Automation
by Tariq Younas
Article describes how to make backup and recovery plan of MOSS 2007.
by Zabiullah Sheik Ismail
An article on how to display charts in SharePoint using Excel Services
by Dave Elliott
An article on how to generate source code as well as populate Excel Spreadsheets.
by Mohamed Zaki
This custom UI Action for SharePoint extends the lists action menu to allow users to zip document library items and download all of them with or without version.
by Javed Akhtar Ansari
This article demostrates how to do drag and drop Outlook attachments on a tree view node and describes the private Clipboard format of Outlook.
by Matt (D) Wilson
An alternative take on describing the VOLE Automation library
by BillJam11
C# classes that upload an EML into a System.Net.Mail.MailMessage
by Rudra Sankar
Create & edit Microsoft Word document from Windows application Form by using C#
by mc_kappa
Describes the theory of how software development can be simplified even for mission critical applications
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.
by Syed Umar Anis
ExcelXMLExport is a Microsoft Excel 2010 / 2013 Add-in that generates XML data from Excel sheet.
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.
by Jose Segarra
A front-end library to create Excel files, including formatting and styling cells
by simonp_ca
Use Excel worksheet's cells as pixels to render real image (for fun and experiment)
by bradyguy
An end to end view of how to integrate Jira REST API's with Excel.
by rkapl
DBFuncs is an Excel-addin for database querying by user defined functions
by Ming_Lu
Exporting multiple tables in a DataSet to multiple sheets in an Excel file
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
by Dr. Song Li
This article presents an example to export tabular data in PDF format through the web.
by Andriy Protskiv
ReportExporters is a library for easy exporting of a DataGridView to Excel/PDF/image file types by using Reporting Services report generation.
by Rolf Jaeger
This article demonstrates how to automate Excel using VS2008 rather than VSTO or VBA
by Rashutosh Paul
How to fetch data from Microsoft Excel using SQL
by huongwin
An article about how to fix Local Disk (Q) added by Office 2010 Beta
by Dan Mos
An article on exporting any datagridview contents to a Excel file, with theme and formatting or a *.CSV (no theme)
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.
by Praveen Bonakurthi
How to generate Word documents from Word templates using the Word 2007 XML format.
by Alessandro Del Sole
An alternative way to create XPS documents via Visual Basic code and VSTO assemblies.
by Simon Bonello
A Google map WebPart.
by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
by Amr M. K.
Word Document Automation
by batra.vinita@gmail.com
Proof of concept on how the application specific (small/large amount of) data can be stored in ms word document as well as how it can be made hidden from end user’s eye.
by logicchild
An article that explains how a Windows Form can host an electronic form.
by Md. Marufuzzaman
How to add a menu item in Microsoft Office Word 7/10 application context menu
by David Meng
Introduces a way to create a key column in a SharePoint list.
by Joao Tito Livio
Creating a simpleTable with fields in an Access Database using ADOX and JET SQL
by hevesir
A simple way to create your own Google map from several locations.
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.
by RAshmiBhimani
Nested list using SharePoint designer
by Ri Xu
This post shows you how to import and export Excel XLSX in Go language.
by gndzero
A fast way to display the details of all PSTs currently loaded into Outlook
by T.Ashraf
How to pass value from Ajax Enabled Base User Control to Client User Control and to the Parent aspx page
by Dmytro Skrypnyk
Using ADO for Access to XLS and XLSX files in C++
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.
by Bethany_Sanders
How to connect EWS with gSOAP to send, delete, and retrieve emails.
by Serdar Altug
IBAN verification algorithm in C# and used in Excel UDF and Word SmartTag.
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.
by Keshav Singh
In this video article
by Bruno Terkaly
This article demonstrates using the dtSearch Engine as a solution for searching such data.
by Rajat-Indiandotnet
Live Poll – Analysis using Microsoft Form, Microsoft Flow and Power BI Live
by kent_plaza
Update the Infopath Managed Data Connection's GUID without open file
by Tariq Younas
http://dotnethotshots.blogspot.com
by vivekthangaswamy
This is an introduction to Office 365 (Administration center)
by Aspose
Mail Merges in the Cloud: using Aspose.Words for Cloud
by FrankNight
This is an Add-in for Microsoft Access that allows writing and execution of SQL statements with transaction control
by ricmrodrigues
Use C# and the OpenXML SDK to manipulate docx without MSO.
by Rajat-Indiandotnet
How to do sentiment analysis using few clicks and see live graphical representation using Power BI live feed
by Marco Sorich
Some guidelines for developing better MS Access solutions.
by aalvarez13
This is an alternative for "Microsoft Office Version Detector".
by Mohamed Faizal
This article discusses Lotus Notes data migration approach and how to use Quest Notes to SharePoint Migrator tool.
by Won Dong
Process and toolkit to migrate data to Microsoft SQL Data Services
by emadns
Notify your contacts with this Outlook 2007 add-in.
by Dietmar Kurok
Showing People grouped by departments in an own style (XSLT) and without limits in count of results and paging. Only intensively using build-in Webparts.
by Akrumooz
This feature enables a MOSS user to change his/her password when forms based authentication is enabled
by naveedullah
This article describes the concepts and steps needed to create a multilingual publishing site in MOSS
by Yasser Daheek
A very productive, easy to use tool to edit your Sql Queries against MS Access Databases
by Naren Neelamegam
A simple guide to automate MS Word and MS Excel using C++.
by MJ Ferdous
How to customize New or Edit Form (NewForm.aspx or EditForm.aspx). How to make multiple custom edit form for different item status. How to link those Forms with the list item by creating custom link column
by David Meng
To implement PageAsyncTask for web part rendering in parallel instead of RegisterWorkItem.
by RalphHightower
NASA Space Shuttle Mission Schedule reads Excel files published by NASA containing the television schedule for Space Shuttle missions and provides the ability to enter and update the schedule in Outlook’s Calendar.
by code-frog
A simple guide meant to take the reader through a series of questions that will help them plan for and manage their business network.
by Turan Kent
Button
by VallarasuS
This article describes how to extend a system button to achieve the Office 2010 button look and feel.
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 Mohamed Faizal
Microsoft Office SharePoint Server 2007 is equipped with six key functional areas of features. These areas are 1.) Collaboration, 2.) Portal, 3.) Enterprise Search, 4.) Enterprise Content Management, 5.) Business Process and Forms, and 6.) Business Intelligence
by Gautam Sharma
This article demonstrate, how OWC and AJAX can be used to store spreadsheet content as XML data into database.This XML in turns rendered as spreadsheet in OWC control from database source.
by Danny Hauptman
Using XLINQ to search through a Word2007 zipped document.
by Md. Marufuzzaman
How we can communicate with the Microsoft Office Outlook using “Microsoft.Office.Interop.Outlook” delegate & event.
by Ron Levy
A form region with a calendar preview for outlook 2007
by Scott Traube
Outlook 2010 Classification and Attribution of emails.
by TheCodeKing
An Outlook add-in written in .NET which allows blocked file attachments to be unlocked.
by Gokulnath007
To get instant control over Outlook and various operations of outlook.
by Matias Szulman
Multiple message attachment download is possible, with VBA
by Rolf_atSC
This article shows how to automate Outlook using VS2008 rather than VSTO or VBA
by David Ewen
How to drag and drop multiple Outlook mail messages or message attachments to a C# WinForm.
by LyndonL37
Generates the required WSDL file and SOAP server for receiving data from InfoPath (Document/Literal format).
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
by hevesir
Timer clock for PowerPoint 2007 (PPT add-in).
by psonek
Simple printing solution based on OpenOffice suite
by tartanmonkey
Printing documents using Microsoft Word and C#
by Simon Bonello
How to programmatically create a browser enabled InfoPath form.
by Ravi Raj
While working with VSTO 2005, I needed to programmatically forward Outlook 2007 email messages. By default, the inline images in the selected email will be added as attachments to the forwarding email. This sample code will help you to programmatically forward email messages with inline images.
by Jimmy Zhang
Learn to take advantage of VTD-XML's stateless XPath capability to achieve unmatched efficiency and flexibility
by Tariq Younas
Microsoft Project Server->Project Web Access Integration with Office Outlook
by Jacques Bach
An easy way to deliver data with MS Excel
by David Ewen
How to read an Outlook msg file in C# without the Outlook object model
by Abdul Quader Mamun
How to read an online Excel file and manage it in Microsoft SQL database
by pablleaf
A simple implementation of a ref edit control for .NET
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.
by Sergio Romero
A class that generates an XML string as an Excel file
by Randar Puust
This article describes two Excel documents that can be used as a Product Backlog and Sprint Backlog for the Scrum Framework
by craigd
Remove Binary Serialization to solve Medium Trust problem; index OpenXML document formats in ASP.NET/C# free search engine
by Midhunlal G
This article describes a method to search huge excel sheet using VLOOKUP and to how to change the font and color of data in cells.It also tells how to release office objects from memory.
by Mohamed Faizal
This article describes how to setup and Install SharePoint 2007 (MOSS) server on Vitrual PC
by Mercy Ponnupandy
This article marks the siginificant timelines for SharePoint Product and Technologies.
by Mohamed Faizal
This article provides a sneak peek display of the key features of SharePoint 2010. The detailed announcement would be released in the SharePoint Conference this October
by Marian Dumitrascu
Use DotNetNuke user store and management for SharePoint web applications that use Forms based authentication.
by Sike Mullivan
Web Part for users to drop on their pages for navigation across the site collection.
by Marian Dumitrascu
An alternate way to view Microsoft Reporting Services reports in SharePoint.
by Muhammed Anseer K K
Creating a metro style application with WCF
by Erik Drent
A simple POCO mapper for EPPlus
by Jabeen Begum
Create a timer job using SharePoint App model, CSOM and azure webjobs
by Atanu Banerjee
A composite application is a collection of software assets assembled to provide a business capability. These assets can be deployed independently, enable composition, and leverage specific platform capabilities. Microsoft Office's comprehensive platform for this is Office Business Applications (OBA)
by Six Hat Solutions
Easily Send Emails From Your Microsoft Applications Using VBA and the SendGrid API
by The Ultimate Toolbox
The Ultimate Toolbox supports Office XP, Office 2003, and Classic application skins
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.
by Rahul Singla
A new productive way of producing Office documents with dynamic content substitution.
by David Saelman
Part 1: A method of utilizing Regular Expressions to perform power searches in Microsoft Office Documents using .NET and the Microsoft Office Primary Interop Assemblies
by Imran S Mohamed
This article contains information on how to update a chart in a Word document.
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.
by quakeboy
A way to get upside down text with data from another cell.
by bollwerkj
This article shows you how I got Excel to work using C++/CLI in a Windows Forms Application
by Dungtran
This article describes how to automatically generate Word 2007 documents using .NET 3.0
by Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
by Clifford Nelson
Demonstrates how to use attributes during run time in a serious application to improve maintainability.
by dtSearch Corp.
The article brings together the Microsoft Azure Cloud with dtSearch to enable secure hosting of terabytes of a broad spectrum of data types combined with instant dtSearch search access from nearly any computer or device.
by Drasko Popovic
How to template web parts with Knockout.js framework
by Darryl Bryk
A C# method is discussed for using bookmarks in Microsoft Word templates to automate reports.
by Dracula
Run all rules for all accounts on all messages; also useful as Outlook Rule debug tool.
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.
by Joel C Graff
A method for managing complex, event-driven interactions between controls
by Dracula
VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007
by stc.reseller
How to stay secure by using Excel formulas instead of writing VBA code?
by Sam Gerené
Create a custom dockable window in the VBA editor.
by alex turner
Excel 2007 does not seem to support DBF files, here is a VBScript workaround.
by Cristian Amarie
VBScript for sending IP information to an e-mail address
by Shayan Elhami
Provides a very easy to use library (using Interop, Attributes and Reflection) to work with Excel files in .NET
by Krasnikov, Eugene
Getting Started in Visio Add-On creation (VSL project)
by hackman3vilGuy
See the new Ribbon Designer in Visual Studio 2008 allowing you to graphically create ribbons for your Office add-ins. Add images from the Yahoo Image Search API and analyse the content of your document
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
by rish_wins
Office Documents View using TreeView
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.
by Derek Bartram
A WPF / C# Library for implementing Office 2007 Style Ribbon Interfaces
by Saraf Talukder
A simple to use Color Picker with advanced color palette for WPF Applications with look and feel of Office 2007 color picker
by Wajihuddin Khan
Compare two text strings and show them in Word like track changes format
by David Meng
How does WPSC register Web Parts differing from SharePoint 2003.
by Sam Safonov
The tool is based on XML/XSLT, and allows a user to create a Word report from scratch, namely: construct SQL query, construct a WordML template, generate a document.