Content deleted Content added
m →Equation Editor: Linkified word "OLE" (linked the word to the relevant wiki page) |
Add reference and details for Binder and Unbind |
||
| (45 intermediate revisions by 35 users not shown) | |||
Line 1:
{{short description|Components included in all Microsoft Office products}}
{{redirect-multi|2|MODI|.mdi|other uses|Modi (disambiguation){{!}}Modi|and|MDI (disambiguation){{!}}MDI}}
{{redirect-distinguish|UNBIND|Unbound (disambiguation){{!}}Unbound|Bind (disambiguation){{!}}Bind}}
{{expand lead|date=July 2021}}
'''Microsoft Office shared tools''' are software components that are (or were) included in all [[Microsoft Office]] products.
==Delve==
[[File:Microsoft Office Delve (2020–present).svg|thumb|68x68px]]
'''Office Delve''' allows [[Office 365]] users to search and manage their emails, meetings, contacts, social networks and documents stored on [[Microsoft OneDrive|OneDrive]] or Sites in [[Office 365]]. Delve uses [[machine learning]] and [[artificial intelligence]]<ref>{{cite web|url=https://finance.yahoo.com/news/microsoft-finally-rolls-delve-one-184634796.html|title=Microsoft Finally Rolls Out 'Delve,' One Of Its Most Important Products You've Never
==Graph==
Line 20 ⟶ 22:
==WordArt==
[[File:WordArt.png|thumb|An example image created with WordArt.]]
'''WordArt''' is a text-styling utility, created by [[Scott Forstall]] and Nat Brown (later Apple employees) while interning for [[Microsoft]] in 1991.<ref>{{cite tweet |last=Brown |first=Nat |user=natbro |number=1339600779531833344 |date=December 17, 2020 |title=@vr_sam Yep, me and a punk named @forstall. |language=en |access-date=December 24, 2021 |archive-url=https://web.archive.org/web/20210725230226/https://twitter.com/natbro/status/1339600779531833344 |archive-date=July 25, 2021 |url-status=live}}</ref> 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
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
[[File:WordArt 2010.png|thumb|WordArt created in [[Microsoft Office for Mac 2011|PowerPoint for Mac 2011]] <!--Space for avoiding confusion-->]]
Line 31 ⟶ 33:
===Binder===
'''Microsoft Binder''' was an application originally included with [[Microsoft Office 95]], [[Microsoft Office 97|97]], and [[Microsoft Office 2000|2000]] that allowed users to include different types of [[Object Linking and Embedding|OLE]] 2.0 objects (e.g., documents, spreadsheets, presentations and projects) in one file.<ref name="binder-faq">{{Cite web |title=Frequently asked questions about Office Binder 97 |url=http://support.microsoft.com/?kbid=843147 |website=[[Microsoft]] Support |date=2004-09-02 |url-status=dead |archive-url=https://web.archive.org/web/20041028105811/http://support.microsoft.com/?kbid=843147 |archive-date=2004-10-28}}</ref> 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 <code>.OBD</code>; the Office Binder template format was <code>.OBT</code>. A Microsoft Office Binder Wizard used the extension <code>.OBZ</code>.
Binder was no longer shipped with Office versions starting from [[Microsoft Office XP|XP]].<ref name="kb822622">{{Cite web |title=Description of Office Binder support with Office 2003 and Office XP products |url=http://support.microsoft.com/?kbid=822622 |website=[[Microsoft]] Support |date=2004-09-03 |url-status=dead |archive-url=https://web.archive.org/web/20050507002634/http://support.microsoft.com/?kbid=822622 |archive-date=2005-05-07}}</ref> Office XP and [[Microsoft Office 2003|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.<ref name="kb281931">{{Cite web |title="This file does not have a program associated with it for performing this action" error message when you open a Binder file |url=http://support.microsoft.com/kb/281931/ |website=[[Microsoft]] Support |date=2004-10-15 |url-status=dead |archive-url=https://web.archive.org/web/20050505202731/http://support.microsoft.com/kb/281931/ |archive-date=2005-05-05}}</ref> 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.<ref name="unbind-dl">As of 2024, the Unbind utility is no longer available from Microsoft. See {{Cite web |title=Office 97 Unbind Utilities |url=http://www.microsoft.com/downloads/en/details.aspx?FamilyID=bb8ef813-80e3-493f-a914-7add36d84b8a |website=[[Microsoft]] |date=2003-02-24 |url-status=dead |archive-url=https://web.archive.org/web/20101003200056/http://www.microsoft.com/downloads/en/details.aspx?FamilyID=bb8ef813-80e3-493f-a914-7add36d84b8a&displaylang=en |archive-date=2010-10-03}}</ref>
=== Small Business Tools ===
'''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===
'''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.<ref>{{cite web |url=http://office.microsoft.com/en-us/downloads/CD010225721033.aspx |title=Data Analyzer 3.5 - Downloads - Office.com |publisher=Office.microsoft.com |
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===
'''Microsoft Office Document Scanning''' (''MODS'') is a [[Image scanner|scanning]] and [[optical character recognition]] (OCR) application introduced first in Office XP. The OCR engine is based upon [[Nuance Communications|Nuance]]'s [[OmniPage]].<ref>{{cite web|url=https://news.microsoft.com/2001/05/31/microsoft-announces-new-office-document-imaging-tool-included-in-office-xp/|title=Microsoft Announces New Office Document Imaging Tool Included in Office XP|publisher=microsoft.com|date=2001-05-31|access-date=2021-03-06}}</ref> 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.<ref name="modi">
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<ref>{{cite web|url=http://partners.adobe.com/public/developer/en/tiff/TIFF6.pdf |title=TIFF Revision 6.0 Final — June 3, 1992 |publisher=[[Adobe Systems]]
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.<ref>{{cite web|title=You may experience issues when you run the Microsoft Office Document Imaging program after you install Office 2003 Service Pack 3 (Revision 3.0)|url=http://support.microsoft.com/kb/938813|work=Microsoft Support|publisher=Microsoft|
MODS and MODI are no longer available since Office 2010, although Microsoft recommends a workaround by installing the MODI component from [[SharePoint Designer|SharePoint Designer 2007]] or old Office media.<ref
====Programmability====
Line 64 ⟶ 83:
A simple example in [[Visual Basic .NET]] follows:
<
Dim inputFile As String = "C:\test\multipage.
Dim strRecText As String = ""
Dim Doc1 As MODI.Document
Line 71 ⟶ 90:
Doc1 = New MODI.Document
Doc1.Create(inputFile)
Doc1.OCR() ' this will
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
Nächste
Line 82 ⟶ 101:
Doc1.Close() ' clean up
Doc1 = Nothing
</syntaxhighlight>
====MDI file format====
{{Infobox file format
| name = Microsoft Document Imaging (MDI)
| extension = <
| mime = image/vnd.ms-modi
| magic = 0x5045
Line 93 ⟶ 112:
| extended from = [[TIFF]]
}}
MODI uses a [[proprietary format]] with <code>.mdi</code> [[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.<ref>{{cite web|url=http://www.asmail.be/msg0055568584.html|title=LibTiff Mailing List Archive, "Notes on Microsoft Office Document Imaging file format",
* [[File format#Magic number|Magic number]] is <code>0x5045</code>, instead of TIFF's <code>0x4D4D</code> (ASCII <code>MM</code>) or <code>0x4949</code> (ASCII <code>II</code>).
* Three proprietary [[image compression]] formats are used.
Line 116 ⟶ 135:
*Data source component
The Office Web Components were discontinued in Office 2007 except as a part of Office Project Server 2007.<ref>{{cite web |url=http://blogs.msdn.com/excel/archive/2006/07/17/668544.aspx |title=Office Web Components "Roadmap" |author=David Gainer |date=July 17, 2006 |
The Pivot Table web component may have problems on Windows 7.<ref>
Four books in print cover OWC programming:
Line 134 ⟶ 153:
{{Main|Microsoft Script Editor}}
===Equation Editor===
'''Equation Editor''' was a [[formula editor]] developed by
Beginning with Office 2007, Equation Editor is no longer the default method of creating equations, and is kept for compatibility with old documents only.<ref>{{cite web|url=http://office.microsoft.com/en-us/word-help/where-is-equation-editor-HA101988786.aspx |title=Where is Equation Editor? - Word - Office.com |publisher=Office.microsoft.com |access-date
▲Beginning with Office 2007, Equation Editor is no longer the default method of creating equations, and is kept for compatibility with old documents only.<ref>{{cite web|url=http://office.microsoft.com/en-us/word-help/where-is-equation-editor-HA101988786.aspx |title=Where is Equation Editor? - Word - Office.com |publisher=Office.microsoft.com |date= |accessdate=2012-03-01}}</ref> Instead, a reengineered equation editor is included, which is built into the document-editing part of the [[ribbon (computing)|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 [[Object Linking and Embedding|OLE]] object in the document.<ref>{{cite web|url=http://blogs.msdn.com/murrays/archive/2006/09/13/752206.aspx|title=High-Quality Editing and Display of Mathematical Text in Office 2007|date=2006-09-13|author=Murray Sargent|publisher=blogs.msdn.com}}</ref> In January 2018, Microsoft published a security update that completely removed the old Equation Editor when installed, due to a vulnerability that was being actively exploited.<ref>{{cite web|url=https://portal.msrc.microsoft.com/en-US/security-guidance/advisory/CVE-2018-0802|title=CVE-2018-0802: Microsoft Office Memory Corruption Vulnerability|date=2018-01-09|accessdate=2018-01-14|publisher=Microsoft}}</ref>
==References==
Line 143 ⟶ 163:
==Further reading==
{{Refbegin}}
*{{cite web|title=An .mdi file does not open in the Microsoft Office Document Imaging program that is included in the 2007 Office programs (Revision 4.0)|url=http://support.microsoft.com/kb/926198/en-us|work=Microsoft Support|publisher=Microsoft|
*{{cite web|title=Microsoft Office Document Imaging Visual Basic Reference (MODI)|url=http://www.microsoft.com/en-us/download/details.aspx?id=22333|work=Microsoft Download Center|publisher=Microsoft|
*{{cite web|title=Using the Microsoft Office Document Imaging 2003 Object Model|url=http://msdn.microsoft.com/library/office/aa167607.aspx|work=[[MSDN]]|date=11 July 2006 |publisher=Microsoft|
{{Refend}}
{{Microsoft Office}}
| |||