ms-office

How to register VSTO add-in from a Wix# MSI installer

I have built several Office add-ins (Excel, Word, PowerPoint and Outlook). I have also written a single Wix#-based MSI installer to install these add-ins. I have managed to do everything correctly but now I am puzzled how to register the add-ins. One can do this interactively by double-clicking an accompanying VSTO file in Windows Explo...

Programmatically add footer to Office Word/Excel document

I'm looking to build a solution similar to this one: http://esqinc.com/section/products/4/idocid.html What the system makes is insertion of a document file name into the document footer. How's that possible programmatically (preferably in .NET)? ...

Automatically adding rows to excel file template

Hi, I am running .net 4.0 asp.net app on IIS 7. I want to know if there is an easy way of adding rows to an excel 2007/2010 (not too fussed) template file that a user can download from the server. For example, the user might check a couple of tick boxes and clicks a button on the web page. The server does a sql query on a table and com...

Access to excel file in the server without installing excel

Hello, I've created a library to pass/get data to/from excel. To execute in my machine i modified the access permisions in COM+ console. The thing is that im interested in upload this component to my online server, but there i havent installed excel. Are there any way to register excel in COM+ without install excel? Thanks in adva...

Globals.Ribbons empty on Outlook addin startup?

I'm creating a plugin for Outlook 2010 using VSTO 2010 and .NET 4. I am using the XML method to design my ribbon because I need the context-menu hooks. Unfortunately, though the ribbon is created before the Startup event handler of the addin is fired, I can't access the ribbon using Globals.Ribbons.MyRibbon in the handler! I have added t...

Primer on ActiveX Controls

I would like to use an ActiveX control - almost exactly like Edraw - to load and edit MS Word documents in IE. I found this MS article and FramerEx; can I use FramerEx? How do I write the HTML to include FramerEx? Also, can you point me to a primer on ActiveX controls? Many thanks. ...

Document.SaveAs method ?

A template report with extension *.docm will be shown to user, he will modify it, and when he click the save button. I want to write the modified the document as accessionID.docm at the specified folder. What must be the object FileFormat = ?? private void btnSaveDocument_Click(object sender, EventArgs e) { if (m_docFileName == Re...

ActiveX control tab order in an Excel spreadsheet - is it possible to access/control this from script?

I have embedded a number of ActiveX controls in an Excel 2007 spreadsheet. Is there a way from VBA code to access the tab order assigned to a control so that the controls can be tabbed through in a particular order? The ActiveX controls I have inserted tab through in the insertion order, but this is not correct after changes have been ma...

How do I target a broad version of the Microsoft Office interop assemblies?

My dev machine has 2007 installed and the project references the corresponding version of PIAs but I would like my application to be able to run with 2003 at least when deployed. I tried setting the Specific Version property of the reference to false but this didn't work. My Visual Studio version is 2005, BTW. ...

Can I edit an office document directly from SQL Server?

Hi, I would like to build a Shared Documents Library in ASP .Net and SQL Server but I have a problem, the customer wants to open the documents (stored in SQL Server) in Office UI and when save it, the document should be saved directly in database like SharePoint Server. I've been researched on web since last week and I didn't found any...

How do I create an Excel range object that refers to a name in Excel (c#)

I have an excel worksheet with various names and I want to create an object that references that name. The code I am working with uses the cell address, but that is very cumbersome, and I would rather use the names. My code looks like this right now: myWorksheet= GetWorkSheet(myWorkbook); Excel.Range range = myWorksheet.get_Range(cell1...

Rich text box in an Office 2007+ ribbon control

I want to have a rich edit control on an Office 2007+ ribbon control from within an Office add-in. There is no rich text box in a VS2010 designer Toolbox. Is there a way to put a custom control in a ribbon or is there any other less straightforward way to accomplish this? ...

Syntax highlighting in MS Word

Is it possible to create a plugin or addin for MS Word that allows a section of text to be selected and then a custom "Highlighting" function to be applied to it. I want this to all be within MS Word not a cut and past from another application. If possible, any suggestions on where I could find some direction on how to do this ( using ...

Microsoft Ribbon for WPF vs. Office RIbbon UI

Microsoft released Microsoft Ribbon for WPF available for download here. We also have RibbonControlsLibrary.dll, which is a ribbon control too, available for download from Office sites. Currenty it is in CTP version. Now, which is the difference between these 2 version of ribbons ? Until now I identified that: MS Ribbon for WPF doe...

MS Word: How do I create Building Blocks efficiently?

I need to create a Building Block Gallery with defined Content Controls to make it easy for others to create word documents that would be ready to accept my data. I'm trying to make this as painless for the users as possible. I wanted to make sure all this would be professionally done and look good so I wan't to make sure all the Conten...

Windows Program to automatically print a Powerpoint to OneNote

I want to pretty much create a Windows application in which you can drag (View: http://yfrog.com/jkcapture3sdj) multiple Power point files into and it: 1.)Sends them to OneNote as a printout http://img690.imageshack.us/i/capture2vj.jpg/ 2.)Saves the file as shown below to a certain directory, and you can choose to save in either 201...

Viewing ACCDB with Access 2010 runtime when Access 2007 is installed

I'm hoping someone can either tell me what I'm doing wrong correct my flawed understanding of how this works and explain why it's not possible. I've been developing a fairly basic database/program for a client in Access. They have Office 2007, I have Office 2010. Initial test of creating a database in 2010 (in "2007" format) and opening...

create microsoft project file using C#

can I develop a c# application which uses Microsoft.Office.Interop.MSProject to create msProject files and then deploy that application on PCs which doesn't have microsoft project installed on them ? if yes please explain how . ...

How to substitute placeholders in word documents w/o office installed?

...title says it all p.s. it might be acceptable to use rtf and just rename extension to doc/docx/whatever. ...

Hide/unhide ribbon for Microsoft RIbbon for WPF release

MS officially released MS Ribbon for WPF. This release doesn't support theming, it comes with a default blue theme, Office 2010 look&feel. Office 2010 has a button that allows users to hide/unhide the ribbon, but the released version of ribbon doesn't has one. Is it implemented ? How can I add one? Thanks, Tudor ...