office-2007

Problem opening Office 07 documents in SharePoint 07 library with read-only permissions

The call center managers for my company use document libraries in a SharePoint 2007 site to post training material and information to our phone reps. These reps are given read-only access to the libraries as to not change the documents posted by management, however we find that if management uploads an Office 07 document (either docx or...

VSTO Outlook AddIn disabled in Vista

We have an issue with an Outlook 2007 AddIn (created on a Windows 7 development machine with Visual Studio 2008/VSTO). It installs with the MSI installer on these machines: - the development machine - a Windows XP machine Install initially succeeded on a Vista machine, but after installing an updated version of the AddIn, it gets disa...

VSTO Development with Office 2003 and 2007 installed side-by-side?

Does VSTO 3.0 (using Visual Studio 2008) support both Office 2003 and Office 2007 installed side-by-side on a single development computer so that both Office 2003 and Office 2007 can be targeted (in separate solutions)? I have seen conflicting information about this. NO: http://msdn.microsoft.com/en-us/library/bb398242.aspx Visual ...

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 when people ask about rationale of change. For example I would be interested in: Was t...

Is there any way to access the control templates used by office 2007

In WPF, the default scrollbars are boring light blue controls, however I noticed that Office 2007 has some really nice scrollbars with animated color transitions. Does Microsoft provide these visually pleasing scrollbars in WPF? (Via a template or any other method) ...

Using Office 2007 PIA's against OpenOffice.Org

I have been using Office 2007 PIA's to run PowerPoint files in my C# application. I know that this requires Office 2007 to be installed on the machine. I wanted to know, can the same set up be run with OpenOffice.org installed instead of Microsoft Office? Note: I am using a Qindows machine. ...

SharePoint problem: opening a office 2007 document tries to open as a zip file

I have a number of Office 2007 documents (.pptx, .docx, .xlsx) in a SharePoint document library and when user tries to open the documents, it tries to open as a zip file. This happens to some users, but not all. I posted this issue at http://superuser.com/questions/110211/why-office-2007-documents-open-as-a-zip-file, but I failed to me...

How to build an Office Add-In without registering it on the build system?

We are building Office 2007 add-ins using Visual Studio 2008. Our builds are performed via a continuous integration server (one machine) that builds whenever we check in changes or manually request one. The server can perform simultaneous builds. We noticed that when Visual Studio 2008 builds an Office 2007 add-in, it also registers i...

In VSTO Excel, how to detect data in cells?

I was wondering if anyone knew how 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 to figure this out. I am writing an importer that will import data right into the active worksheet (if it has not been modified), or create a new worksheet and ...

Office Addin terminates host while using WCF

It took some time to solve this and the conclusions are interesting. Our Office (Word/Excel/PowerPoint) add-in sends a request to our custom WCF service, the hosting Office application terminates, leaving this entry in the application log: Provider: .NET Runtime EventID: 1023 Level: 2 Task: 0 Keywords: 0x80000000000000 Channel: Appl...

How do you hyperlink to Word 2007 help pages?

I want to hyperlink to a page within the Word 2007 Object Model Reference documentation, that ships with Word 2007. These are webpages that use the ms-help:// protocol that Firefox cannot understand. So I wanted to specify the ms-help:// path of the help page as a command line argument to the viewer, CLVIEW.EXE. C:\Program Files\Mic...

Display Sharepoint ContentType in Office 2007 Document

Hello! I have a customer that want to display the sharepoint content type in a (Word) document. The main reason for this is that they create many different kind of documents and they want the type of the document to be the shown in the header when they print it. For some reason i´m unable to insert the information through Insert-> Quick...

Open XML SDK to edit Active document

Hello, Is it possible to use the Open XML sdk to manipulate parts of document which is currently open in the ofice app (word/ppt). I know the easiest thing is to use VSTO, but its slow and would involve clipboard use to insert elements, the OXML sdk is direct and simpler. If somebody could post some code sample that would be great. Th...

Excel workbook event order and usage when closing Excel

Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving operations say wb2? Note: Please provi...

Problem with Office 2007 MIME Types, they download as *.zip in IE all other Browsers ok...

We have a custom CMS running on Tomcat, we added the following config: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet .xlsx I can download those Excel 2007 Files without Problems in FF, OP, Chrome, Safari. But in IE I get a Download Box for a ZIP File. I changed IE8 Settings to recognize Filetypes from Fileextension...

Visual Studio 2008 Create Word 2007 Template Project Crashes

I've got this weird crashing happening when creating a C# Word 2007 Template Project in Visual Studio 2008. The IDE tells me that it's creating the project (it does create the solution and C# vsproj as well as the dotx and cs files). Then the IDE just crashes - no errors, messages, etc. When I try devenv /SafeMode it still doesn't work. ...

Access / Excel crossover: Should i attach spreadsheets to records

I currently have an archaic system of client records that I am trying to improve. For each client i have a directory, in that directory i include a directory for each job. Each job has a spreadsheet that i use to store their personal details, and run calculations and costings specific to their needs. In turn I also have word documents t...

Some languages don't work when using Word 2007 Spellcheck from Interop

I'm using the Word 2007 spellchecker via Interop in a VB.net desktop app. When using the default language (English), it works fine. If I set the language to French via LanguageId, it also works. But if I set it to French (Canadian) (Word.WdLanguageID.wdFrenchCanadian), it doesn't work. There's no error message, it simply runs and says t...

Merge Word Documents (Office Interop & .NET), Keeping Formatting

I'm having some difficulty merging multiple word documents together using Microsoft Office Interop Assemblies (Office 2007) and ASP.NET 3.5. I'm able to merge the documents, but some of my formatting is missing (namely the fonts and images). My current merge code is shown below. private void CombineDocuments() { object wdPageBr...

Best solution for exporting Word documents to PDF programatically (without using a "software printer")?

I'm looking for a way to export a Word document as a PDF. I would like to do this without the use of a "software printer" (such as CutePDF, etc.) and stick to reference assemblies if at all possible. I'm using Microsoft Office Interop Assemblies to generate a Word Document which I save to a temporary directory. So its not necessary for t...