I am programmatically creating a DOCX file using OpenXML SDK v2. One of the requirements of the document is it be protected to avoid editing. This is accomplished using the DocumentProtection object like: new DocumentProtection { Edit = DocumentProtectionValues.ReadOnly, Enforcement = BooleanValues.One, CryptographicProvid...
I have an MDI application written in C++ that looks great under Windows XP. All of the MDI child windows end up looking like their parent window. Nice. However, under Windows 7 (and probably Vista), the parent windows have aero glass, and the child windows are this hideous unchangeable baby blue color (same as the Windows 7 Basic them...
I am using 64-bit Vista and I need to migrate an access database, in Office 2007 to SQL Server. I don't want to have to write an SSIS package to do this, but that may be my only option. Is there any other way to do this? I have about 330M of data in Access that needs to be moved, so I can write a webapp to replace this database. Updat...
I have an In-house windows form app that I would like to use Spell Checking in. Everyone has Office 2007 installed so I shouldn't have an issue there but I am having trouble getting this to fully work. Here is what I have: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Word = Microsoft.Offi...
Hello! My problem is that I assigned a shortcut to Outlook like this: "C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE" and this worked fine and just like I wanted it to: when pressing the key I came back to this oneandonly instance of Outlook all the time. Then something happened and I lost this behavior with the shortcut key,...
I'm trying to dynamically customize the built-in Ribbon Controls on an Office2007 ribbon by adding C# objects such as RibbonTab, RibbonGroup, RibbonControl to the Ribbon. I have been unsuccessfull in disabeling any existing built-in controls, however I can add my own group. Now i'm thinking that disabling or hiding existing ones not be...
Hi all I am using the Project Professional 2007 now. I have a question that can I use the Macro to modify the .mpp file from a batch file. Best Regards, ...
Hi, I want to add an word import function to our CMS, the only problem I cannot seems to find a good library for reading docx files (Word 2007). Do anyone has some recommendations, the library should be able to extract content of the document and basic styling like italic, bold, superscript? Thanks for your help ...
Good afternoon, does anyone know whether it's possible to handle content changes or more precisely whether there's an event for that... one that would notify me if a document's content has been changed (ideally at what position/range etc)? Cheers and thanks, J ...
Hi. I need to make a difficult makro. When the makro has been activated (will happen via a button), it has to add a header and a footer to the document. Also page1/frontpage needs a different header and footer than all the other potential pages. So far, I have accomplished making page1/frontpage to work - somewhat. I did this by recor...
Has anyone delt with this exception from ABCpdf? We're running on Server 2008 and only have issues converting Office files (Word and Excel). This all worked well on Server 2003. Because we're only having issues with Office files I wonder if it's related to the XPS support on Server 2008? The code that calls into this function is runni...
Where do I find helpful documentation for VBA programming? something like SitePoint for HTML development. MSDN simply lists down and describes the operation and properties/methods of classes instead of explaining what they are used for, or when to use them. Books are also welcome. ...
Well I've been struggling with the little bit of code and can't seem to get around it ... I'm trying to get an array from a range of cells, the array however is showing up to be 1 element wide. Well here's the code: Dim item As Variant MsgBox Range("D19:H19").Count item = Range("D19:H19").Value MsgBox LBound(item) & " " & UBound(i...
Given Select Case cmd case "ONE": MsgBox "one" case "TWO": MsgBox "two" case "THREE": MsgBox "three" End select My requirement is if cmd = "ONE" I need "one" and then "two" displayed however currently I am getting "one" displayed and then the program is breaking out of the select case... ...
I have an ASP.NET web page that opens a requested file and writes it into response so that file is supposed to open in browser. It works fine, but with Office 2007 file types (.xlsx, .docx, ...) does not work properly. Basically, it returns nothing, an empty response, a blank response. Actually, it only happens in my live servers (Win...
I'm wondering if there's a way to manage VBA code authored in Excel 2007 using Visual SourceSafe? Office XP and 2000 apparently had 'developer additions' that supported this (e.g. http://msdn.microsoft.com/en-us/library/aa164419%28office.10%29.aspx). Is this support missing in Office 2007? ...
I am working on a C# application which opens Excel workbooks using Interop. It works fine except for one annoyance: when opening an Excel 2007 document on a machine using Excel 2003, a small message pops up saying "File conversion in progress". Does anyone know of a way to prevent that message from appearing at all? ...
Given the Image... If I know that there is some data starting at Range("B3"). How can I find the cells with contiguous data that is till cell E3? Since F3 is blank G3 onwards should not be considered. The result could either be a range object (B3:E3) or count of cells( 4 in this case). By setting B3 as the Active cell and doing.. R...
I have developed a simple C# Winforms application that loads MS-Word 2007 documents via COM automation. This is all very simple and straight forward, however depending on the document I need to programamtically Enable or Disable Macros as well as ActiveX controls. There is probably a way to store this in the registry, but I want to co...
Is it possible to code a plugin for the Office Communicator Client? I have seen code that lets me make my own client, but I want to just add functionality to the existing client. Can that be done? The plug-in I want to make would look for a string and if found substitute a link for it. For example: Go and find Question32 Would be c...