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
15
votes
3 answers

Not a valid Office Add In

I developed a new Office 2007 addin using VS 2008 and VSTO. after this I go to Office->Excel Options->AddIns->COM AddIns and GO... If I select the .dll which I ve created I get the error '' is not a valid Office Add In. If I run it using the…
Sachin
  • 239
  • 2
  • 3
  • 6
14
votes
4 answers

VSTO custom taskpane on multi DPI system shows content twice

I am building an office addin using VSTO. On systems with multiple monitors with different DPI settings, the contents of my custom task pane is drawn twice on the monitor with the higher DPI settings: Only the smaller version is actually responding…
Daniel Hilgarth
  • 171,043
  • 40
  • 335
  • 443
14
votes
6 answers

MS Word: Preserving vector graphics (SVG) when saving document as PDF

Microsoft recently added SVG support to Word 2016. But when trying to save a document containing a SVG vector graphic as PDF the graphic will be converted to a raster image. I tried to change the Image Size and Quality Options (-> "do not compress…
Peter
  • 189
  • 1
  • 1
  • 8
14
votes
4 answers

Python: Access embedded OLE from Office/Excel document without clipboard

I want to add and extract files from an Office/Excel document using Python. So far adding things is easy but for extracting I haven't found a clean solution. To make clear what I've got and what not I've written the small example test.py below and…
BREMI
  • 794
  • 1
  • 7
  • 12
14
votes
3 answers

Excel merge cell date and time

I want merge cell in Excel 2013 column date (2016-01-01) and column time (16:00:00), How do I format cells to get 2016-01-01 16:00:00 ? Here is my example https://postimg.org/image/clxeqb66h/ I get 42677 16:00:00
Pointer
  • 2,123
  • 3
  • 32
  • 59
14
votes
4 answers

How to use Office from Visual Studio C#?

The technique for adding a reference to the COM interop of Office in Visual Studio is to go to: References Add Reference Select the COM tab Select Microsoft Office 11.0 Object Library And magically named reference…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
14
votes
3 answers

Details of Microsoft Office Url protocol?

Microsoft Office Documents register custom url protocol on the client computer. This is especially used by SharePoint. For example, if I open an excel file, I see the call to this url…
Steve B
  • 36,818
  • 21
  • 101
  • 174
14
votes
1 answer

How to parse word documents with ruby?

Does anyone know of a library that I can use on OS X/Linux to parse Word files and output the content as HTML? I've had a look at win32ole but as far as I can see it's for Windows only, although I could be wrong. Any suggestions?
Jim Neath
  • 1,217
  • 2
  • 14
  • 19
14
votes
4 answers

Url protocol handler security warnings

I have a custom url protocol handler for urls of the form myhandler://path/to/something. This is registered to a locally installed client application that handles the requests and does "the right thing". However, when I have a link of that form in…
StarBright
  • 251
  • 1
  • 2
  • 5
14
votes
1 answer

Shared Strings in Excel 2010

Can someone help me in understanding the Shared Strings in MS Excel? I tried to understand using some blogs but could not get complete idea. Everyone is explaining how to access Shared String using Open XML and where the Shared Strings stored (as…
Santhosh
  • 1,357
  • 4
  • 15
  • 30
14
votes
3 answers

Proper disposal of COM interop objects in C# particularly MS Office applications

I am developing an application that relies heavily on multiple Microsoft Office products including Access, Excel, Word, PowerPoint and Outlook among others. While doing research on interop I found out that starting with VS2010 and .NET 4, we…
Raheel Khan
  • 14,205
  • 13
  • 80
  • 168
14
votes
3 answers

How to produce documents (docx or pdf) from SQL Server?

I know this is a little subjective, but I'm looking into the following situation: I need to produce a number of documents automatically from data in a SQL Server database. There will be an MVC3 app sat on the database to allow data entry etc. and…
BlueChippy
  • 5,935
  • 16
  • 81
  • 131
13
votes
6 answers

Can I add a custom "Send" button to Outlook?

I'm creating a secure message alternative to email for my organization. We exchange confidential patient information with outside treatment providers. To protect privacy, we cannot use email for this purpose. Rather than force the users here to…
Zack Peterson
  • 56,055
  • 78
  • 209
  • 280
13
votes
3 answers

Trying to port Apache POI to Android

I'm looking for a lightweight version of poi-3.8.jar to use it in an Android (private) app. I don't seem to be able to fit the whole 1.7Mb jar in the APK for some reason (and it would be wrong to do so anyway) and since I'm only looking for the doc…
Johann Hilbold
  • 201
  • 1
  • 2
  • 8
13
votes
4 answers

uninstall VSTO plugin

When I doubleclick to install a VSTO plugin for Excel 2010 I get a message "unable to install this application because an application with the same identity is already installed. To install this application, either modify the manifest version for…
Bogdan Verbenets
  • 25,686
  • 13
  • 66
  • 119