I am trying to use the Office COM components in order to create Word and Excel documents. Unfortunately I can not achieve this because I am getting an error. Cannot find IDispatch for '{00020906-0000-0000-C000-000000000046}' in module '{00020905-0000-0000-C000-000000000046}', v8.3 I tried reinstalling Office, my applicatio...
Hi I need to find out what would be a recommended Citrix Server setup (memory, cpu and network hardware) for up to 100 users (both LAN and WAN) concurrently. They will be using the server mainly for the following purposes: running MS Office (mainly 10-15 MB Excel files) exporting/importing data to/from a SQL database on another serve...
First of all, my question is not quite the same as http://stackoverflow.com/questions/370407/is-office-2007-pia-deployment-possible-without-office-2007 I am not looking to use the PIA's yet. The IT engineers would ideally like to deploy the 2007 PIA's to everyone's computers before they upgrade Office 2007. This way there is fewer thi...
I have installed the 2007 PIA and repaired my Office 2007 installation. Still, when I add a reference to the Office 12 Object Library in VS2005, I only see Office.Core and cannot add an 'imports' statement for Office.Interop I have checked that Windows\assembly\gac\ has got the interop dlls. ...
Hi, If I add a simple Sql Server table data connection to an Excel worksheet, can it lock that table if the connection is never closed? ...
Hi all, I've had someone else's pile of stuff handed to me. Among these items is a Word 2003 add-in (VSTO 2005 SE, .NET 2.0) that reportedly had been working fine in 2007, but our deployment environment calls for 2003. It installs apparently fine for Office 2003 -- no errors, shows up in add/remove -- but the toolbar is unavailable with...
I'm developing a Desktop Search Engine using VB9 (VS2008) and Lucene.NET. The Indexer in Lucene.NET accepts only raw text data and it is not possible to directly extract raw text from a Microsoft Office (DOC, DOCX, PPT, PPTX) and PDF documents. What is the best way to extract raw text data from such files? ...
I need to load about 60 images, each on a different page, in to PowerPoint. Does anyone know of an "automated" way to do this. I don't want to go through slide by slide, and have to click "load image" on each one. If it was a one-time thing, I wouldn't worry about it, but we're summarizing results from some analysis that is ongoing a...
I am working on an add-in for Microsoft Expression Web. I have gotten enough information on the web to know that I have to add references to Microsoft.Expression.Interop.WebDesigner, Microsoft.Expression.Interop.WebDesignerPage, and Microsoft.Expression.Interop.WebDesigner. The problem is that there does not seem to be any official doc...
Hi, all! How to check from WordprocessingDocument wherever word document is empty? ...
Is there a way to programmatically create PowerPoint presentations. If possible I'd like to use C# and create PowerPoint 2003 presentations. ...
I am trying to build a VSTO add-in for Expression Web 2. There are Add-in templates for Word, Excel, Project, PowerPoint and so on but nothing that I can find for an add-in project template for Expression Web 2. I have hacked together my best guess of what it would look like, but Visual Studio 2008 keeps erroring out with the message...
Hi there, whats the name of the main document component (blank space) when you create a word office 2007 project? Is possible to set text on that container? for example: text from a database's query ... thanks Answer : using(DataClasses1DataContext db = new DataClasses1DataContext()){ var x = (from va in db.INFO...
In Word 2007, a user may update the applied styles by selecting the "Reset to Quick Styles from XYZ Template" in the Change Styles menu option. Does anyone know of a way to automate this? I tried adding a macro to the Document_Open() method in the VBA for the Template project, but it errors out. ...
I want to find a string in a word document and delete everything after it. What is the best way to do this without using the selection object? Thanks ...
Can I trap the mouseover somehow, of an object in PowerPoint. In my PowerPoint addin, I want to be able to know when the mouse is over which object. The objects are not activex, they are built-in standard objects (pictures, etc...) for any powerpoint. I need to do this in design mode, of the presentation, not in run/presentation mode. ...
I have a small programme that opens and closes a number of different word documents while it runs. It loads some documents from the web so it takes a little while and I'd prefer to let the user watch a little progress bar or at least have a message in a form telling them to wait. I can't seem to be able to keep that form on top of all o...
Hello, I've started using MOSS 2007's wiki feature for storing the ongoing technical documentation related to a project I'm working on, and it occurred to me after I started writing a few pages that there's no easy way to export out all of the pages into one document. For those of you familiar with MOSS 2007, any ideas how this might b...
This is basic stuff, but I'm somewhat unfamiliar with VBA and the Word/Access object models. I have a two column database of about 117000 records. The columns are 'surname' and 'count'. I want a user to be able to type SMITH in a textbox and hit submit. I then want to run something like SELECT table.count FROM table WHERE surname = str...
Using VBA, how do I retrieve custom shape information from a Visio 2003 diagram. ...