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
2
votes
1 answer

Extract hyperlink address from HYPERLINK field code

I would like to replace the text below with only http://www.someurl.com. I have Word mac 2011. To clarify, I do not actually want to return from the field code to the actual hyperlink (blue), I only want the address as text in the document. {…
Jackson Henley
  • 1,531
  • 2
  • 15
  • 27
2
votes
1 answer

Selecting records with the most recent date for each unique identifier

To start, I've been scouring the internet for the last four hours and have come across a few similar issues (most here on stack overflow) with solutions that look like they could work, but did not (most of them used a single table). I have two…
Chris Boden
  • 219
  • 4
  • 10
2
votes
1 answer

Code a plugin for the Office Communicator Client?

Is it possible to code a plugin for the Office Communicator Client? I have seen code that lets me make my own client, but I want to just add functionality to the existing client. Can that be done? The plug-in I want to make would look for a string…
Vaccano
  • 78,325
  • 149
  • 468
  • 850
2
votes
1 answer

How to create a clone of a word document object?

How do you create a clone of a word document in c#? (office 2007 libraries) public copyDocument (Word.Document _originalDocument) { //How do I clone the _originalDocument? Word.Document clonedDocument = _originalDocument; //Do stuff to…
user1255276
  • 541
  • 2
  • 5
  • 20
2
votes
2 answers

Copying Notepad++ code into PowerPoint 2010

I've tried copying some source code that I have input into Notepad++ and pasting into PowerPoint 2010, but I'm not offered any "Paste Special" options other than "Keep Text Only" Any suggestions on how I can do this?
JimRomeFan
  • 407
  • 6
  • 19
2
votes
1 answer

VSTOR 4 Framework MSI Deployment via Group Policy

I developed an Outlook 2010 Add-In, which is going to be deployed on hundreds of machines. In order to deploy the add-in, I made use of the Microsoft's ClickOnce mechanism. The add-in relies on Visual Studio Tools for Office 2010 Runtime framework…
EARNEST
  • 107
  • 4
  • 11
2
votes
1 answer

cant update Excel file if Excel is not open?

I am trying to Read and Update Excel using Oledb and Dataset in C#. Read Operation work fine even for both Excel file is open or not. Update Operation work only if file is Open but Update Operation giving error if Excel file is not Open Code…
2
votes
1 answer

How to programatically pickup list items from a word file and generate few others?

I don't know much MS Office VBA. I have tons (literally) of quiz questions in word files. Task is to create question papers for students. Word file contains 900 quiz questions categorized chapter wise. Here is the structure of a word file: H1:…
claws
  • 52,236
  • 58
  • 146
  • 195
2
votes
2 answers

How to read complex equations from PowerPoint slide in C#

I am trying to read powerpoint slides. But when my program is encountered with text like " Vo = Σ CF/(1+t) " , the shape.TextFrame.TextRange.Paragraphs(paraindex,1).Text property can not read it properly(Specially Σ symbol and subscript…
rohitvk
  • 277
  • 3
  • 13
2
votes
2 answers

How to prevent Excel from handling strings containing a colon as formulas

I am generating csv files, and some cells have the format nn:nnnn , i.e. digits separated by a colon. It's not a time format nor a date format, it's just text cells and I don't want them to be re-formatted at all. I've added some logic to my code in…
Sidney Levy
  • 155
  • 2
  • 9
2
votes
2 answers

MS Word 2010 mail merge: dynamic url, same text

I have a MS word 2010 mail merge that needs a personal url as href and a generic title for all users i can send a url that displays as the full url, but i want a generic display text so users dont see all the parameters or a gigantic url i have…
Jay Rizzi
  • 4,196
  • 5
  • 42
  • 71
2
votes
2 answers

Does the Open XML SDK 2.0 for Microsoft Office support Office 2007

If I browse to the Open XML SDK 2.0 for Microsoft Office page and select "Other Versions" > "Office 2007", it takes me to Open XML Format SDK 1.0. Does this mean that the Open XML SDK 2.0 for Microsoft Office does not support Office 2007…
Paul C
  • 4,687
  • 5
  • 39
  • 55
2
votes
1 answer

Writing data to cells in Excel 2007 / PowerShell

Why can I not write values to Excel using the Worksheet class, or Sheet interface? I would expect to be able to do something like this: [Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Interop.Excel") $Excel = New-Object…
user189198
2
votes
1 answer

How can I print Office documents from .NET in a uniform manner?

Using Microsoft interOp objects, I can programmatically print a Word or Excel document. Is there any simpler and uniform way to programmatically print all types of documents (.txt, .doc, .xls, .pdf etc.)?
user189015
2
votes
1 answer

How to get Microsoft Office path from VBScript?

Using VBScript, how do I determine the path where Microsoft Office (2003 or 2010) is installed?
Cocoa Dev
  • 9,361
  • 31
  • 109
  • 177
1 2 3
99
100