merge word documents from excel macro Excel Hello, I want to create a marcro in excel that allows me to merge different word documents. Can anyone point me in the wright direction? Thanks Lieven Excel Programming Discussions Microsoft Word (1) Word (1) Macro (1) MergeWordDocs (1) CreateObject (1) StrFiles (1) IntTemp (1) WrdNew Set wrdNew = wrdApp.Documents.Add strFiles = "c: \ 1.doc, c: \ 2.doc, c: \ Quick Response SLA.doc" For intTemp = 0 To UBound(Split(strFiles, ", ")) Set wrdDoc = wrdApp.Documents.Open(Split(strFiles Yes - -- -- -- -- -- -- -- Jacob Skaria Forgot to mention that the previous post works only if you refer 'Microsoft Word xx.0 Object Library' from VBE> Tools> References. OR othewise use the below version Set wrdNew = wrdApp.Documents.Add strFiles = "c: \ 1.doc, c: \ 2.doc, c: \ Quick Response SLA.doc" For intTemp = 0 To UBound(Split(strFiles, ", ")) Set wrdDoc = wrdApp.Documents.Open(Split(strFiles

How to format an if statement? Microsoft Excel Hi Guys, Facing a difficulty. Here is my formula: Column Name: MET SLA = IF(P2< = U2, "Closed Within SLA", "Closed Overdue") (Due On)P2 = JUL-11(Format: Custom) (Month Closed)U2 = JUL-11(Format will return me "Closed Overdue". Is there anyway to format the formula in column "MET SLA" = IF(P2< = U2, "Closed Within SLA", "Closed Overdue") so that it will return accurately W / O changing the format in Column P and U as those columns are generated from another source. Thanks Guys! Jordache Microsoft Excel (1) Date (1) Disable (1) Conditional formatting (1) You can do this a couple ways

How to put a WORD Doc into Excel Excel First, please I know this is bad, but my manager has made this requirement. I am trying to take my Word Doc and place it into an Excel Spread sheet. This document has bullets and numbering. What I am running into is cells scheduled maintenance window being exceeded by 2.12 hrs causing us to miss the batch SLA. To date, the following quality improvement was implemented in response to this incident. 1. Tech is a management thing not mine. I would have left it in word. - - Lizette Koehler Excel Miscellaneous Discussions Microsoft Excel (1) Excel (1) Word (1) Worksheet (1) TEXT (1) ROW (1) TopAlso (1) Technicians (1) Excel has

Deploying web apps using Excel interop assembly I've created an asp.net web application that opens and creates an Excel worksheet filled with data from a dataset (uses reference to Microsoft Excel 11.0 Object Library). When I run the project on the laptop it was created and then run the project either from a client pc or locally on the server, Excel does not open (there are no error messages). I've checked the IIS authentication on the server and also Excel is installed on both the server and client. Using .NET framework 1.1 and IIS is XP Pro and server is Windows Server 2000. Any ideas anyone? Cheers Nadz 1) Excel isn't installed on the server, so interop libraries aren't going to help you I run the project locally on the server I get no errors but still no Excel. I'll keep trying and post any success I have. Try specifying the domain of

Excel 2003 - Macro for Deleting Rows Excel Greetings, Still using Excel 2003. Now that I have a macro that will delete rows, AND do it from his search from there, but figured that there HAS to be a way to get Excel to set that row number as a variable, then have the macro use that number gone down this many rows" and set that as the 'rowEnd' variable. Any ideas? Solon Excel Programming Discussions Microsoft Excel (1) Excel 2003 (1) Excel 2007 (1) ActiveSheet.Range (1) Macro (1) PV (1) XP (1) SearchTerm