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

List of mso- attributes

I'm searching for a list of Microsoft specific CSS attributes with mso- prefix. Any link to an offical or unofficial source would be awesome.
Xaver
  • 11,144
  • 13
  • 56
  • 91
18
votes
11 answers

Using VBA to change Picture

I am trying to use VBA to automate the Change Picture function when you right click a Shape in Excel/Word/Powerpoint. However, I am not able to find any reference, can you assist?
PlayKid
  • 871
  • 2
  • 10
  • 21
17
votes
5 answers

Beginner sample codes for the Open XML SDK?

I recently started working on the Open XML SDK 2.0. I would like to know if there is any better documentation (instead of open xml sdk2.0 itself) or any other resource to learn working with the Open XML SDK?
stazera
  • 293
  • 1
  • 3
  • 9
17
votes
2 answers

How to distribute private office add-ins?

We have a small excel app to complement our SaaS product. Standalone it's useless and because of that I have big problems getting it into the office app store. And actually it doesn't make any sense there, it's just for our users. But how else can…
peter
  • 14,348
  • 9
  • 62
  • 96
17
votes
2 answers

MS Office Word VSTO “Load On Demand”

We have developed a product that is a standard VSTO addin (Word 2010 and Word 2013, x86 only). By default when it is installed, it is installed for all users (ie. the addin registry entries are inserted into HKLM -…
RoKa
  • 160
  • 1
  • 12
17
votes
1 answer

Place comments through Office Javascript API 1.1

My task is to place a comment via Office Javascript API in a Word document (.docx) compatible to Word 2007 or later. I found, that there is no direct way to do this via Microsoft API. Since I am able to pass OOXML to the Word document, I thought…
rzo1
  • 5,561
  • 3
  • 25
  • 64
17
votes
1 answer

"Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server

I can not find a solution for this error: The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server. I found a lot of posts on the web but none work. I am working with SQL server 2014 64 bits and…
Pablo Gûereca
  • 725
  • 1
  • 9
  • 23
17
votes
1 answer

Get a list of all Access ACE.OLEDB drivers installed on the system

Using the following code I can enumerate the OLEDB providers registered on my system static void DisplayData() { var reader = OleDbEnumerator.GetRootEnumerator(); var list = new List(); while (reader.Read()) { for (var i = 0;…
Xiaosu
  • 605
  • 1
  • 9
  • 21
17
votes
2 answers

Warning: The referenced component 'Microsoft.Office.Core' could not be found

When building one of my projects, I'm getting the following warnings: Warning 3 Cannot find wrapper assembly for type library "Microsoft.Office.Core". Warning 4 The referenced component 'Microsoft.Office.Core' could not be found. Strangely,…
Yuyo
  • 655
  • 1
  • 8
  • 17
17
votes
3 answers

Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#

I am trying to set the data type to an excel column in C#, in this case the data types number, text and date. How does one set a format to an entire excel column?
Jack1987
  • 727
  • 1
  • 14
  • 26
16
votes
5 answers

Where can I find Microsoft.Office.Interop.Word.dll (2010)?

I got the sources of a .NET project that I am trying to compile. Although, the project uses the reference (namespace) Microsoft.Office.Interop.Word from Office 2010 that I cannot find anywhere. I was able to download the file…
mentinet
  • 744
  • 3
  • 9
  • 23
16
votes
3 answers

Renaming Objects in PowerPoint

Probably a very stupid question but I can't figure how to rename an object in PowerPoint.. For example, all my Graphs are called by default "Graph 1" etc. Could someone help me on that? Thanks!
Eleonor
15
votes
2 answers

Programmatically extract macro (VBA) code from Word 2007 docs

Is it possible to extract all of the VBA code from a Word 2007 "docm" document using the API? I have found how to insert VBA code at runtime, and how to delete all VBA code, but not pull the actual code out into a stream or string that I can store…
Guy Starbuck
  • 21,603
  • 7
  • 53
  • 64
15
votes
7 answers

Google Apps macros - how do they compare to Office VBA macros?

Do any of you use the javascript macro capabilities of Google Apps, particularly for spreadsheets? How do the capabilities compare? Is there anything that Google Apps can't do that can be done with VBA macros?
notnot
  • 4,472
  • 12
  • 46
  • 57
15
votes
2 answers

How can a Custom Task Pane toggle visibility whilst keeping the UI responsive?

I'm trying to add a Custom Task Pane in an Excel Add-in which is intended to work similarly to the Pivot Tables pane. The intention is that when a Table is selected the custom pane should appear and should disappear. To do this, I've created a…
Paul Turner
  • 38,949
  • 15
  • 102
  • 166