ms-office

How to create an automatic Revision History table in Word 2007

Is it possible in Word 2007 to create a revision history table automatically using track changes or some other method? e.g. Revision History DateVersionDescriptionAuthor 16/09/20081.0CreatedJohn Smith 17/09/20081.1Fixed dumb spelling errorsColin Jones ...

Initializing an array on arbitrary starting index in c#

Is it possible in c# to initialize an array in, for example, subindex 1? I'm working with Office interop, and every property is an object array that starts in 1 (I assume it was originally programed in VB.NET), and you cannot modify it, you have to set the entire array for it to accept the changes. As a workaround I am cloning the orig...

SVN revision in Microsoft Office

Hi, I have some code documentation in MS Powerpoint 2003 that I'm revision-controlling in an SVN repository. I'd like to auto-insert the latest revision number into this document whenever I open it. I am using TortoiseSVN. I've been able to google up a macro or two that might work but wanted advice from experts. :) Thanks! ...

XML Notepad 2007 breaks MS Access 2007 Help

I tried scouring the web for help on this issue, but there are so many generic words in there, that I couldn't find much of anything that was relevant. I have MS Office 2007 installed on Vista and later installed XML Notepad 2007 (also a Microsoft product). It seems that the MS Access help system is using some sort of XML format that X...

Example/How-To create calendar appointment using Exchange 03 Webdav and PHP?

I've been trying to figure this out for about two weeks. I'm able to create email items in people's folders, read the folders, all that stuff but for the life of me I can not get anything to work with the calendars. I can provide examples of the XML I'm sending to WebDav but hoping someone out there has done this and has an example? ...

Alternative to Excel's RefEdit control that can be used outside of VBA

The RefEdit control that comes as part of VBA is a little buggy, but it's good for putting on a form when you want people to specify one or more ranges of cells (i.e. Excel.Range objects). The main problem is that you can only use the RefEdit control on a VBA UserForm (Microsoft states this, and my tests confirm it too). I'm making an ...

Problem with MS Access, the clipboard and something called Biff5!

Hi, I have a legacy app I am currently supporting that is having problems when people copy large quantities of data from a datasheet view. The App is built in MS Access and the amount of rows being copied can get pretty large (sometimes in the thousands). The funny thing about it is, you can paste the data out, but then Access keep...

What was the first version of MS Office to officially support Unicode?

I am doing some research on Unicode for a white-paper I am writing. Does anyone remember the first version of MS Office on the Windows platform that was fully Unicode compliant? Not having much luck Googling this answer out of the net. ...

Which SharePoint 2007 features are not available to Office 2003 users?

I have been tasked with coming up with a compatibility guide for SharePoint 2007 comparing Office 2003 and Office 2007. Does anyone know where to find such a list? I have been searching for awhile but I cannot seem to find a comprehensive list. Thanks :) ...

Developing MS Word add-in

Hi, Anyone knows of a good tool for developing add-ins for Word in .net? Hopefully something that supports both office 2003 and 2007. Thanks. ...

Consistently retrieve "From" email addresses across Outlook versions

I am working a standalone c# desktop application that sends out documents and then imports them from Outlook when they are sent back. The application picks up the emails from a specified folder processes them and then saves the senders name plus other stuff to a database. This works well for Outlook 2003 and 2007 which has the SenderEma...

Use VBA in Office 2007 Applications?

Is VBA going to go away any time soon, like VB6 has? Should I not develop new Office applications with VBA? Or should I be developing all new Office Apps with VSTO? Update: Recently read this article. ...

Parsing Office Documents

I`d like to be able to read the content of office documents (for a custom crawler). The office version that need to be readable are from 2000 to 2007. I mainly want to be crawling words, excel and powerpoint documents. I don`t want to retrieve the formatting, only the text in it. The crawler is based on lucene.NET if that can be of ...

How do you get a spreadsheet to open Excel instead of a browser window?

If you call javascript window.open and pass a url to a .xls file it open on some machines in the browser window. How can you force it into Excel? ...

Unit Testing of .NET Add-In for Microsoft Office

Has anyone got any suggestions for unit testing a Managed Application Add-In for Office? I'm using NUnit but I had the same issues with MSTest. The problem is that there is a .NET assembly loaded inside the Office application (in my case, Word) and I need a reference to that instance of the .NET assembly. I can't just instantiate the ...

"Clicking" Command Button from other workbook

Hi I am trying to write a macro that would "click" a command button that is in another workbook.. Would that be possible? Without changing any of the code within that other workbook? Thanks a lot! ...

Renaming Objects in PowerPoint

Probably a very stupid question but I can't figure how to rename an object in PowerPoint.. For example all my Graphs are called by default "Graph 1" etc Could someone help me on that? Thanks! ...

Copy&paste from Office 2007 into <textarea>

I want to copy and paste text from a Office 2007 document (docx) into a textarea. On Window, using Firefox 3, there is additional jiberish that gets put into the field: ...Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Normal 0 false ...

How can I read MS Office files in a server without installing MS Office and without using Interop Library?

Interop library are slow, and need MS Office installed. Many times you don't want to install office on servers. I'd like to use Apache POI, but I'm on .NET. I need only to extract the text portion of the files, not creating nor "storing information" in office files. I need to tell you that I've got a very large document library, and ...

Good way to create PDF from Office documents in Java

I'm looking for a good way to convert Office (mostly Microsoft) documents to PDF in Java. I've been looking at using the OpenOffice SDK but from the samples I've looked at it looks like this requires having OpenOffice running in server mode to do the work. Does anyone know of a good way to do this? Good meaning the less external require...