ms-office

Legacy VBA Solutions are not working in Office 2007

Folks, An existing system that was based on VBA was installed on a machine that has Office 2007 and it didn't work, the issues I faced are : A PowerPoint Add-in (.PPA) is no longer able to create the custom buttons in the shortcut menu, did Office 2007 change the commandbar names ? The MSI (written in Wix) didn't install the files in ...

What are some techniques for generating PowerPoint presentations without using Office Automation?

While it is possible to generate PowerPoint presentations automatically using Office Automation, this is not recommended for use on a server. How can you go about generating a PowerPoint presentation without using Office Automation? ...

Handling Events for late-bound objects

I would like to use MS Office automation and have event handlers that fire for user-triggered events. For example, if the user clicks the save button in Word, I want to intercept that event and execute code in my program. I don't want to be bound to a specific version of Word because I don't know what version my user will be running, so...

Office clipboard format

If I copy a graph from Excel (2007) and choose Paste Special in another Office app, I see a clipboard format called "Microsoft Office Graphic Object", which allows different customizations than Enhanced Metafiles. How do I create such a clipboard object from my own (C++) app so it gets the first-class treatment from Office app? It's not...

Where does Outlook store which PST files are mounted?

I'd like to programmatically add a PST file to a person's Outlook profile. I found some code here: http://www.eggheadcafe.com/community/aspnet/65/10030171/try-this-code.aspx While that does the trick, it still leaves the question - "Where does outlook keep this list of mounted PST files?" Is it in the registry? A config file somewhere?...

Document is not updated after check in from Word

Hi, one of our customers has great problems checking in documents to a SharePoint library form Word 2007. Whenever she check's in a document to the library the meta data as version number and checkin comment are updated but not the document itself. The library is configured in such a way that versioning is activated and documents have...

Copy to excel from VB.Net app causes a 0x800A03EC error in some environments.

Here is the error: System.Runtime.InteropServices.COMException, Paste, Exception from HRESULT: 0x800A03EC All machines are Windows XP with the same version of Excel (2003). Some machines get the error, some don't. We have yet to find a pattern. Here is the code: Public Shared Sub ExportToExcel(ByVal dt As System.Data.DataTable) ...

VBA - How do I remove a file from the recent documents list in excel 2007?

The recent documents feature in Office is really useful, but I moved a file to a new directory and now I can't get Excel to stop hitting me with a "can't find this file" notification whenever I open a workbook. The Excel options seem only to control how many of these "recent documents" are displayed and not how many are actually saved. ...

MS Office PIAs "backward compatability"

Hi there, I just wanted to know something. I've successfully completed a WinForms app with MS Word integration - the app writes to mergefields in a Word Template. I did the template using MS Word 2007, but saved it in compatible mode as a 97-2003 '.dot' file. Due to the fact that I have Office 2007 installed, I'm using version 12.0 of...

How do I access some sort of OnLoad event in Word 2007 VBA?

Hello, I am trying to have some code fire when the document is first loaded, but there are two problems. First, I don't know which method to call to get something to fire when the document is first opened. Second, if they have macros disabled, how can I be sure that it gets called when they are enabled? Thanks! ...

What do sites like Google Docs and Zoho Writer use to generate MS Office documents

I realise this may just be speculation, but I'd appreciate comments from anyone who has some insight into this. Something like MS Word COM add-in, or an OO bridge, or a custom implementation. The reason I want to know is that I want to provide basic online document editing (really basic, basically just rich text at this point) for a ph...

NET code to "listen" to an office application (get the events raised by the user)

I am on the verge of remaking an application for e-learning. But now I want to take this new version to a new level. So this the scenario: a user opens up my app. He/she then chooses to be trained in one of the most common MS Office applications (Word,Excel,Outlook, etc). My app will give the user instructions on what to do: create a n...

how to check MS office version installed on the machines .

I am working on a console app which perform some operation on registry. I am not using any interop assembly for office but i need to to know office version. How to determine which version of MS office is installed on the machine using C#. ...

How to disable shadowcopy for VSTO version 3?

According to this http://blogs.msdn.com/vsod/archive/2008/11/01/office-customization-creates-loads-dll-from-temporary-folder.aspx "Before VSTO version 3.0, there is no way to disable Shadow copy feature in VSTO." But how do I disable shadowcopy for VSTO version 3? ...

Reporting charts and data for MS-Office users

We have lots of data and some charts repesenting one logical item. Charts and data is stored in various files. As a result, most users can easily access and re-use the information in their applications. However, this not exactly a good way of storing data. Amongst other reasons, charts belong to some data, the charts and data have some ...

Application.ActiveInspector() is Null on Outlook Ribbon Load

Is it possible to access the ActiveInspector at the time of ribbon load. Application.ActiveInspector() returns proper value when I use custom form but does not for default contact form. I need the ActiveInspector to customize ribbon button depending on a property value in ActiveInspector().CurrentItem. ...

How to programatically tell if a word document is corrupt?

I've got a little C# application that interops with word converting a bunch of word .doc files into textfiles and for the most part this works fine. However, if the document is currupt then word cannot open the file and a dialog box pops up, which means that I cannot fully automate this conversion process - someone has to watch for the ...

Easy database userface

I have a simple SQL Server database that we use for conversions. Basically a table with two mor more columns where one value maps to another. We then have processes that use these tables to find matching values and select other values on that row. These values change a lot and we now need a interface for the business users to update the...

using axspreadsheet in vb.net

hello, i am having an awful time with axspreadsheet for vb.net 2008. the simplest example is i just add the control to the form. it compiles on one computer, but it doesnt compile on any other computer. i may be missing a reference or a prerequisite but i have searched for about 10 hours, and i have not gotten any insight into this. than...

web components axspreadsheet in vb.net not compiling

has anyone seen this error with compiling web components in vb.net? i added axspreadsheet on to my form and it does not compile. it gives me the following error. please help! System.InvalidOperationException was unhandled Message="An error occurred creating the form. See Exception.InnerException for details. The error is: Class not r...