ms-office

How to change Word.Range text without losing format

Hi, Anyone knows how can I change the text of a Word.Range object but still keeping it's format? For example if I have "this text" and I change it to "that txt", txt will still be in bold. I'm looking for a way to change the whole text of the range, not just a single word, as I'm getting the new text from an independent API, I can assu...

Can I compare two ms-access files

I want to compare two ms-access .mdb files to check that the data they contain is same in both. Is there any tool or library exists for this type of comparison? ...

Is there a coding standard for VBA applications?

Is there any coding standard published by microsoft for vba applications? ...

Vista, Office Interop not working

Does anyone know how to get the MS Office 2007 .NET C# Interop libraries to work with Vista? I have a .NET C# application that I have setup to run as a Windows service. This program will open up a Word or Excel template depending on the situation and modify its contents and then save the document back out. All of this worked great ...

How can I send output to an external/second display in Java?

I would like to be able to emulate the functionality of the "Presenter Tools" in MS Office. This requires the program to be able to detect and use an external/secondary monitor/projector. Could somebody please point me in the right direction for achieving this. I would like to use Java 1.5 Thankyou. ...

How to I attach to a VSTO Excel Application Process to Debug?

I've got a Excel VSTO 2005 application I need to debug, I've tried attaching to the process EXCEL.EXE in Visual Studio 2005 to no avail. Does anyone know what to do in order to debug managed code running in a VSTO Excel Application? ...

Excel 2007 Hangs When Closing via .NET

I have a Visual Basic .NET program which needs to open and close an Excel spreadsheet. Opening and reading the spreadsheet work fine, but trying to close the Excel 2007 application causes it to hang. It seems to close, but if you look in the task manager the application is still running. The code that I'm using to close it is wbkData...

VSTO: Why is OfficeRibbon.Context null?

I'm developing my first Word 2007 addin, and I've added an OfficeRibbon to my project. In a button-click handler, I'd like a reference to either the current Word.Document or Word.Application. I'm trying to get a reference via the OfficeRibbon.Context property, which the documentation says should refer to the current Application object. ...

How do you comment an MS-access Query?

What is syntax for adding comments in an access query? ...

Is Visual Studio Tools for Applications part of Office 2007?

The VSTO bit I understand. Visual Studio has the project templates to get you started with creating nice .NET based add-ins. But where is VSTA? I installed the SDK but it seems to be gears towards adding extensibility to your own applications. I had thought that VSTA was like the new VBA for Office 2007. Infopath 2007 seems to be VST...

how to insert value into a cell in Excel sheet using asp.net

How to insert data into a particular cell in a Excel Work sheet in Asp.net ...

RevNum field set to 2 by Word 2007 or SharePoint

After "checkin" of a .docx file to SharePoint and editing it the RevNum property is set to 2. Why? This does not make sense (imho) --hfr ...

Is there any way to authenticate user in a ms-access database?

I have a MS-access database. But it is on the shared drive. And it is required that only some selected number of people can use it. Is there a way to authenticate the user? ...

Tool to merge MS Word files

I have huge number of Word files I need to merge (join) into one file, and will be time consuming to use the Word merger (one by one). Have you experienced any tool that can handle this job? ...

ms office file extensions

I made a discovery some time back. Just follow these steps: Create a .doc/.xls/.ppt file in office 2003. Keep some test data in there and close the file. Now rename the file to change it's file extension to a random string, taking care that it is unassociated, like test.asdfghjkl etc. Double click the file and it opens seamlessly in the...

What is the adoption rate for Office 2007?

This IS a programming-related question. The actual numbers should guide how we build our app. ...

How do I create a filter for Microsoft Excel?

I want to add a file type extension to the Open Dialog of Excel (2003, 2007 if possible, 2007 only, if necessary). When the user opens my type of file (i.e. myfile.myx), I want my application to read the file and paste the file into Excel in my own defined manner (by using Interop) ...

programatically convert word docx to doc without using ole automation

i'm looking for a way to programatically convert word documents in docx format to doc format without using ole automation. i already have a windows service that does this but it means installing office on a server and it is a little unreliable and not supported. i am aware of the aspose.words product, and i will try it out, but has any...

Is it possible to develop plugins for Microsoft Office Communicator?

Is it possible to develop plugins for Microsoft Office Communicator? If so, where does one start -- is there an SDK? ...

Excel 2007 VBA and WMI - Current DOMAIN\USER

...