Stack Overflow
Stack Overflow

Questions tagged [office-2007]

For issues relating to Microsoft Office, version 2007.

Microsoft Office version 2007 is a suite of programs for office productivity.

It was released in 2007 and comes in a variety of configurations, including but not limited to:

  • Microsoft Office 2007 Home and Student (for academic use)
  • Microsoft Office 2007 Professional (includes Microsoft Access)
  • Microsoft Office 2007 Small Business

Each one comes with a different suite of programs.

It is expected that questions about Office 2007 relate to a specific programming problem. Use the tag for the programming language you are using to target an Office 2007 program, as well as the tag of the specific Office 2007 program.

Related Tags:

Links:

322 questions
7
votes
5 answers

In VSTO Excel, how to detect data in cells?

A process to quickly detect whether there is data in a given worksheet or not, without actually looping through all of the rows/columns of the worksheet. For my current process, I am currently looping through the entire sheet, and there is some…
Mohamed Nuur
  • 5,536
  • 6
  • 39
  • 55
7
votes
1 answer

Office 2007: Programmatically control Out-Of-Office assistant?

Does anybody know how to programmatically enable/disable the actual state of the out-of-office auto-responder in Outlook 2007? Already searched the object browser in VS 2008 and found the enumeration Microsoft.Office.Interop.Outlook.OlBusyStatus but…
Atmocreations
  • 9,923
  • 15
  • 67
  • 102
7
votes
5 answers

Array from Range in Excel VBA

Well I've been struggling with the little bit of code and can't seem to get around it ... I'm trying to get an array from a range of cells, the array however is showing up to be 1 element wide. Well here's the code: Dim item As Variant MsgBox…
Kevin Boyd
  • 12,121
  • 28
  • 86
  • 128
6
votes
1 answer

Is there an inverse mode for Microsoft Word?

I'm wondering if there's any way to invert the colors in Microsoft Office Word - that is, view white text on a black background. I mainly ask because I'm used to dark color schemes a la Notepad++ themes and similar, and so much white space is really…
crazedfred
  • 133
  • 1
  • 1
  • 8
6
votes
7 answers

visio 2007 database properties window doesn't show

I know this is probably not the right place to ask this question, but I don't know where else to turn. I tried google, but it hasn't helped me this time. I have Visio 2007 Professional. I am trying to create a database model, complete with primary…
chama
  • 5,973
  • 14
  • 61
  • 77
6
votes
4 answers

Excel "Refresh All" with OpenXML

I have an excel 2007 file (OpenXML format) with a connection to an xml file. This connection generates an excel table and pivot charts. I am trying to find a way with OpenXML SDK v2 to do the same as the "Refresh All" button in Excel. So that I…
Julio Guerra
  • 5,523
  • 9
  • 51
  • 75
6
votes
2 answers

How to add content control in a Word 2007 document using OpenXML

I want to create a word 2007 document without using object model. So I would prefer to create it using open xml format. So far I have been able to create the document. Now I want to add a content control in it and map it to xml. Can anybody guide me…
Anoop
  • 5,246
  • 6
  • 27
  • 29
6
votes
2 answers

Disable bold button

I want to disable "bold" toggle button in an Excel sheet. How can I do it? I have the following code but it's not working: CommandBarControl test = excel1.Application.CommandBars["Formatting"].FindControl(Id:113,Recursive:true); if…
user1853368
  • 61
  • 1
5
votes
6 answers

Office 2007 Style UI Ribbons: DevExpress or TMS?

Who provides the better solution for this particular component?
James
  • 80,725
  • 18
  • 167
  • 237
5
votes
4 answers

Is Office 2007 PIA deployment possible without Office 2007?

Does Office 2007 PIA also require Office 2007 to be installed? Can I deploy Office 2007 PIA with VSTO 3.0 (without having Office 2007 installed)? EDIT: I have a windows application that generates MS Word files. I have added the Office 2007 PIA as…
awaisj
  • 344
  • 3
  • 15
5
votes
1 answer

Saving multiple Word documents as HTML through Office API

I have a large amount of Word documents that I need to parse. As they all were created from the same template, I think that the best approach would be to save them as HTML files and parse the HTML itself. While it's quite easy to save a single Word…
Maxim Zaslavsky
  • 17,787
  • 30
  • 107
  • 173
5
votes
5 answers

Reasons behind Office 2007 UI

Since most of the people having to change from Office 2003 to 2007 in their office are confused, it amuses me if there is an objective reason for abandoning the good old interface of previous Offices. It would also be nice to have some backing facts…
ron
  • 9,262
  • 4
  • 40
  • 73
5
votes
1 answer

What form controls can a VBA project access from Office 2007?

In a VBA project, you can create a UserForm and add controls to it using the toolbox window. By default, the toolbox window contains the simple form controls such as Label, TextBox, ListBox, etc. You can add additional controls if they're installed…
Gary McGill
  • 26,400
  • 25
  • 118
  • 202
4
votes
1 answer

How to make my Outlook 2007 add-in trusted

I have a C#.NET Outlook 2007 add-in that has to access the address book to accomplish various tasks. However, every time on of these tasks has to access the address book I get the following warning dialog: A program is trying to access e-mail…
kmarks2
  • 4,755
  • 10
  • 48
  • 77
4
votes
3 answers

IFDEF equivalent in VBA

I have code that needs to run on both Excel 2003 and Excel 2007, and there are a few spots where changes in the versions cause the code to halt. I tried separating these lines out with If-Else statements, but the code won't compile on either…
Andrew Scagnelli
  • 1,584
  • 4
  • 18
  • 26
1 2
3
…
21 22