While using Microsoft Excel 2007, something weird happened and all the names after the nth row change to ABCD and I saved the file by mistake. How do I bring back the old names which have changed to ABCD? ...
Greetings, I'm working on a preview handler for Office 2007, Vista and Windows 7. I'm basing my code off the following MSDN article. The "guts" are done as it was pretty straight forward. I've been testing in Windows 7 (64-bit) Explorer. One thing I've noticed is the preview handler appears to "lock" the Explorer window and doesn't al...
I used to convert Word documents to PDF via Word Automation: Enumerate the CommandBars until one containing "PDFmaker" was found, enumerating its controls and executing it. With Word 2007 this no longer works - although the PdfMaker Com Addin is installed and accessible via the Acrobat menu. PDFmaker is required for quality reasons. T...
I have a form with a default view of a chart. This form is loaded as a subform, the data is dynamically filtered by the parent form. It comes up and looks way better than using a chart object (when the form scales the chart object it looks really bad). My question is this. I have been able to find little information on the chartspace o...
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...
Hi! I discovered a problem related to Word documents (with macros) hosted in an IIS virtual directory. Here is an example of a document with macro: http://sites.google.com/site/wjatjoi/ExemploErro42482.doc After countless tests, I got the problem with replicable success on any computer. It occurs in a very particular situation: 1 - ...
I'm currently writing a process that generates Powerpoint reports programmatically from a given template using the MSXML library via VBScript. The only manipulation of the XML I'm doing is to duplicate slides, insert data into the Excel datatables for charts and a couple of title-text text replacements. I'm testing on 2 templates which a...
The below connection string establishes connection with excel file which has extension as '.xls' but same string throws an exception while opening a connection with file which has extension as .xlsx. Any idea? ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\abcd\Desktop\demo.xls; Extended Properties=excel 8.0;...
In our Office add-in we need the ribbon buttons to behave the same way as regular Office ribbon buttons do when you resize the form: as the form becomes smaller, some images also become smaller, then disappear altogether. I have no idea how to do the same for our custom ribbon group, the buttons always stay the same. Please note, this i...
Hi! I have developed an application level add-in for Outlook targeting Outlook 2010 and .NET 4 and I want to run it on Outlook 2007, which should not be a problem due to the new "no pia" feature of .NET 4 (see this blog post). However, after deploying the add-in with my Windows Installer package (the same package works for Outlook 2010...
Hi, I'm attmepting to change the background colour of each page in a word document - similar to changed themes/backgrounds in a powerpoint. Its creating a photo gallery ready to print, and I'd ultimately like to use word not powerpoint because of the other people working on this ( they're not as technically minded as myself). Is this ...
Is there a way to develop custom SmartArt for PowerPoint. I'm not looking for a way to develop "fake" smart art, like add a bunch of shapes and then group them and copy/paste between presenations. I'd like to create a number of new SmartArts that are based on this kind of fake SmartArt that my company uses, but have it "smart", like hitt...
I have a large amount of Word documents that I need to parse. As they all were created from the same template, I think that the best approach would be to save them as HTML files and parse the HTML itself. While it's quite easy to save a single Word document as HTML, I haven't found a way to do a bulk procedure from inside Word. Thus, I'...
I've gone through the tutorials on how to create a custom ribbon with Visual Studio. I see that you can export your Ribbon XML. Is it possible to utilize this ribbon with another document? Do you have to use Visual Studio at that point or is there a way to embed the custom ribbons into another document? (without VSTO) ...
Hello, here is my problem with the execution of an excel formula. These are the requirements: I have several lines in an excel sheet. At the end of each line there is a field called "Month". If someone enters new values in this line, the current month should be inserted. If the values get modified, the month must not be changed. T...
I have a VS 2010 Excel 2007 Workbook application. I have a ListObject that is bound to an object data source via a binding source. I want to be able to determine what property of my object any given ListColumn obect in my ListObject's ListColumns collection is bound to. In the example below I use the column name to find the column that i...
Hi, I created a custom ribbon tab for PowerPoint 2007. The tab contains a dropdown box and a button. In the button's callback (onAction) I would like to execute different codes depending on which item is selected in the dropdown. However I do not know how to get a reference to the dropdown control from the button's callback. Is there...
So here is my issue. I am currently writing a User Guide using Word 2007 where each section has some validation checkboxes to help the consumer implement the solution and track his progress. I have been able to create Word Checkboxes that can be clicked on using Developper>Legacy Tools>Checkboxes and then Protecting the Document to onl...
I've been checking out what is possible with the Office Open XML specification for documents. I'm particularly interested in being able to add custom XML content to a document and binding it to content controls. I was wondering if it is possible to have a repeating content control type? For example, say I have some custom XML in my .d...
We are embedding a word control inside of a winforms app, and need to hide and disable the ribbon on Office 2007 and 2010. Is it possible to hide/disable the office 2007/2010 ribbon programmatically using the office interop dlls? Is there another method available to do this? ...