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
50
votes
4 answers

What are the differences between VBA 6.0 and VBA 7.0?

I noticed that Office 2010 comes with Visual Basic for Applications 7.0. However I can't seem to find much documentation on what changes were made. Does anyone have a summary of the changes, or any resources describing the differences?
romandas
  • 4,086
  • 7
  • 29
  • 33
48
votes
6 answers

How can I programmatically freeze the top row of an Excel worksheet in Excel 2007 VBA?

I am looking to programmatically freeze the top row of an Excel worksheet from VBA. The end goal is to produce the same effect as the View > Freeze Panes > Freeze Top Row command in Excel 2007 so that the top row of the worksheet is frozen and…
LJ.
  • 875
  • 2
  • 9
  • 13
44
votes
3 answers

Beginning VSTO Development

I'm quite confused with what are the necessary tools for VSTO develpment. Specifically I want to manipulate Excel 2003/2007 documents programmatically. I did quite a lot of VBA before, if you want to relate any answer to that. Few questions I have…
idazuwaika
  • 2,749
  • 7
  • 38
  • 46
44
votes
3 answers

Cannot debug or run Word AddIn because the required version of Microsoft Office is not installed

I need to work on an existing Word 2007 addIn project that's a part of a MSVS 2008 solution. However, when I try to debug the addIn, I get the following error message: "You cannot debug or run this project, because the required version of the…
sdds
  • 2,021
  • 2
  • 25
  • 33
42
votes
10 answers

How to extract text from MS office documents in C#

I was trying to extract a text(string) from MS Word (.doc, .docx), Excel and Powerpoint using C#. Where can i find a free and simple .Net library to read MS Office documents? I tried to use NPOI but i didn't get a sample about how to use NPOI.
Elias Haileselassie
  • 1,385
  • 1
  • 18
  • 26
40
votes
10 answers

Installing Office Customization

Name: From: file:///D:/Samples/TestUpdatedVersion/bin/Debug/TestUpdatedVersion.vsto The customization cannot be installed because another version is currently installed and cannot be upgraded from this location. To install this version of the…
user187229
  • 401
  • 1
  • 4
  • 4
39
votes
8 answers

How to get a list of installed OLE DB providers?

Microsoft Excel allows import of data from "Other Sources". One of the options is to use an OLE DB provider. How to get a list of available OLE DB providers?
kevinarpe
  • 20,319
  • 26
  • 127
  • 154
39
votes
9 answers

C#: Getting the number of rows/columns with ExcelPackage

I need to read and write data from an Excel spreadsheet. Is there a method to finding out how many rows/columns a certain worksheet has using ExcelPackage? I have the following code: FileInfo newFile = new FileInfo(@"C:\example.xlsx"); using…
Napoli
  • 549
  • 2
  • 8
  • 13
36
votes
5 answers

Hiding an Excel worksheet with VBA

I have an Excel spreadsheet with three sheets. One of the sheets contains formulas for one of the other sheets. Is there a programmatic way to hide the sheet which contains these formulas?
Lost
35
votes
5 answers

How to avoid spell checking of source code in MS Word?

When I copy source code to a word document or email, it would be nice if spell check could ignore source code token. Is there an option to ignore blocks of text?
John MacIntyre
  • 12,910
  • 13
  • 67
  • 106
33
votes
10 answers

How do you comment an MS-access Query?

How does one add a comment to an MS Access Query, to provide a description of what it does? Once added, how can one retrieve such comments programmatically?
Varun Mahajan
  • 7,037
  • 15
  • 43
  • 65
33
votes
1 answer

Get started with Office 365 REST API

I'm sure related questions have been asked, but I cannot find this answer. I'm trying to make a simple ruby api wrapper for Office 365, and I can't figure out how to get an oauth app created (secret/token/callback url/. In everyone else's oauth/api…
Troy Anderson
  • 616
  • 1
  • 6
  • 10
32
votes
4 answers

VBA: How to display an error message just like the standard error message which has a "Debug" button?

I created an error-handler using On Error Goto statement, and I put a few lines of cleaning code and display the error message, but now I don't want to lose the comfortableness of the default handler which also points me to the exact line where the…
Vantomex
  • 2,247
  • 5
  • 20
  • 22
32
votes
6 answers

Using Python to program MS Office macros?

I've recently taken it as a project to teach myself how to program in Python. Overall, I must say that I'm impressed with it. In the past I've typically stuck to programming in VBA mostly for MS Excel (but also a bit in MS Access and Word) and have…
Jesse
  • 383
  • 1
  • 3
  • 9
31
votes
1 answer

Can I integrate Microsoft Lens into my application?

I like Office Lens's ability to automatically crop, focus, and align a picture... mainly for receipt and expense processing I want to have an app flow that goes like this: User opens my app and clicks photograph receipt Lens opens (android intent,…
makerofthings7
  • 60,103
  • 53
  • 215
  • 448