Recent from talks
Nothing was collected or created yet.
Microsoft Office shared tools
View on WikipediaMicrosoft Office shared tools are software components that are included in all Microsoft Office products.
Delve
[edit]
Office Delve allows Microsoft 365 (formerly called Office 365) users to search and manage their emails, meetings, contacts, social networks and documents stored on OneDrive or Sites in Microsoft 365. Delve uses machine learning and artificial intelligence.[1] In April 2015 Microsoft launched a mobile version of Office Delve in the App Store and Google Play for users with a Microsoft 365 subscription.[2] In 2017, Microsoft dropped the Delve app from the Microsoft Store.[3]
Graph
[edit]Microsoft Graph (originally known as Microsoft Chart) is an OLE application deployed by Microsoft Office programs such as Excel and Access to create charts and graphs. The program is available as an OLE application object in Visual Basic. Microsoft Graph supports many different types of charts, but its output is dated. Office 2003 was the last version to use Microsoft Graph for hosting charts inside Office applications as OLE objects. Office 2007 – specifically, Excel 2007 – includes a new integrated charting engine, and the charts are native to the applications. The new engine supports advanced formatting, including 3D rendering, transparencies, and shadows. Chart layouts can also be customized to highlight various trends in the data. Microsoft Graph still exists for compatibility reasons, but the entry points are removed. This product can be used within other products, and is available in the Object menu in the Insert tab in Office Programs. Sold separately in Mac releases.
The first software sold under the name Microsoft Chart was an attempt from Microsoft to compete with the successful Lotus 1-2-3 by adding a companion to Microsoft Multiplan, the company's spreadsheet in the early 1980s. Microsoft Chart shared its box design and two-line menu with Multiplan, and could import Multiplan data. The simple graphs (pies, bars, lines) were drawn on the screen in graphics mode (which was not available on entry level computer models), and could not be printed on some dot matrix devices. The main drawback of Microsoft's solution at the time was the need to exit Multiplan and then load Chart to compose and draw a graph, because MS-DOS was not a multitasking operating system. In the early 1990s, Microsoft Chart was renamed Microsoft Graph.
Query
[edit]Visual Basic for Applications
[edit]WordArt
[edit]
WordArt is a text-styling utility, created by Scott Forstall and Nat Brown (later Apple employees) while interning for Microsoft in 1991.[4] It allows users to create stylized text with various "special effects" such as textures, outlines, and many other manipulations that are not available through the standard font formatting. For example, one can create shadows, rotate, "bend", and "stretch" the shape of the text. WordArt is available in 30 different preset styles in Microsoft Word, however, it is customizable using the tools available on the WordArt toolbar and Drawing toolbar up to Office 2003, or on the WordArt tools tab since Office 2007. It is also available in Excel, Microsoft PowerPoint, and Microsoft Publisher. In Office 2010 and beyond, users can apply formatting effects such as shadow, bevel, glow, gradient glow, and reflection to their text.
In Office 2007, WordArt was given a complete overhaul in Excel and PowerPoint, with new styles, new effects, and the ability to apply WordArt to regular text boxes, and in Word, to body text. The new styles were included in Word 2010, but the presets revamped in Word 2013.

SmartArt
[edit]SmartArt, found under the Insert tab in the ribbon in PowerPoint, Word, Excel, and Outlook, is a new group of editable and formatted diagrams. There are 115 preset SmartArt graphics layout templates in categories such as list, process, cycle, and hierarchy. When an instance of a SmartArt is inserted, a Text Pane appears next to it to guide the user through entering text in the hierarchical levels. Each SmartArt graphic, based on its design, maps the text outline, automatically resized for best fit, onto the graphic. There are a number of "quick styles" for each graphic that apply largely different 3D effects to the graphic, and the graphic's shapes and text can be formatted through shape styles and WordArt styles. In addition, SmartArt graphics change their colors, fonts, and effects to match the document's theme. It was included in Office since 2006 to now.
Discontinued
[edit]Binder
[edit]Microsoft Binder was an application originally included with Microsoft Office 95, 97, and 2000 that allowed users to include different types of OLE 2.0 objects (e.g., documents, spreadsheets, presentations and projects) in one file.[5] Originally a test host for OLE 2.0, it was not widely used, and was discontinued after Office 2000.
The filename extension for Microsoft Binder files was .OBD; the Office Binder template format was .OBT. A Microsoft Office Binder Wizard used the extension .OBZ.
Binder was no longer shipped with Office versions starting from XP.[6] Office XP and Office 2003 comes with an optional Unbind utility that, upon execution, extracts the contents of the Binder document to a directory of the user’s choosing.[7] This utility may be installed either through the Add or Remove Features functionality of Microsoft Office’s installation wizard or online from Microsoft Download Center.[8]
Small Business Tools
[edit]Small Business Customer Manager (SBCM) was an Access-based tool which combined accounting data from most popular accounting software and Outlook contacts and allowed user to track customer profiles and maximize revenue. It integrated seamlessly with Word and Publisher.
Small Business Financial Manager (SBFM) was an Excel-based tool which allowed users to analyze data and create reports and charts based on a created from user's accounting data from popular accounting packages (i.e. QuickBooks). It was first released in 1996 and bundled with Small Business editions of Office 97 or with every Office 2000 suite except Standard. Originally it was created for Microsoft by Timeline Inc. and originally was called Accounting Analysis Pack. It was available in United States, Canada, United Kingdom and Australia.
List of SBFM versions:
- Small Business Financial Manager for Excel for Windows 95 (1.0) (1996)
- Small Business Financial Manager 97 (2.0) (Office 97 Small Business Edition 1.0) (1997)
- Small Business Financial Manager 98 (3.0) (Office 97 Small Business Edition 2.0) (1998); added business comparison, projection reports, charts
- Small Business Financial Manager 2000 (4.0) (Office 2000 Small Business, Professional, Premium, Developer) (1999); added buy vs lease tool separate from What-If analysis)
Direct Mail Manager (DMM) was an-Internet-based tool which allowed businesses to conduct direct mail campaigns by importing address lists from Outlook, Excel, Access etc., verifying address lists by connecting to an Internet Site (ZIP-Station), printing envelopes, postcards and letters and using a mailing service. Originally it was released with Office 97 Small Business Edition 2.0 and subsequently bundled with every Office 2000 suite except Standard. This program was developed in association with Envelope Manager Software. An enhanced version called DAZzle Express was available from Envelope Manager Software. Additionally, Direct Mail Manager was available for United States, United Kingdom, Germany, France and Italy.
Business Planner (MSBP) contained business-planning resources, templates, articles, advice from experts. It allowed user to create a business plan and a marketing plan (US only). It was available for United States, Canada, United Kingdom, Australia, Germany and France.
Data Analyzer
[edit]Microsoft Data Analyzer 2002 was part of Microsoft Office XP. Microsoft originally purchased the software as part of the intellectual property of Maximal Innovative Intelligence - Maximal's "Max" product was rebranded as Microsoft Data Analyzer. Even though it was a stand-alone application and was not available in any Office XP bundle, it was a part of the Office XP suite. It was not updated beyond version 3.5.[9]
Microsoft Data Analyzer allows analyzing and visualizing data and data trends, and is integrated with SQL Server Analysis Services. Reports and graphs generated could be saved as HTML, Microsoft Excel, or Microsoft PowerPoint files.
Document Scanning and Document Imaging
[edit]Microsoft Office Document Scanning (MODS) is a scanning and optical character recognition (OCR) application introduced first in Office XP. The OCR engine is based upon Nuance's OmniPage.[10] MODS is suited for creating archival copies of documents. It can embed OCR data into both MDI and TIFF files. This enables text search on the files, which is integrated into the Windows Search.
Microsoft Office Document Imaging (MODI) enables editing and annotating documents scanned by Microsoft Office Document Scanning. It was first introduced in Office XP, and was included in Office 2003 and Office 2007. Although it is not available in Office 2010, it is possible to install it from a previous version of Microsoft Office and use it with Office 2010.[11] (The Internet Fax feature in Office 2010 uses the Windows Fax printer driver to generate a TIFF file instead.[12]) Microsoft offers MDI to TIFF File Converter, a command line tool, which allows users to convert one or more MDI files to TIFF.[13]
MODI supports Tagged Image File Format (TIFF) as well as its own proprietary format called MDI. It can save text generated from the OCR process into the original TIFF file. However, MODI produces TIFF files that violate the TIFF standard specifications[14] and are only usable by itself.[15]
In its default mode, the OCR engine will de-skew and re-orient the page where required.
Since Office 2003 Service Pack 3, MODI no longer takes over the file association with Tagged Image File Format (TIFF) files as part of the Service Pack's security changes. Also, it no longer supports JPEG compression in TIFF files.[16]
MODS and MODI are no longer available since Office 2010, although Microsoft recommends a workaround by installing the MODI component from SharePoint Designer 2007 or old Office media.[11]
Programmability
[edit]MODI exposes a document and an image object through Component Object Model (COM). It can convert scanned images to text under program control, using its built-in OCR engine.
The MODI object model is accessible from development tools that support the Component Object Model (COM) by using a reference to the Microsoft Office Document Imaging 11.0 Type Library. The MODI Viewer control is accessible from any development tool that supports ActiveX controls by adding Microsoft Office Document Imaging Viewer Control 11.0 or 12.0 (MDIVWCTL.DLL) to the application project. These folders are usually located in C:\Program Files\Common Files\Microsoft Shared\MODI.
The MODI control became accessible in the Office 2003 release; while the associated programs were included in earlier Office XP, the object model was not exposed to programmatic control.
A simple example in Visual Basic .NET follows:
Dim inputFile As String = "C:\test\multipage.tiff"
Dim strRecText As String = ""
Dim Doc1 As MODI.Document
Doc1 = New MODI.Document
Doc1.Create(inputFile)
Doc1.OCR() ' this will OCR all pages of a multi-page TIFF file
Doc1.Save() ' this will save the deskewed reoriented images, and the OCR text, back to the inputFile
For imageCounter As Integer = 0 To (Doc1.Images.Count - 1) ' work your way through each page of results
strRecText &= Doc1.Images(imageCounter).Layout.Text ' this puts the OCR results into a string
Next
File.AppendAllText("C:\test\testmodi.txt", strRecText) ' write the OCR file out to disk
Doc1.Close() ' clean up
Doc1 = Nothing
MDI file format
[edit]| Microsoft Document Imaging (MDI) | |
|---|---|
| Filename extension | .mdi |
| Internet media type |
image/vnd.ms-modi |
| Magic number | 0x5045 |
| Type of format | Image file formats |
| Extended from | TIFF |
MODI uses a proprietary format with .mdi Filename extension for storing scanned documents together with optional annotations or metadata which can include the text generated by OCR process. It is known that MDI is a variant of TIFF.[17][18] Key differences from TIFF include:
- Magic number is
0x5045, instead of TIFF's0x4D4D(ASCIIMM) or0x4949(ASCIIII). - Three proprietary image compression formats are used.
- Numerous proprietary tag values are used.
Office Assistant
[edit]PhotoDraw
[edit]Photo Editor
[edit]Office Web Components
[edit]Office Web Components (OWC) are a group of Object Linking and Embedding (OLE) components available in Office 2000, XP, and 2003. These ActiveX Controls can be plugged into web pages, Visual Basic, Visual Basic for Applications (VBA) forms, and Windows Forms, or programmed in-memory. The OWC can be used by any COM-compliant Component Object Model programming language. Applications such as Excel, Microsoft Access, Microsoft Project and Microsoft FrontPage allowed creating interactive web pages using Office Web Components.
The following components are included:
- Spreadsheet
- Chartspace
- Pivot table
- Data source component
The Office Web Components were discontinued in Office 2007 except as a part of Office Project Server 2007.[19] However, they were available for download from Microsoft's website. Microsoft has not yet offered a complete OWC replacement. However, programmers can use a combination of third-party products, Excel Services, or Visual Studio Tools for Office to provide similar functionality.
The Pivot Table web component may have problems on Windows 7.[20] In many cases the problems are related to the new security settings in IE and can be solved by relaxing the restrictions in the relevant Internet Zone, allowing ActiveX controls and possibly cross-domain access. If the page is hosted locally in the computer, the settings for the zone are not accessible through the IE interface, and can be changed by editing the registry (under key [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\0]).
Four books in print cover OWC programming:
- The O.W.C Black Book 2nd Edition - Alvin Bruney 2007
- The Microsoft Office Web Components Black Book with .NET - Alvin Bruney 2005
- Professional ASP Programming Guide for Office Web Components: With Office 2000 and Office XP - Qimao Zhang 2001
- Programming Microsoft Office 2000 Web Components - Dave Stearns 2000
Clip Organizer
[edit]Microsoft Clip Organizer is Microsoft's clip art organizing software allowing users to find drawings, photographs, sounds, videos, and other media clips to include in presentations, publications, and other Office documents. It comes with a variety of stock media clips and offers more selection on the Microsoft Office Online website.
Picture Manager
[edit]Script Editor
[edit]Equation Editor
[edit]Equation Editor was a formula editor developed by Design Science that allowed users to construct math and science equations in a WYSIWYG environment, and was included in Microsoft Office and several other commercial applications. It was a simplified version of Design Science's MathType, evidenced with a dialog box enticing the user to upgrade to the full, paid version of the software.[21] It could be used as a standalone program or as an embedded object from within applications that support OLE. Its feature set had not changed significantly since its introduction in Word for Windows version 2.0.
Beginning with Office 2007, Equation Editor is no longer the default method of creating equations, and is kept for compatibility with old documents only.[22] Instead, a reengineered equation editor is included, which is built into the document-editing part of the Fluent User Interface on core Office 2007 programs and all Office 2010 and 2013 programs, rather than accessed through a separate dialog and being treated as an OLE object in the document.[23] In January 2018, Microsoft published a security update that completely removed the old Equation Editor for Office 2007, Office 2010, Office 2013 and Office 2016 when the update was installed, due to a vulnerability that was being actively exploited.[24]
References
[edit]- ^ "Microsoft Finally Rolls Out 'Delve,' One Of Its Most Important Products You've Never to try to show the most relevant people and content". 8 September 2014.
- ^ Foley, Mary Jo (14 April 2015). "Microsoft delivers iOS, Android versions of Delve". ZDNet.
- ^ "Here's why Microsoft dropped its Delve app for Windows 10". ZDNET. Retrieved 2024-09-09.
- ^ Brown, Nat [@natbro] (December 17, 2020). "@vr_sam Yep, me and a punk named @forstall" (Tweet). Archived from the original on July 25, 2021. Retrieved December 24, 2021 – via Twitter.
- ^ "Frequently asked questions about Office Binder 97". Microsoft Support. 2004-09-02. Archived from the original on 2004-10-28.
- ^ "Description of Office Binder support with Office 2003 and Office XP products". Microsoft Support. 2004-09-03. Archived from the original on 2005-05-07.
- ^ ""This file does not have a program associated with it for performing this action" error message when you open a Binder file". Microsoft Support. 2004-10-15. Archived from the original on 2005-05-05.
- ^ As of 2024, the Unbind utility is no longer available from Microsoft. See "Office 97 Unbind Utilities". Microsoft. 2003-02-24. Archived from the original on 2010-10-03.
- ^ "Data Analyzer 3.5 - Downloads - Office.com". Office.microsoft.com. Archived from the original on 2010-04-21. Retrieved 2012-03-01.
- ^ "Microsoft Announces New Office Document Imaging Tool Included in Office XP". microsoft.com. 2001-05-31. Retrieved 2021-03-06.
- ^ a b "Install MODI for use with Microsoft Office 2010 - Microsoft Support". support.microsoft.com. Retrieved 2023-11-06.
- ^ "Changes in Word 2010 (for ITPros)". TechNet. Microsoft. 9 December 2010. Retrieved 13 December 2012.
- ^ "MDI to TIFF File Converter". Microsoft Download Center. Microsoft. Retrieved 2014-08-22.
- ^ "TIFF Revision 6.0 Final — June 3, 1992" (PDF). Adobe Systems. 15 September 1995. Archived from the original (PDF) on 3 July 2012. Retrieved 13 December 2012.
- ^ Head, Michael R. (13 March 2008). "Handling Microsoft Office Document Scanning TNEF and TIFFs in Linux". Suppressingfire.org. Archived from the original on 30 April 2013. Retrieved 13 December 2012.
- ^ "You may experience issues when you run the Microsoft Office Document Imaging program after you install Office 2003 Service Pack 3 (Revision 3.0)". Microsoft Support. Microsoft. 11 August 2009. Retrieved 13 December 2012.
- ^ "LibTiff Mailing List Archive, "Notes on Microsoft Office Document Imaging file format", by Brad Hards". www.asmail.be.
- ^ "LibTiff Mailing List Archive, "Microsoft Document Imaging status / snapshot", by Brad Hards". www.asmail.be.
- ^ David Gainer (July 17, 2006). "Office Web Components "Roadmap"". Microsoft Excel 2007 (nee Excel 12). MSDN Blogs. Archived from the original on September 1, 2006. Retrieved 2006-09-10.
- ^ "Webpage on Windows 7 does not render the OWC Pivot Table".
- ^ "Equation Editor Tips". MathType. Design Science. Retrieved 22 February 2015.
- ^ "Where is Equation Editor? - Word - Office.com". Office.microsoft.com. Retrieved 2012-03-01.
- ^ Murray Sargent (2006-09-13). "High-Quality Editing and Display of Mathematical Text in Office 2007". blogs.msdn.com.
- ^ "CVE-2018-0802: Microsoft Office Memory Corruption Vulnerability". Microsoft. 2018-01-09. Retrieved 2018-01-14.
Further reading
[edit]- "An .mdi file does not open in the Microsoft Office Document Imaging program that is included in the 2007 Office programs (Revision 4.0)". Microsoft Support. Microsoft. 12 September 2011. Retrieved 13 December 2012.
- "Microsoft Office Document Imaging Visual Basic Reference (MODI)". Microsoft Download Center. Microsoft. 9 December 2003. Retrieved 13 December 2012.
- "Using the Microsoft Office Document Imaging 2003 Object Model". MSDN. Microsoft. 11 July 2006. Retrieved 13 December 2012.
Microsoft Office shared tools
View on GrokipediaActive Shared Tools
Microsoft Graph
Microsoft Graph is a RESTful web API that serves as the primary gateway for developers to access and interact with data across Microsoft 365 services, launched in general availability on November 18, 2015, as part of Office 365 under the initial name Office 365 Unified API.[8] It evolved from an OData-based protocol to provide a unified endpoint athttps://graph.microsoft.com, enabling programmatic access to a broad ecosystem of cloud resources while consolidating previously fragmented APIs for services like Exchange, SharePoint, and OneDrive.[9] This evolution has positioned Microsoft Graph as a central hub for building intelligent applications that leverage people-centric data and insights from Microsoft Entra ID, Windows, and enterprise mobility services.[9]
At its core, Microsoft Graph supports key functionalities for retrieving and managing user data, including profiles via the /users endpoint, emails and calendars through /me/messages and /me/events, files in personal or shared drives with /me/drive, and collaboration groups using /groups.[10] These capabilities allow developers to perform operations like querying recent files, scheduling meetings, or analyzing team interactions in a consistent, scalable manner. Security is integral, with OAuth 2.0 handling authentication and authorization through delegated permissions for user-context actions or application permissions for daemon apps, complemented by role-based access control (RBAC) enforced via Microsoft Entra ID roles.[11] Additionally, it ensures compliance with regulations like GDPR by adhering to Microsoft's global privacy standards and data protection commitments.
Integrations with Office applications demonstrate Microsoft Graph's practical role in enhancing user experiences; for instance, it powers auto-suggestions and contextual insights in Outlook by analyzing email and calendar data in real time, while in OneDrive, it facilitates seamless file syncing and sharing across devices and apps.[12][13] As of 2025, updates have introduced AI-driven enhancements, particularly through Graph connectors, which enable the ingestion of custom data sources from external systems into Microsoft Search and Copilot, allowing for more personalized and context-aware recommendations without native API support.[14] Microsoft Graph also underpins features in tools like Delve for surfacing relevant content based on user signals.
Microsoft Query
Microsoft Query is a component of Microsoft Office that enables users to retrieve, analyze, and manipulate data from external sources directly within applications such as Excel and Access, using SQL queries via ODBC connections.[15] Introduced with Office 95 as MS Query, it allows connections to databases without requiring users to exit the Office environment, facilitating seamless data import for analysis.[16] This tool was designed to bridge Office applications with external databases, supporting early integration of ODBC-compliant sources like SQL Server and dBASE files.[17] Key features include a graphical query builder for constructing SQL statements, enabling users to select, filter, sort, and join data tables visually or via direct SQL editing.[15] Users can import entire tables or subsets of data into worksheets, with options to refresh connections automatically for live updates from the source.[15] Queries can be saved as .dqy files for reuse and sharing, and the imported data retains Excel formatting, such as subtotals and charts, upon refresh.[15] It supports parameter queries for dynamic input and integration with pivot tables in Excel for summarized reporting.[15] Supported data sources encompass a range of ODBC-compliant databases, including Microsoft SQL Server, Oracle, Microsoft Access, Excel workbooks, text files, dBASE, FoxPro, Paradox, and OLAP cubes, with additional sources accessible via third-party ODBC drivers.[15] For instance, users can connect to SQL Server for enterprise data or to Excel files for cross-workbook analysis, enabling pivot table creation directly from queried results.[15] Despite its capabilities, Microsoft Query has limitations, such as reliance on compatible ODBC drivers for non-native sources, which may not support all database features, and unencrypted storage of saved passwords, posing security risks.[15] It struggles with highly complex SQL statements, where intricate joins or advanced syntax may fail or require simplification, particularly in versions post-Office 2007.[18] As a legacy tool, it remains available in Office 2021 and Microsoft 365 but requires enabling via the "Show legacy data import wizards" option in Excel settings.[15] In reporting and analysis workflows, Microsoft Query is used to pull live data into Excel for creating dynamic reports, dashboards, and pivot tables, streamlining tasks like financial analysis or inventory tracking without manual data entry.[15] It complements Visual Basic for Applications by providing a user-friendly interface for data retrieval, while VBA handles further automation.[15]Visual Basic for Applications
Visual Basic for Applications (VBA) is an event-driven programming language developed by Microsoft to automate tasks and extend functionality within Office applications. It originated from Visual Basic for MS-DOS, released in 1991 as a professional development environment for creating text-based applications on the MS-DOS platform.[19] VBA itself was introduced in 1993 with Excel 5.0, replacing the earlier XLM macro language, and was designed to provide a more robust scripting capability for end-users and developers.[20] By 1995, with the release of Office 95, VBA was integrated as a core component across multiple applications, including Excel and Access, marking its transition from a standalone tool to an embedded language for Office automation.[21] VBA's core syntax draws from the BASIC family, supporting procedural and object-oriented programming paradigms, with a focus on event-driven execution where code responds to user actions or application events, such as button clicks or workbook changes.[22] Key features include access to application-specific object models—for instance, in Excel, theApplication.Workbooks object allows manipulation of workbook collections—and the creation of macros, which are recorded or written sequences of instructions for repeating tasks.[20] User forms enable the design of custom dialog boxes with controls like buttons and text fields, facilitating interactive interfaces within documents.[23] This standardization extended VBA to Word for document manipulation, PowerPoint for slide automation, Access for database interactions, and Outlook for email and calendar scripting, allowing consistent code reuse across these applications.[24] VBA can integrate with tools like Microsoft Query to create data-driven scripts that pull external data into Office documents.[20]
Due to security risks posed by malicious macros, VBA implements a robust security model managed through the Trust Center in Office applications. Macros are disabled by default in modern installations, requiring users to explicitly enable them via notifications or settings to prevent unauthorized code execution.[25] The Trust Center offers configurable options, such as "Disable all macros with notification," which prompts users before running code, and support for macro signing using digital certificates to verify the code's origin and integrity.[26]
Practical examples of VBA macros include automating batch processing, such as looping through multiple worksheets to apply uniform formatting or data validation rules, which saves time on repetitive tasks in large datasets.[27] Custom functions can be defined to perform complex calculations not available in built-in formulas, like a user-defined function for advanced statistical analysis integrated directly into cells.[28] Add-ins developed via Component Object Model (COM) extend VBA's reach, allowing reusable components that interact with multiple Office apps, such as a COM add-in for cross-application data synchronization.[29]
As of 2025, VBA remains fully supported in Microsoft 365 for existing macros and legacy compatibility, enabling continued use in enterprise environments with vast installed codebases.[30] However, Microsoft issues deprecation warnings for new development, recommending alternatives like Office Scripts (based on TypeScript) or JavaScript API add-ins for web-centric and cross-platform extensibility, as these align better with modern security and cloud integration standards.[31]
