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
29
votes
5 answers

Android Microsoft Office Library (.doc, .docx, .xls, .ppt, etc.)

Does anyone know of a good Java Microsoft Office API capable or running on an Android? I know there is an OpenOffice Java API, but I haven't heard of anyone using it on Android. I know that using intents is another option, but how common are…
matheeeny
  • 1,714
  • 2
  • 17
  • 32
28
votes
2 answers

How to develop a Microsoft Office AddIn without Visual Studio

I'm trying to develop an MS Office Addin in C# .Net and I don't have access to Visual Studio. Instead I'm using SharpDevelop as my IDE, (but my question is equally relevant to anyone developing using any other IDE or compiling from the command…
Iain Sproat
  • 5,210
  • 11
  • 48
  • 68
28
votes
13 answers

Exporting the values in List to excel

Hi I am having a list container which contains the list of values. I wish to export the list values directly to Excel. Is there any way to do it directly?
susanthosh
  • 440
  • 2
  • 9
  • 15
26
votes
4 answers

Automating Office via Windows Service on Server 2008

We have a Windows Service which runs on 2003 Server. It opens a source Word document using the Word Interop and then does some stuff with it. It also does likewise with Excel and PowerPoint files. Recently we've tried moving this service onto a…
Graeme
  • 1,657
  • 5
  • 28
  • 46
25
votes
5 answers

Can't locate Microsoft.Office.Interop.Word in Reference List

I was given this solution to a problem I had, since I didn't know how to integrate MS Word with C#: http://www.dotnetperls.com/word I looked into this solution, and I can't locate Microsoft.Office.Interop.Word in the reference list. I can't find it…
OmniOwl
  • 5,477
  • 17
  • 67
  • 116
24
votes
6 answers

Programmatically extracting slides as images from a PowerPoint presentation (.PPT)

Given a PowerPoint presentation in .ppt format, what is the best way to programmatically and using only open source software extract an image representation (in say .jpg or .png) of each slide in the presentation? The application will run in a Linux…
knorv
  • 49,059
  • 74
  • 210
  • 294
24
votes
4 answers

PHP xls, xlsx, ppt, pptx headers

Here is my code where I am trying to send a correct header depedning on a type of a document. I figured out the headers for pdf, doc and docx but I still need to know correct header for Excel and Powerpoint files. Any help appreciated. …
Richard Knop
  • 81,041
  • 149
  • 392
  • 552
24
votes
2 answers

Where to find Office 2007/2010/2013 Open XML Schemas

I am looking to pull together all of the XML schemas that Office 2007/2010/2013 documents abide by. I have found a number from the ISO/IEC 29500:2012 spec and ECMA-376 spec. I have also located a few on w3.org (e.g. xmldsig#). But I have been unable…
Michael Gunter
  • 12,528
  • 1
  • 24
  • 58
24
votes
7 answers

Excel 2007: How to display mm:ss format not as a DateTime (e.g. 73:07)?

I need to create and Excel table that computes daily training times. each row has the following fields: Date, Distance, Time and Minutes/Km. My main problem is that I want to display the Time in format of mm:ss. For example: 24 min and 3 sec should…
Meron
  • 453
  • 2
  • 6
  • 15
23
votes
5 answers

Get list of sub-directories in VBA

I want to get a list of all sub-directories within a directory. If that works I want to expand it to a recursive function. However my initial approach to get the subdirs fails. It simply shows everything including files: sDir = Dir(sPath,…
Matthias Pospiech
  • 3,130
  • 18
  • 55
  • 76
23
votes
3 answers

How can I run a macro from a VBE add-in, without Application.Run?

I'm writing a COM add-in for the VBE, and one of the core features involves executing existing VBA code upon clicking a commandbar button. The code is unit testing code written by the user, in a standard (.bas) module that looks something like…
Mathieu Guindon
  • 69,817
  • 8
  • 107
  • 235
23
votes
11 answers

Your organization's policies are preventing us from completing this action - Microsoft Office

When I try to open hyperlinks in a Microsoft Office program like Excel or Outlook the following message is shown: Your organization's policies are preventing us from completing this action for you. For more info, please contact your help desk. How…
Paryshaan
  • 251
  • 1
  • 2
  • 5
23
votes
4 answers

Where does Outlook store the VBA code files?

I had a VBA project in outlook with a few email macros - but after a PC crash they are all gone and all I see is a fresh 'Project1' when I hit Alt+F11 I'm not a VBA programmer, but had a collection of handy macros for email sorting etc. I would not…
Frep D-Oronge
  • 2,618
  • 3
  • 27
  • 27
23
votes
4 answers

How to get request digest value from provider hosted app?

I am developing SharePoint 2013 Provider hosted app using javascript REST Api. In order to perform create (POST), or update (MERGE) operations on sharepoint items I need to set the 'X-RequestDigest' header with the request. When in…
Matt Mazzola
  • 4,593
  • 4
  • 22
  • 28
22
votes
5 answers

How to disable popups when opening a file using Microsoft.Office.Interop

Such as read-only confirm, other alerts. What to do with these popups? Or ignore them?
Bruce Dou
  • 4,673
  • 10
  • 37
  • 56