Questions tagged [ms-office]

Microsoft Office is a proprietary collection of desktop applications intended to be used by knowledge workers for Windows and Macintosh computers. If your question relates to a specific desktop application use that application tag instead.

Microsoft Office is a proprietary collection of desktop applications intended to be used by knowledge workers.

It comes in several different software bundles and is available for Windows and Macintosh computers. Current version as of this writing is Office 2016 for Windows and Office 2016 for Mac. Microsoft has also unveiled Office Web Apps to compete with similar applications, for hosting Office programs and documents on remote servers.

It can include any/all of the following:

  • Access - relational database
  • Excel - spreadsheet / calculation engine
  • InfoPath - creating forms
  • Lync - communications
  • OneNote - note-taking
  • Outlook - email / personal information manager (PIM)
  • PowerPoint - creating presentations / slideshows
  • Project - project management
  • Publisher - flyers, newsletters and other printed materials
  • SharePoint - sharing group content
  • Visio - diagramming
  • Word - word-processing software

There are additional lesser-known Office programs such as Business Contact Manager which are not covered in this wiki because they are typically addons to another program.

Typically you would use one of the program-specific tags above when tagging your question, depending on which program you are using.

Links:

Getting Started with Office 2016 - Getting Started with Office 2013 - Getting Started with Office 2010

5901 questions
22
votes
6 answers

"Office 2010 Add-In: Icons Gallery" - How to extract icons from backstage tab (docx)

I downloaded "Office 2010 Add-In: Icons Gallery" that is docx file with two backstage tabs that hold icons. How can I extract the icons or use them in my application?
no9
  • 6,424
  • 25
  • 76
  • 115
22
votes
8 answers

Procedure Too Large

I received this error message -Procedure too large - in VBA. What is the reason and way out for this error?
Sourav
  • 321
  • 1
  • 2
  • 4
22
votes
5 answers

Using ElasticSearch and/or Solr as a datastore for MS Office and PDF documents

I'm currently designing a full text search system where users perform text queries against MS Office and PDF documents, and the result will return a list of documents that best match the query. The user will then be to select any document returned…
ngekas
  • 325
  • 1
  • 2
  • 6
21
votes
5 answers

RCW & reference counting when using COM interop in C#

I have an application that uses Office interop assemblies. I am aware about the "Runtime Callable Wrapper (RCW)" managed by the runtime. But I am not very sure how the reference count gets incremented. MSDN says, RCW keeps just one reference to…
Navaneeth K N
  • 15,295
  • 38
  • 126
  • 184
21
votes
4 answers

Will Subversion efficiently store OpenXML Office documents?

I have been managing Subversion as an engineering document storage repository for my company. It is working fairly well, however I have a question about how MS Office 2007 formats are (should be) handled by Subversion. I'm looking at an Excel 2007…
RjOllos
  • 2,900
  • 1
  • 19
  • 29
20
votes
2 answers

How to monitor the values in a Dictionary in the Excel VBA watch window?

I am using dictionaries in Excel VBA via dict As New Dictionary (and adding a reference to the scripting runtime). When I try to monitor those during debugging, I can only see the keys which lie in the dictionary, but not the respective value of…
tyrex
  • 8,208
  • 12
  • 43
  • 50
20
votes
5 answers

unoconv not working while trying to convert. throws Error: Unable to connect or start own listener. Aborting

I am trying to convert docx to pdf using unoconv, but getting Error: Unable to connect or start own listener. Aborting. when I run unoconv -f pdf 1234.docx. So, there must be some listener. I then started the listener via unoconv --listener. I tried…
20
votes
2 answers

How do you use WiX to deploy VSTO 3.0 addins?

I want to deploy a VSTO 3 Application Level Word 2007 addin that I've written with Visual Studio 2008. I see that WiX has an extension named WixOfficeExtension that looks like it might have this functionality, but I can't find any documentation for…
Jacob
  • 22,785
  • 8
  • 39
  • 55
19
votes
4 answers

How to create a HTML link which forces MS Word to edit document on webdav server

Let's suppose that I have WebDAV-enabled server, where I have bunch of Office documents. I'd like to generate webpage which has link to document such that clicking on the link will open Microsoft Word. Word will in turn download document from WebDAV…
Peter Štibraný
  • 32,463
  • 16
  • 90
  • 116
19
votes
2 answers

Embedding word 2010 editor in a wpf application

How do I use the word editor in a WPF application? Is it possible using windows forms hosting in WPF only? Is there another way to accomplish that? I found AvalonEdit but it does not have features that I need. So using this way, my problem may not…
Mostafa Rezaei
  • 500
  • 1
  • 5
  • 12
19
votes
3 answers

Open and modify Word Document

I want to open a word file saved in my server using "Microsoft.Office.Interop.Word". This is my code: object missing = System.Reflection.Missing.Value; object readOnly = false; object isVisible = true; object fileName =…
ilamaiolo
  • 345
  • 2
  • 4
  • 14
19
votes
4 answers

Exception from HRESULT: 0x800401E3 (MK_E_UNAVAILABLE) Workarounds

From the following call Marshal.GetActiveObject("Excel.Application") I get a Operation unavailable (Exception from HRESULT: 0x800401E3 (MK_E_UNAVAILABLE)) I believe that this error is caused when the user permissions between my application and…
user1227708
  • 221
  • 1
  • 2
  • 5
18
votes
6 answers

How do I generate a document (.rtf, .doc, .odt) from R

what's the best way to generate a word-processor file (ideally as platform-independent as possible, but native Word formats will do), with images in it, from the statistical language R?
John Lawrence Aspden
  • 17,124
  • 11
  • 67
  • 110
18
votes
1 answer

SaveAs vs SaveAs2 in the Microsoft Office Word object model

It looks like SaveAs has gone away in Office 2010 in favor of SaveAs2. What is going on here? Are there any important differences between the two? My fix has been to check for SaveAs2 first, and then fall back to SaveAs. Is this reasonable?
Matthew Simoneau
  • 6,199
  • 6
  • 35
  • 46
18
votes
2 answers

How do I call an xll addin function from vba?

I have a 3rd party XLL addin I'd like to wrap in my own custom vba function. How would I call the 3rd party function from my code?
Dane O'Connor
  • 75,180
  • 37
  • 119
  • 173