Problem: I have two spreadsheets that each serve different purposes but contain one particular piece of data that needs to be the same in both spreadsheets. This piece of data (one of the columns) gets updated in spreadsheet A but needs to also be updated in spreadsheet B. Goal: A solution that would somehow link these two spreadshe...
Excel usually treats Conditional Formatting formulas as if they are array formulas, except when loading them from an Excel 2002/2003 XML Spreadsheet file. This is only an issue with the Excel 2002/2003 XML Spreadsheet format... the native Excel format works fine, as does the newer Excel 2007 XML format (xlsx). After loading the spread...
Businesses Analyst from my team keeps sending us the updated Requirements documents often and I end up hunting the recent changes by comparing the old version. Is their a good way of comparing the Word documents? Note: We have the track changes option ON, but now the documents looks like a blood bath, complicating it much more :( ...
Hi all, Can how I disable the Research Task Pane in MS Excel/Office 2003? Thanks for your help in advance, Donald ...
If you create a simple "Hello World" VSTO2SE add-in targeting Microsoft Office Excel 2003, it takes 15 seconds to load on a cold startup. During that time, Excel is completely unresponsive. The cold-startup time is always poor in Excel 2003. I have seen one test machine where the startup time is instant in Excel 2007, but all my oth...
Using VBA, how do I retrieve custom shape information from a Visio 2003 diagram. ...
Hi, I always read that it is recommended to set objects to nothing, once I am done. But I normally use them only in functions inside forms. Isn't the reference lost when the function scope is left? So where is the need to do: Set db = Nothing Set record_set = Nothing Cheers, Ramon ...
I'm embedding some Word documents into our web page using iframe like this: <iframe src="ftp://ftp.example.com/www/uploads/Image/test.doc" width="100%" height="400"> Alternative </iframe> The problem is that the embedded Word control allows the user to edit the documents and shows an icon to save them, but doesn't actually save ...
The Word documents I am trying to combine all have Headers and Footers, and I'm trying to combine them into one file while keeping the individual formatting of each document intact. I am using Word 2003 (XP Pro). I have tried a few different approaches already like placing the cursor in the Master document where I want to insert anothe...
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...
Hi Folks, I am trying to use a VBA macro (for Office 2003) to do the following: In Excel, the user will select a range of cells In Word the user will call the macro (via a button or shortcut) to insert the selected Excel range as an embedded object The code is not the problem so far, my problems are: Given that the user is working...
I am trying to convert a word report to PDF using Adobe distiller. Some of these word files have macros in them which shows a popup when the doc is opened and this stops the automation process. We tried disabling the macros' by wordApplication.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityForceDi...
Below is a procedure that I use to pull charts into a ppt from excel spreadsheets. However one thing I cannot figure out is how to insert the picture into the "object" instead of just pasting it onto th screen. (ie if I did a ppLayoutFourObjects, and sent fours charts to this slide, before adding another, I need to know how to paste the ...
I know this is a simple question for someone out there, but I have never really used function module at all because I did not understand what they were. So I have a whole bunch of things I can use this for (cut down on redundancy), but I want to know how I call call into into a sub (like a button click) procedure from a form. I tried t...
I can do a few things with powerpoint, but I need to learn more about the basics: -adding a new textframe and text, and placing it where I want to on the slide -how to use VB to control the master slide -add text to the notes field stuff like that. my experience with vb and ppt has been some automation stuff from access, but ppt is one...
We have a web application that displays a variety of document types to the user. When a user tries to view a docx file, they get a dialog box asking them if they want to save the file "DisplayDocument.aspx" if they are using Office 2003. I can reproduce this behavior and I've tried installing the Word Viewer and the File Type converter...
Hello, We're implementing SharePoint 2007 but have Office 2003 as our client. This causes problems when editing metadata since custom field types like BDC columns aren't represented properly within the Web File Properties dialog in Word. To get around this, we would like to disable the this dialog to force users to edit metadata with...
Is it possible to target Outlook 2003 in a vb.net 2008 Windows application when working on a system that only has Office 2007 installed on it? I downloaded the 2003 PIAs, but they wont install without Office 2003 installed first. The point is, I don't want Office 2003 installed on my development machine. Thanks ...
Howdy, Ive written a word addin in VS 2008 thats pretty simple, just adds a commandbar and a couple of buttons. The addin loads and works fine for the first document that is opened. When I open a second and subsequent documents, the addin does not load. Please ask for anymore info if needed. Happy to provide. ...
Hello. I have images within an excel file, that I need to manually extract. I have written a program which functions very well for our users with Excel 2007, but will not work with Excel 2003. Process: User Opens Excel File, Copies Relevant Image to Clipboard User Opens C# Application, Clicks Button Which Gathers Image from Clipboard, ...