Yesterday I was trying to batch convert a group of PPTs into PDFs for a friend, and I decided to have a look at PowerShell, since it's been sitting on my HD for a while. Here's the code I've come up with. $p = new-object -comobject powerpoint.application # I actually don't know why I have to set the window to visible, # but it doesn'...
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? ...
I have code that needs to run on both Excel 2003 and Excel 2007, and there are a few spots where changes in the versions cause the code to halt. I tried separating these lines out with If-Else statements, but the code won't compile on either because it doesn't recognize the code used for the other. Is there any way I could tell one ver...
I have a user who has to use Microsoft Word 2007 to create and manipulate word documents in his ASP web application. I'm well aware of the 'Considerations for server-side Automation of Office' KB article and the many third party components available to do this kind of thing, but they've gone a fair bit down this road already. The proble...
Hi, Is there a way to remove tags from text, that was copy-pasted from Word 2007 on a server side (.NET) or client one (javascript). I need just text, without any formatting. ...
Hello... i've been dealing with this problem for quite a while: Our company develops addins for word/excel/ppt (both for 2003 and 2007 versions) One of the options our addins offer is to drag a table from the addin into the application. This is implemented in 3 different ways: Excel --> we create a tab delimeted string and drag-drop...
I know it is easy to display a counter on a webpage but I need to implement the same, ie, I need to write data to a cell in the Excel 2007 spreadsheet every time a person downloads it from my webpage. To be more precise, when the user downloads the excel file to his hard drive and when it is opened, I want the spreadsheet to display the ...
I am trying to take clipboard data copied from excel (i.e. tab seperated text) and parse it into a Collection of Dictionaries. The idea is that each row will be represented by a Dictionary which maps from headers to cell values. The first row in the copied data will contain the headers. Getting the text from the clipboard is easy enoug...
In the Word Object Model (version 12) there is a property called WordOpenXml on the Document object which returns a flat XML format representing the Open XML for the document. Details can be found at: http://msdn.microsoft.com/en-us/library/bb242889.aspx Is there similar functionality to be found in the PowerPoint Object Model and the E...
What are the changes for programmatically accessing Office 2010 documents (a.k.a Office 14)? ...
I understand from various web sources that documents stored in SharePoint 2007 and accessed by Office 2007 can be auto saved by a time setting. Usually it is referred to as the "Auto Recovery Setting" in Office 2007. Is this similar to Google's auto save "Draft" with a TimeStamp or a simple Telerik RAD Editor ASP.NET AJAX Solution which...
Amongst the swamp of documentation that is MSDN there is not an article to be found about the latest and greatest tools to be used in conjunction with Office 2007, specifically in the "VBA" department. We've been using old school versions of Office for many years and had to use VBA. Upgrading to Office 2007 was a prospect for the PDF t...
Folks, As part of our customization to MS Office 2007, we developed a number of custom theme files (.thmx). The only way we now to deploy the custom theme is to copy them into %appdata%\Microsoft\Templates\Document Themes, for each user to allow the user to see the theme under his theme gallery drop down. This is a not a problem for a...
I found a lot of nice icons from Microsoft Office 2007. Do you any idea for extract & save all icons as PNG files by using VBA? The following code is code which is used to get image from ImageMSO. Application.CommandBars.GetImageMso([name], [width], [height]) I can display all as PictureBox control and save excel file as web page....
I am using the WPF ribbon CTP from Microsoft. However, there is no sample. I am not sure where to start. The RibbonWindow does not have a property for the Ribbon. Does anyone have a sample that works? ...
Hello everyone, this is a serious problem I need to handle with I need to develop office 2003 and 2007 addins, both with .Net framework v2.0 Our company uses VS2008, which only allows developing 2007 addins under .Net v3.5 Does anyone knows of a way for creating 2007 addins unser .net frameworj v2.0? (**Using visual studio 2005 is no...
In .NET C# I'm trying to open an Excel template, add some data and save it as a new document. I'm trying to use the OpenXML document format. I can't seem to find any guidance on how to do this. Seems like all the documentation talks about how to write various parts to the Package but I can't find anything on what to do when you're done...
I am looking for examples of menus or toolbars that are shown without having to perform a right click. One example is the mini toolbar in Office 2007 which is shown automatically when selecting text. Are there any other examples out there of menus which are shown on a single click? I am looking for an elegant way to provide formatti...
I'm deploying an Outlook 2007 add-in being created in Visual Studio 2008 using C#. I've created a function to extract text from a word document. The problem is that about 20% of the time, this will temporarily grab focus and give it to my addin. I sat and watched sysinternal's process explorer for about 10 minutes while my add-in wa...
In windows 2008 server logged in as a user, When open a xlsx file with Microsoft Office Compatibility Service Pack 2 for Word, Excel, and PowerPoint 2007 File Formats. It is giving "the converter failed to open the file". If you logged in as a administrator then it is converting. For this added the identity of the user in Dcom config - C...