ms-office

Numeric precision issue in Excel 2007 when saving as XML

I am encountering a strange issue when saving documents in XML Spreadsheet 2003 format using Excel 2007. It seems to randomly change numeric values such as "0.58" to "0.57999999999999996". What's really odd is that you CANNOT see this issue when you are in Excel. You can only see this when viewing the XML data directly from a text edi...

How can I start MS Office Word from .NET without Add-ins?

I'm using MS Office 2003 PIA to create a MS Word document from c#. ApplicationClass officeApplication = new ApplicationClass(); Is there any way to specify that I don't want any office add-ins to be loaded using this method? EDIT: I know that one can do this via command line so I'm pretty sure there must be a way to do it from code:...

Word Document with images File size.

Hi, I am actually placing screen shots into the MS word document. When i save the document am not sure of which format the image is being considered. The size of the Document is becoming very large. Is there any option in MS word to save the document as a smaller file. ...

Outlook Add-in development issue

I am reading the book "Programming Applications for Microsoft Office Outlook : 2007". In the sample code.. private void Application_ItemContextMenuDisplay( Microsoft.Office.Core.CommandBar CommandBar, Microsoft.Office.Interop.Outlook.Selection Selection) { OutlookItem oItem = new OutlookItem(Selection[1]); //... } The...

VS 2005 against Office XP PIA on system with Office 2003/2007?

On my development system, I am running Office 2007, and previously had Office 2003 installed, and thus have the Microsoft Office 11.0 and 12.0 Object Models available. Our production environment is in the process of being upgraded to Office 2007, but it hasn't happened yet - still running Office XP in production, and I need to be able t...

Disable warning: You copied a large amount of data onto the clipboard

While debugging queries written in MS Access 2007 (problem was the same in all previous versions too), I'll run the query and then copy the results into Excel. Depending on results, I switch batch to Access to refine the results and go back into design mode of the query. At this point, I get an annoying warning: you copied a large amo...

Display Data from an Access Database in WPF Datagrid

Right, this has been bugging me for a good few days now and I'm getting nowhere. I think I need ot start it again from the begining. Basically I'm doing a project at school which requires me to store and manipluate data in an Access database (Office 2007 format, accdb). I'm using WPF with VB to do this, and I'm using the datagrid from th...

How to create a HTML link which forces MS Word to edit document on webdav server

Let's suppose that I have WebDAV-enabled server, where I have bunch of Office documents. I'd like to generate webpage which has link to document such that clicking on the link will open Microsoft Word. Word will in turn download document from WebDAV server, and when user finishes editing document, MS Word will upload it back. I know tha...

Creating a (ClickOnce) setup for VSTO Outlook Add-in

So I created an Outlook Add-in and used the click-once setup to deploy it. The setup runs fine when the user is administrator, but otherwise: no go. Running the setup with "run as..." and logging in as admin works, but than the add-in is installed under the admin, not the current user. The addin doesn't show up in outlook. I tried fo...

How do I disable/remove menu item "PowerPoint Options" in PowerPoint 2007?

I'm trying to lock down PowerPoint and I can get rid of some of the commands by using some ribbon-customization xml and group policies. But I need to remove or disable two more options. PowerPoint Options - This button shows when you click on the Office icon This item is also available in Word (Word Options) and Excel (Excel Options), ...

Application with no references to Office requiring Office 12 (2007) in GAC for ClickOnce

I have a situation where I'm trying to deploy an application update via ClickOnce to many users, but on some it's failing with an error saying that they need Office 12.0.0.0 in their GAC. This happened after I installed Office 2007, so I uninstalled 2007 and reinstalled Office 2003, then re-built/re-published the app. Fixed it for so...

Inspecting a Word mail merge data source programmatically

I want to iterate over all rows of a MS-Word mail merge data source and extract the relevant data into an XML. I'm currently using this code: Imports Microsoft.Office.Interop Do objXW.WriteStartElement("Recipient") Dim objDataFields As Word.MailMergeDataFields = DataSource.DataFields For Each FieldIndex As Integer In mdictMergeFi...

How to read author-information from an office file?

I have a bunch of office 2003 documents (.ppt, .doc, .xls) in a folder, and need to extract the "author" property from each file. What would be the best way to do this, is there some sort of (free) office-api I could use to read this information? I'm using .NET 2.0 ...

Help installing Visual Studio Tools for Office System

I have VS 2008 Standard and I'm trying to open a project that is a plug-in for Outlook, the project fails to load showing the message "C:\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\Office Tools\Microsoft.VisualStudio.Tools.Office.Office2007.targets was not found". The Office Tools directory is missing yet I have installed the Offi...

Use server settings to force IE to open Word documents in Word and not in IE

I've been beating my head against the wall trying to figure out how I can force IE to download and open a Word document in Word instead of opening in Word window embedded inside of IE. Googling around, all I can find are instructions like this one http://www.shaunakelly.com/word/sharing/OpenDocInIE.html which show how to configure the se...

Tools that Obfuscate .NET Microsoft Office Add-in

I'm working on a team developing a .NET Microsoft Office Add-in. We're looking at obfuscation solutions to help protect our licensing procedures. We're primarily looking at tools like Dotfuscator Professional and smartassembly. My first question is whether anyone has experience using smartassembly with an Office add-ins? Dotfuscator ...

Experience with "Add-in Express" tool for streamlining MS Office Add-in development?

Any experiences anyone can share about this tool? ...

python convert microsoft office docs to plain text on linux

Any recomendations on a method to convert .doc, .ppt, and .xls to plain text on linux using python? Really any method of conversion would be useful. I have already looked at using Open Office but, I would like a solution that does not require having to install Open Office. ...

.NET Deploying Office 2003 Redistributable Primary Interop Assemblies (o2003pia.msi)

Has anyone out there actually succeeded in creating a prerequisitie for o2003.msi? There are a lot of people out there asking about this, but I cannot find anyone who actually succeeded. I find some extremely complicated solutions where you are required to comple .cpp-files for which the soure may or may not be supplied. I even tried to...

No AttachmentRemoved event in Outlook 2003 object model...?

Hi I'm currently working with the Outlook 2003 object model in VB6. I'm trying to detect when a user removes an attachment from a message but although the model provides AttachmentAdd and AttachmentRead events, I can't see how to pick up that an attachment has been removed ? Any thoughts...? TIA Matt ...