ms-office

Accessing same-named COM-entities from .NET assemblies

Hi to everyone. I've got a tiny (I hope) problem again, and I don't know how to obtain access to some presentation properties provided by PowerPoint (however I don't even know how to google it or search it at the site :( ) from C#. Let me explain. We can access a TextRange property both in C# and VBA, via an interop assembly and ms-offi...

C# Microsoft Office Developer help, tutorials, examples

As a developer I get different assignments and my current one involves interaction with Microsoft Office from C# - which I haven't been doing for a long time now. Having previously developed websites using ASP.NET, I found the site www.asp.net/learn very helpful. Is there a similar site concerning Visual Studio vs. Microsoft Office deve...

COleSafeArray / VARIANT memory leak?

I want to export a lot of (table) data to Excel. I'm developing on Windows Xp, Vs2005. I'm filling a COleSafeArray, which was initialized like this: safeArray.Create( VT_VARIANT, 2, numElements ); // 2 dimensional, 30000 rows, 3 columns Now the filling is really fast, but in TaskManager/Process Explorer/VMMap, it looks like some of th...

Embedding objects into Microsoft Word and OpenOffice Writer

I am looking for some references on how to implement the following feature: ability to embed objects (e.g. diagrams) into word processors and being able to edit them in their respective "mother" application For example, MS Word and Visio work like this together, allowing the user to easily edit/tweak the diagrams after adding them ...

Missing Microsoft XML schema mystery

I downloaded the XML schema's for Office 2003 from Microsoft's download site here so I can validate Excel documents that people upload to our app. Turns out that they don't work. I receive errors where it can't resolve the type like this: org.xml.sax.SAXParseException: src-resolve: Cannot resolve the name 'udcxf:File' to a(n) 'element ...

Beginning VSTO Development

I'm quite confused with what are the necessary tools for VSTO develpment. Specifically I want to manipulate Excel 2003/2007 documents programmatically. I did quite a lot of VBA before, if you want to relate any answer to that. Few questions I have about VSTO: Can I use Visual Studio 2008 Express Edition C#/C++ for this? Do I need to h...

Drop-down list in Excel cell

Hello gentlemen, I have a simple Excel speadsheet where in one column i write string values. What I need is to define some predefined values and instead of typing string select it from dropdown list. For instance for a column Store Name I want to select "Reebok", "Adidas" and so on. I understand that there can be several ways how to im...

Display HTML page in Office 2003 or 2007 task pane via VBA

Is it possible to display an HTML page in an Office 2003 and/or 2007 task pane via VBA? Background: We have a complicated configuration file that our users maintain in Word (using a real editor is not an option for our audience). We would like to create several toolbar buttons that display a basic HTML page in a task pane as a form of ...

Office Open XML Format file creation

i want to open a new xl sheet thru ofice open xml format. and how to export the datatable records to that xl sheet without loop. ...

Using Python to program MS Office macros?

I've recently taken it as a project to teach myself how to program in Python. Overall, I must say that I'm impressed with it. In the past I've typically stuck to programming in VBA mostly for MS Excel (but also a bit in MS Access and Word) and have struggled to find ways to make it do things that Python can easily do with a single comm...

Displaying SpreadSheet (OpenXML) cell styling in ASP.NET

I would like to display Excel SpreadSheet on the webpage. Seems like when I am using ADO.NET I can only access to data but is there some way so I can also know which rows/cols are formatted in special way like headers? ...

Bullet indents in PowerPoint 2007 compatibility mode via .NET interop issue

Hello. I've got a really difficult bug and I can't see the fix. The subject drives me insane for real for a long time. Let's consider the following scenario: 1) There is a PowerPoint 2003 presentation. It contains the only slide and the only shape, but the shape contains a text frame including a bulleted list with a random textual repr...

Using Clipart from MS Office in my program

I found a clip art from MS Office that I want to use in my program. Is this legal? I don't see any license to MS Office clip art anywhere. ...

Detect whether Office 2010 is 32bit or 64bit via the registry

Now that Office 2010 also comes in a 64bit install, where in the registry do you find out if the version of Office installed is 32bit or 64bit? ...

MS Office no longer works as BLOB

Hi does anyone know why MS Office such as doc, docx and xls can no longer be viewed when retrieved from a mysql db when stored as Blob? The doc and docx used to download and open without any problem, but now it no longer recognises the file format. ...

How to find name of currently opened MS Office document?

I want to find the name of office document(any like exel,word,access...etc) which is currently open on my operating system. It all is done through my C# code. If any one have any idea on that, so please share it. I created Shared add-in for that and also record the opening, closing time of that document and the time which the user spen...

how to load add-in ?

I have one silly qus. i created one shared add-in in c#.net. This add-in is working fine. now i want this add-in is load again n again when any office application is opened. For e.g. when i open any MS word document then add-in is load for that and if after that i opened another MS word document without closing previously opened document...

how to Add-in load again n again for every instance of an application?

I have one qus. i created one shared add-in in c#.net. This add-in is working fine. now i want this add-in is load again n again when any office application is opened. For e.g. when i open any MS word document then add-in is load for that and if after that i opened another MS word document without closing previously opened document then ...

How to find the name of multiple files opened on system by unique id?

I want to know about the name of all currently opened MS-Word file by its unique id. I found unique id for one file but when I gave its destination path in code. My requirement is that when any user open Word file then the unique id of this file is passed into my code and through this code the name of this file is stored into database (...

Custom XML in Word documents

Microsoft lost another patent lawsuit (see also here) and I feel the pain too. I relied on the pink tags to have some attributes associated with text spans in a word documents. Such attributes were saved in the xml as custom tags. Now, as soon as my customer upgrades Office suite they will loose the pink tags. Can you think of what feat...