My dad has a notebook and the key which has the "/?°" symbols acts like ctrl. Known factory problem. Anyway, his keyboard also has a "?" marked under the "w" key. Pressing "ctrl + alt + w" will display the "?" character (question, interrogation mark). Except on Office applications, like Word and Outlook, which will output "¿". I've se...
When I go over a text document ,I divide the content into different categories by highlighting sentences with different colors. I would like to have the ability to create a set of categories , and then go over the text and mark a sentence and assign it to one of the categories. and then have the option to see a filtered text, that conta...
I use this code to open refresh save and close excel file: Application excelFile = new Application(); Workbook theWorkbook = excelFile.Workbooks._Open(Environment.CurrentDirectory + "/WebGate", 0, false, 5, System.Reflection.Missing.Value, System.Reflection.Missing.Value, false, System.Reflection.Missing.Value, System.Reflec...
Background I am automating some Office application (Word and PowerPoint) via command-line tool. One thing my tool needs to do is locate all the running instances of Word. I know how to get a reference to one of the instances... Object running_obj = null; { running_obj = System.Runtime.InteropServices.Marshal.GetActiveObject(progi...
I read elsewhere (a response by "hazzen" here) that .NET has "a binding for the entire Office suite outlined here that allows you to write COM-based methods that you can call from Office. It is intended for automation, but you can write any managed code you want and have Excel call into it." I'm interested in the same thing for Java. My...
I'm trying to create a Shared Addin using VS 2008 for Office XP (Excel to be precise). However, after creating the project in Visual studio and changing the references to Office XP (apart from Extensibility which I don't seem to be able to find a copy for office xp) and adding excel.exe to the references as well. I now don't seem to be a...
The technique for adding a reference to the COM interop of Office in Visual Studio is to go to: References Add Reference Select the COM tab Select Microsoft Office 11.0 Object Library And magically named reference appears: Microsoft.Office.Core The Project.csproj file shows the details of the reference: <COMReference Include="Mic...
It seems if you try to reference the Office COM objects (as you would do in other development environments), Visual Studio gets it wrong - and it just won't work. So you must use the converted type library that Microsoft hand-converted and makes available for download, and download, and download. Now it seems that in order for my appli...
If i create a program, which in one small out of the way area, uses Excel automation: will the application fail when Excel is needed or will the application fail to start? Update Let me ask the same question, but in a more drawn out way: Will the application be usable by >99.9% of the users who never use the feature that require...
When i add a reference to Office COM Library, i to go: References Add Reference Select the COM tab Select Microsoft Office 12.0 Object Library And magically named reference appears: Microsoft.Office.Core The Project.csproj file shows the details of the reference: <COMReference Include="Microsoft.Office.Core"> <Guid>{2DF8D04...
Hi, I'm new to VBA and have been throwing together a small macro application for the Office. We've got about 80 users on essentially identical PC setups, and it will be accessed by all but a few users. I've been playing around with some automation of accessing web pages using the Web Services references, and I've also loaded the Micr...
Hi, I am working on a Word VBA macro app for 80 or so users. The office has high staff turnover, so training suffers, and so one of the self imposed requirements for this project is comprehensive, friendly documentation. However, to supplement this, and to save newbies having to open up a 100 page document when they want to try somethin...
One of my applications deals with MS Word and Document creation/editing/formatting. I am using Office 2007 w/ VS 2008, and i'm coding against the Microsoft.Office.Interop.Word library, which seems to work with either 2003 or 2008. I create a Textbox in a Document using the Document.Shapes.AddTextbox method, and then filling it with te...
We need a user control that can show Microsoft Office files (Word, Excel..). There is no need for editing them. As I can see, there are available standalone viewer applications that can be downloaded from Microsoft site, but I am wondering if it could be embedded within an user control. I think that there could be a COM/ActiveX compone...
I have an application that runs fine when executed off the server. When clients try to connect, they receive the following error: Failed to get data. *Data provider could not be initialized *SQL Server does not exist, or access denied on my Office Web Components (MDAC). I am guessing there is some security or server configuration error...
I am displaying Microsoft Office Web Components (Microsoft Data Access Controls) on my Sharepoint site. Clients need to enable "Access Data Sources Across Domains" in IE in order to view the page. Unfortunately, clients cannot modify their IE settings. Is there anyway I can get these components to display? ...
Hi, I have a question on how best to get xhtml into excel. let the user edit it in excel and then get back to xhtml at the end. The background is that I have a web app in which the texts are stored in xhtml. These I can export to an excel file with the html in the excel cell. I can also reimport this cell back to xhtml but the problem...
I am trying to do an automated xml export from an access database using C# and OLE. Everything is working perfectly except that the startup form is shown and won't close without user intervention. Here's what I am doing so far: objAccess = CreateObject("Access.Application"); objAccess.OpenCurrentDatabase("C:\\MYDB.mdb", true); //true ...
The company I work at is run on Excel sheets. Several of those sheets have some form of VBA code embedded. I'm doing some maintenance on them, but it feels really dated. What's gonna happen to Office VBA? Why hasn't Microsoft released an embedded .NET macro language for Office? ...
The following piece of code shows an Insert table dialog: Dialog d = WordApp.Dialogs[WdWordDialog.wdDialogTableInsertTable]; int result = d.Show(ref missing); if (result == -1) // if user pressed OK { d.Execute(); } The problem is that the dialog does not respond to mouse clicks. It responds to keyboard input, though. Moreover, i...