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

5585 questions
1121
votes
9 answers

What is a correct MIME type for .docx, .pptx, etc.?

For older *.doc documents, this was enough: header("Content-Type: application/msword"); What MIME type should I use for new .docx documents? Also, for pptx and xlsx documents?
Richard Knop
  • 73,317
  • 142
  • 374
  • 539
303
votes
2 answers

Where does VBA Debug.Print log to?

Where does Debug.Print output messages?
Alex Gordon
  • 51,480
  • 273
  • 609
  • 976
232
votes
32 answers

Reading Excel files from C#

Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've been using Export to Unicode text function of…
dbkk
  • 11,960
  • 13
  • 50
  • 58
107
votes
9 answers

How to perform better document version control on Excel files and SQL schema files

I am in charge of several Excel files and SQL schema files. How should I perform better document version control on these files? I need to know the part modified (different part) in these files and keep all the versions for reference. Currently I am…
Marcus Thornton
  • 5,043
  • 5
  • 41
  • 45
97
votes
1 answer

What do elements do anyway?

I've been running into some (standard) issues with Microsoft Office injecting its nasty markup into some html after forwarding an email via Outlook. I'm interested to know: Is there a resource that explains what elements actually do What…
zzzzBov
  • 157,699
  • 47
  • 307
  • 349
97
votes
13 answers

Microsoft.Office.Core Reference Missing

Using the example provided in codeproject I am struggling to work out where I can find the reference to the library Microsoft.Office.Core. I am getting the error "The referenced component 'Microsoft.Office.Core' could not be found." I only have…
Maxim Gershkovich
  • 42,124
  • 39
  • 134
  • 227
78
votes
11 answers

How can doc/docx files be converted to markdown or structured text?

Is there a program or workflow to convert .doc or .docx files to Markdown or similar text? PS: Ideally, I would welcome the option that a specific font (e.g. consolas) in the MS Word document will be rendered to text-code: ```....```.
Lorenz Lo Sauer
  • 20,692
  • 12
  • 75
  • 85
73
votes
18 answers

Why are cookies unrecognized when a link is clicked from an external source (i.e. Excel, Word, etc...)

I noticed that when a link is clicked externally from the web browser, such as from Excel or Word, that my session cookie is initially unrecognized, even if the link opens up in a new tab of the same browser window. The browser ends up recognizing…
Nick
  • 959
  • 1
  • 7
  • 12
72
votes
2 answers

Cell color changing in Excel using C#

I am using a Windows application for exporting a data table to Excel. It's working. Now I want to give some color for particular text in the cell. How shall I do this?
Suryakavitha
  • 1,291
  • 4
  • 33
  • 46
71
votes
5 answers

How to read data from excel file using c#

My application needs to read data from an excel file. I am using .Net and c# for development. I cannot install MS office in the system. Because of that the my application fails to read excel file and throws an error while loading the dll for excel.…
TutuGeorge
  • 1,832
  • 1
  • 19
  • 39
65
votes
9 answers

How to detect installed version of MS-Office?

Does anyone know what would be the best way to detect which version of Office is installed? Plus, if there are multiple versions of Office installed, I'd like to know what versions they are. A bonus would be if I can detect the specific version(s)…
code4life
  • 15,053
  • 7
  • 47
  • 80
55
votes
5 answers

What are "Microsoft Office Protocol Discovery" and "OfficeLiveConnector" and why do they access invalid URLs?

I monitor 404s on my sites closely which helps me detect broken links and hacking attempts but I've recently been getting log spam from browsers with these strings in the User Agent. They seem to be trying to scan parent directories of valid…
SpliFF
  • 35,724
  • 15
  • 80
  • 113
54
votes
2 answers

Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb

It has been a good number of years since I did some programming with Classic ASP and Microsoft Access where we used "Microsoft.Jet.Oledb" driver to access and display the data. I have been asked to do some work with accessing MS Excel data using…
RT88
  • 639
  • 2
  • 6
  • 9
52
votes
28 answers

Detect whether Office is 32bit or 64bit via the registry

Now that Office also comes in a 64bit install, where in the registry do you find out if the version of Office installed is 32bit or 64bit?
James Newton-King
  • 44,416
  • 22
  • 106
  • 128
50
votes
7 answers

Creating PowerPoint presentations programmatically

Is there a way to programmatically create PowerPoint presentations? If possible, I'd like to use C# and create PowerPoint 2003 presentations.
epotter
  • 7,351
  • 7
  • 59
  • 86
1
2 3
99 100