Sum calculation

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Can't see my macro in toolbar on some machines Hi. I have a .doc file (word 2002) that basically creates a copy of itself with a module I have created. Some fields have been merged with a database. I'll refer to the copy as B. BUT ... in doc B, I get the macros to show up on a toolbar from the original copy on some workstations. They also do not exist if I try to add the macro by customizing the toolbar. Though if I go into the code on B document - the macros are there. I have set the security to low and it doesn't help. How do I get these macros to show up on the 2nd document? Any suggestions appreciated....need these sent out today. Thanks in advance. Lesley Tag: Sum calculation Tag: 79374
  - 2
    - Best Control for list of records in Access I want to do a query on a table based on the last name selected from a combo box. So the after update on the combo box should use the value as a part of a query. I dont know what control I should use to list the results of a the query. Ive read that you cant bind a listview to data (query). I want to be able to click on the record in the result set I want and have the id of that record populate a control on the form. So what control can I use that will allow me to click on a record in a list and grab the value of a column in that list? Any examples of creating a query and using that query to bind to a control? Im on Access 2003 on Win2k3 server. Thank you for your time. Tag: Sum calculation Tag: 79370
  - 3
    - Deletion of Empty Page in the Word Document through VBA Hi all, This is to request for your help in this MS Word issue. In the VB application we are required to copy and paste temporary documents (containing text, pictures, etc) into a single, final word document. The main document contains tables and the issue is related w.r.to tables. In the current application, the .rtf file is formed from the html file. While copying, the blank pages get inserted in the document if the control is in the â??last but oneâ?? row of a table and sometimes if the control is in the last row during document generation process. This causes the extra page in the document and page numbers are counted for this. We are working on Windows 2000 Server as our OS. In the existing code, section breaks (Next Page) are used. I am trying to scan each and every page and finding if any empty page is there. If so, I have planned to pass the delete key to delete the empty page. Could you provide any pointers as how to go about this? I need to scan each and every page of word doc and need to find if any blank page is there. If so I need to delete the page programmatically. Any help in this issue would be greatly appreciated. Regards, Kiruthiga.S Tag: Sum calculation Tag: 79366
  - 4
    - Document Properties - vbscript Looking for a way to read document properties for a Word Document. In particular I want to be able to read the "revision number" -- . Tag: Sum calculation Tag: 79361
  - 5
    - Finding version of word used to create document Where is the version of Word used to create a document stored in the Word object model? It's not Application.Version - this is the version used to read it. Simon Kravis Tag: Sum calculation Tag: 79357
  - 6
    - Not able to recording macro for mail-merge Hallo, I need some help for a macro code ... we've a lot of Word2000 mail-merge templates originally connected to a .dbf file where in a textbox is possible put the number we're looking for , now we've to move to Word2003 and the new source will be a SQL file with the same structure At the moment we use a code like this: ActiveDocument.MailMerge.DataSource.ActiveRecord = wdFirstRecord Set myMMData = ActiveDocument.MailMerge.DataSource If myMMData.FindRecord(FindText:=TextBox1, _ Field:="COLLAB") = True Then myMMData.QueryString = _ "SELECT * FROM `COLLABORATORI` WHERE ((`COLLAB` = '" & TextBox1.Text & "'))" With ActiveDocument.MailMerge .Destination = wdSendToNewDocument .MailAsAttachment = False .MailAddressFieldName = "" .MailSubject = "" .SuppressBlankLines = True With .DataSource .FirstRecord = wdDefaultFirstRecord .LastRecord = wdDefaultLastRecord End With .Execute Pause:=True End With Unload Me Application.ScreenUpdating = True Else MsgBox ("Codice non trovato !!!") -- I tried to record the piece of code to be replaced in the existing macro but I wasn't able to ... Thanks in advance for your help Regards, Alberto Simone Tag: Sum calculation Tag: 79356
  - 7
    - Mac Preferences folder location - finding from VBA I'm porting a large VBA project to the Mac, and most things seem to be working just fine. In my Windows project, i use a .INI file to store settings. My installer creates that file in the Windows folder, calling a system function to retrieve the location of the Windows folder. On the Mac, I want to store the same file as a settings file in the System Preferences folder. How do I call into the Mac OS to find the path to use for the preferences folder? Thanks in advance g Tag: Sum calculation Tag: 79342
  - 8
    - Fields in header and update using VBA Hello all, I'm trying to automate some fields in the header and footer by making a VBA userform and having it plug into document. While I can use document vars to plug in values in the regular bodytext and use activedocument.fields.update to show the new values, this won't work for header and footer fields. I would need to view the header and footer and refresh manually with F9. Any suggestions? Thanks Tag: Sum calculation Tag: 79340
  - 9
    - template keeps locked very strange? Hello, I have a macro in a dot file that runs when I open a document with that network template (g:\wmv\r6.dot) attached. The dot file is on a network and I want to copy it local so the network template isn't locked when a user has a doc open with that template attached, so it can be changed. It works fine and the local template is attached. But the network template keeps locked with a tilde (~) before it so the doc keeps two templates locked, the local (as expected) and the network template. Is there a way to release the " ghost" attached network template? Below a example of the code: Sub AutoOpen() WordBasic.CopyFileA FileName:="G:\WMV\r6.dot",Directory:="c:\temp\r6.dot" ActiveDocument.AttachedTemplate = "c:\temp\r6.dot" End Sub Thanks a lot Tag: Sum calculation Tag: 79336
  - 10
    - Form Automation I am tring to create a form that will check or uncheck a box next to a signature line to indicate if the signature is required or not. I have several fields that are calculated. The best I can do is using another field with a formula in it like "=OR(OR(euro_total>0,swan_total>0),genus_total>0)" this results in a 1 or a zero. I would rather have this as a checked or unchecked box. Any ideas? Right now I am assuming I need to use VBA for this hence my previous post. Tag: Sum calculation Tag: 79334
  - 11
    - Need to learn VBA for Word Looking for a book or resource that would "really" help users learn how to program VBA for word. I have been to Barnes and Noble and came away frustrated. The books I found talked about various vba subjects but did not explain it in simple terms and supply a list of vba commands that could be used. For the benefit of all of us can a suggestion be made for the Beginner, Novice, Intermediate, and the expert. Suggestions please. Tag: Sum calculation Tag: 79332
  - 12
    - Finding which cell in a table I am using WORD upwards, please can someone help me with some code which sets as an integers the table number, row number and cellnumber is the activecell? Mark Tag: Sum calculation Tag: 79330
  - 13
    - Copying data from one table to another Hi there, I have been tasked with setting up an Access database to track 4 similar (but different) entities. Under certain circumstances entities B & C could metamorphose into entity A. Is it possible in Access 2002 to have a button on an input form that will replicate most (but not all) fields from entity B (or C) over to the table containing entity A? Entity A will be indexed via an auto-number â?? will this add extra complexity when trying to copy other entities over to it? Iâ??m familiar with database theory & basic Access but havenâ??t previously designed & implemented a dbms in Access. Any responses gratefully received Regards Phil Tag: Sum calculation Tag: 79318
  - 14
    - Is the bullet of a list considered to be a range? Is the bullet of a list considered to be a range? And how do I check if a certain range is actually the bullet of a list? Tag: Sum calculation Tag: 79314
  - 15
    - word 2003 bookmark/data extraction - new functionality In prior versions of Word (pre-2003), users have created word templates with bookmarks. They enter value into the bookmark range. Then we have a program that extracts the bookmark range value and we use that data for other things. Does Word 2003 offer any other functionality that would replace this? Tag: Sum calculation Tag: 79313
  - 16
    - inheritence Hey guys.. I have been working on this for about 4 hours and got nowhere.. How can I stop word tables from inheriting previous styles set... Fopr Example I set a proeprty SpaceBefore from a range object for a cell to 6... Then all the other cells in that column inherit that value.... Could someone tell me why and how to fix this... thanks nathan Tag: Sum calculation Tag: 79312
  - 17
    - border Hey list, I am trying to set a border for a couple of rows in my table My table has 4 columns and x rows.... the code below will only yield a a border on the bottom row of the table.... how can is et particular border for particular rows.... so far I have tried this WordRow.Cells.Item(1).Range.Borders.Item(Word.WdBorderType.wdBorderBottom).LineStyle = Word.WdLineStyle.wdLineStyleSingle WordRow.Cells.Item(1).Borders.Item(Word.WdBorderType.wdBorderBottom).LineStyle = Word.WdLineStyle.wdLineStyleSingle WordRow.Borders.Item(Word.WdBorderType.wdBorderBottom).LineStyle = Word.WdLineStyle.wdLineStyleSingle WordRow.Range.Borders.Item(Word.WdBorderType.wdBorderBottom).LineStyle = Word.WdLineStyle.wdLineStyleSingle I have also set the BorderWidth Property and visible property and color property... When I open up my document there is only a border on the bottom table row.. any help would be appreciated thanks... nath Tag: Sum calculation Tag: 79309
  - 18
    - MS-Project VBA Question Hi NG , I am new in the field of VBA and have a question / problem. In one project file I defined a field ( customized field Number 13 ) and renamed it as "StatDur" and entered a formula there in. With VBA I want to read out the contents of this field and display it via MsgBox. Ihave entered following code num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13, pjValueListValue, 3) Syntax is : Ausdruck .CustomFieldValueListGetItem(FieldID, Item, Index) Thats my code entered in VBA ( as above ): num = Application.CustomFieldValueListGetItem(pjCustomTaskNumber13, pjValueListValue, 3) I want to store the contents of this field from row 3 in num and want to display it via MsgBox. It wont work since the VBA-Editor brings a failure where I am entering the row number 3 as Index and I dont know why and how to solve this problem. Can onyone give a helping hand. Thanks in advance Gruß -- Cevikel Tel. : 0911-433-6329 mailto:halidun.cevikel@siemens.com Tag: Sum calculation Tag: 79308
  - 19
    - I would like to add hebrew lanquage to my translation list I would like to add hebrew lanquage to my translation list Tag: Sum calculation Tag: 79303
  - 20
    - Protecting and unprotecting form fields I have a form that I saved as a template, so that I can insert it into various documents. I have written code that inserts this form using a macro that does that and also opens a userform. The form has bookmarks and form fields with options and drop downs that only work when the form is protected. I need the form unprotected so that I can insert information from the userform into specific bookmarks, but then need it protected after that, so the form field options and drop downs will work. Is there code I can run in the userform when the form is inserted that will unprotect it until the infomation is sent to the bookmarks, and then code I can run to protect the form so the form field options and drop down will work when I exit the userform, or do I have to manually open the toolbars from the [View] [Toolbars] [Forms] menu? Thanks! -- Bill Tag: Sum calculation Tag: 79301
  - 21
    - Finding Out What the Current Section Is For the life of me, I can find a way to determine what section of the document the current selection is in. It seems like a simple task, but somehow, I just can't seem to get the syntax right. I'm using a macro to build a document, and I want it to do one thing if the current selection is in Section 2 of the document and something else if it isn't, as in: If Current Section = 2 then Do one thing Else Do something else End If I need this macro to work in Word 2000, XP, and 2003. (We can't seem to get everyone on the same version.) Any help that you can give will be most appreciated. Larry Tag: Sum calculation Tag: 79300
  - 22
    - call to a DOS command from VBA I am new to VBA I need help with calling a DOS command from within a VBA 6 code. Here is an example: Suppose I need a list of files in a folder. One can do it using DOS dir command like Prompt:> dir drive:\path\foldername > drive:\path\list.txt The file list.txt output file created contains all file names in foldername, plus some other info. I have written a vba code for Word to *clean* the list.txt file, such that it now only contains the names of files in the foldername folder. The question I have is: can one write a stand alone *application* or a Word addin, such that it starts with a user form in which one can browse to a foldername as a source and say cleanlist.doc as the output, and on closing the form, the dir command is executed, the list.txt file cleaned with my code, and the cleaned output file placed into a path\cleanedfile.doc file? I know how to open, create and close files from a vba code. I do not know how to call a dos command from vba and how to make a form with controls that allow to browse for a source and destination folders. Any reading suggestions? Thanks, -- JanAdam Tag: Sum calculation Tag: 79299
  - 23
    - inserting tables Hello List, I have been trying to work this for a while now, i can;t seem to get it working... I am using word automation to insert tables into my document from a bookmark range. The problem is when I loop to isnert a table each table will insert into the first row and column of the previous table. Here is my code below For I = 1 to 20 InteriorRange = Doc.Bookmarks.Item("InteriorBuilding").Range ' range obj InteriorRange.InsertParagraphAfter() RoomTable = Doc.Tables.Add(InteriorRange, 3, 2) ' doc a reference to the current document RoomTable.Cell(1, 1).Range.InsertAfter("tst item") RoomTable.Cell(1, 2).Range.InsertAfter("test") RoomTable.Cell(2, 1).Range.InsertAfter("test") RoomTable.Cell(2,2).Range.InsertAfter("test") RoomTable.Cell(3, 1).Range.InsertAfter("test") RoomTable.Cell(3, 2).Range.InsertAfter("test") RoomTable.Cell(1, 1).Merge(RoomTable.Cell(1, 2)) Next Any help would be greatly appreciated thanks very much nathan Tag: Sum calculation Tag: 79298
  - 24
    - Arrangement of carries Hi There is a document with the table of several rows. How for some rows of the table to resolve a hyphenation and for the some rows to not resolve? Tag: Sum calculation Tag: 79290
  - 25
    - Missing keystrokes on custom document I have a custom Word document, from a template, that catches WindowSelectionChange to modify data that is input by the user into table cells. All works well except when more than one Word document are open. The problem exists whether the other file is based on the template or not. When switching between docs, the first keystroke is lost. This behavior is also repeated when changing cells as long as two or more documents are open. Below is the relevant code: Option Explicit Public WithEvents App As Word.Application Dim thisTable As Integer Dim thisRow As Integer Dim thisCol As Integer Dim lastTable As Integer Dim lastRow As Integer Dim lastCol As Integer Private Sub Document_New() If App Is Nothing Then Set App = ThisDocument.Application End If keepAlive End Sub Private Sub Document_Open() If App Is Nothing Then Set App = ThisDocument.Application End If keepAlive End Sub Private Sub App_WindowSelectionChange(ByVal Sel As Selection) Dim myRange As Range Dim mySel As Selection Dim myText As String If Not ActiveDocument.AttachedTemplate = ThisDocument Then Exit Sub thisTable = Macros.getCellLoc.tableNum thisRow = Macros.getCellLoc.rowNum thisCol = Macros.getCellLoc.colNum If (Not Selection.Information(wdSelectionMode) = 0) _ Or (thisTable = lastTable And thisRow = lastRow And thisCol = lastCol) _ Or (thisTable < 4) Then Exit Sub End If If lastTable = 0 Then lastTable = thisTable lastRow = thisRow lastCol = thisCol Exit Sub End If If lastRow > 2 _ And lastCol <= ActiveDocument.Tables(lastTable).Columns.Count Then Set myRange = ActiveDocument.Tables(lastTable).Cell(lastRow, lastCol).Range myRange.End = myRange.End - 1 Select Case lastTable ' Removed End Select End If Select Case thisTable ' Removed End Select lastTable = thisTable lastRow = thisRow lastCol = thisCol End Sub Function isEditable(row As Integer) As Boolean If row < 3 Then Selection.Collapse Selection.MoveDown Unit:=wdLine, Count:=3 - row Selection.SelectRow Selection.Collapse isEditable = False Else isEditable = True End If End Function Sub keepAlive() If App Is Nothing Then Set App = ThisDocument.Application End If Application.OnTime When:=Now + TimeValue("00:00:01"), Name:="keepAlive", Tolerance:=0 End Sub Tag: Sum calculation Tag: 79285
- Next
  - 1
    - page numbers using sections - how do you get physical page number? Section 8 - Page 1 of 4 is Physical page 84. how can i get the Physical page number. I want to use both section page numbering and phycical page numbering. exsample: Section 8 - Page 1 of 4 Page 84 of 132 I am using MS work 2002. Tag: Sum calculation Tag: 79283
  - 2
    - What files do I need? Hi all, I wrote a VB6+VBA program that uses both WORD and EXCEL to generate reports. In a machine without WORD (for example) - my program wont run, because it cannot create word objects. I wish to know what files to include (must + allowed to) in the package I deliver to the client. Thanks in advance. Guy Tag: Sum calculation Tag: 79282
  - 3
    - Getting the user profile folder Hi I need to get the signature folder for the current folder such as; "F:\Documents and Settings\Dave\Application Data\Microsoft\Signatures\" except that instead of Dave I need the correct name for the current user, s that my code works generically regardless of who is logged in. Is there a way to do that? Thanks Regards Tag: Sum calculation Tag: 79279
  - 4
    - Template VBA form and Code Missing Hi out there. I am Access programmer just learning VBA in Word. I spent last two days learning how to develop an input form use the VBE, controls, command buttons, etc. And I also added code to add data to combo boxes, initialize defaults, etc. This was all done at my client site. I returned to my office, and via gotomypc, I downloaded a copy of the template. When I open the template, the bookmarks are there, and document stuff. But no vbe form, or controls, or code. In access, I just move a database and everything goes with it. Help -- microbus Tag: Sum calculation Tag: 79277
  - 5
    - Get user info from AD with VBA Hi, I,d like to create a Word template that reads current user information (such as name, addresses, phones, department and so on) from Active Directory. I've searched the Net without luck for code samples. Do you know where I can find examples for this kind of solutions? Best regards, Dominique Tag: Sum calculation Tag: 79276
  - 6
    - Why isn't template with macros located in startup folder not loaded? Hello, I've written a template containing macros. Now, a user of this template complained to me that it won't load automatically even if located in the startup path. It can be loaded during a Word session via "Tools->Templates and Addins", though. Unfortunately I don't know which word version my user is using but she wrote that changing the macro security settings had no effect. So what else can cause this? Christian -- Christian Zietz - CHZ-Soft - czietz (at) gmx.net WWW: http://www.chzsoft.com.ar/ PGP-Key-ID: 0x6DA025CA Tag: Sum calculation Tag: 79267
  - 7
    - Inserting Excel charts "as link" into Word Please advice: I have Excel workbook with many charts (20-30). I need to insert all charts in the Word document (in the same order that in Excel). To perform this I saved Excel â??as WEB pageâ?? and after that I use the macro command to insert all the pictures from pictures folder into the Word. Now I have to insert all the charts â??as linkâ??. How can I do it? Sample code would be great. Thank You. Eduard Tag: Sum calculation Tag: 79262
  - 8
    - Macro to convert revision text to ordinary formatted text Does anyone have a macro they can share that does this? To clarify what I need, the macro will convert revisions in text written with change tracking to ordinary text with underscores and strikeouts. My email address is LLM041103 at earthlink dot net. Tag: Sum calculation Tag: 79258
  - 9
    - How to download microsoft word I purches a lap top from Dall, but it did not have microsoft word on it. I was trying to download it. Please help me to do that. Thanks Tag: Sum calculation Tag: 79257
  - 10
    - Creating Module that Runs When Document Opens Word 2003. I want to create a subroutine or macro that runs when my document is opened. How may I set this up? Thanks for the help. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org Tag: Sum calculation Tag: 79253
  - 11
    - Only A-z in range selection I have a macro that goes through documents and deletes spaces that were accidently inserted in the middle of words. How can i make it so that the range selection, that's a spelling error, can only be alpha characters? Tag: Sum calculation Tag: 79250
  - 12
    - Create TOC for comlex Chapter pages I'm writing a book. The Part and Chapter pages are distinct from other pages, and employ complex styles. I'm having trouble get the TOC right. The Chapter page is like this: --------------- 1 <--- The Chapter Number (Style: "H2", auto-numbered) Introduction <--- The Chapter Title (Style: "My Chapter Title Style") to This Topic --------------- Part Number and Title are similar ("H1", "My Part Title Style"). Now, I inserted TOC using H1/H2/H3. Obviously, only Part/Chapter Numbers are show in TOC; I need the Part/Chapter Titles there as well. How to do this? If w/o programming, even better; if programming, how to do this? Thanks a lot in advance! -James Huang Tag: Sum calculation Tag: 79248
  - 13
    - Formatting All, This question is simple but someone can help me out i have a checkbox and a label, when user selects the checkbox, the caption of the checkbox (aaaaaaaaaaaaaaaaaaaaa) and label caption (abc...etc) should be printed in the document here label caption is spread accross 4-5 lines, how i want to see in the document is aaaaaaaaaaaaaaaaaaaaa (checkbox caption) abcccccccccccccccccccccccccccccccccccccccccccccc (label caption) abcccccccccccccccccccccccccccccccccccccccccccccc abcccccccccccccccccccccccccccccccccccccccccccccc when i used vbtab control in the code (strbody = strbody + chkbox caption + vbtab + label caption) the result is aaaaaaaaaaaaaaaaaaaaa abccccccccccccccccccccccccccccccccccccccccccccccccc abccccccccccccccccccccccccccccccccccccccccccccccccc abccccccccccccccccccccccccccccccccccccccccccccccccc Pls help. Tag: Sum calculation Tag: 79246
  - 14
    - Automatic Document Template & Userform checkbox I have designed a document template and userform. On my userform I have placed several text boxes and a "chkHistory1" checkbox. There are several other checkboxes also but I need help on 1 so I can do the rest. I have on my document template a checkbox with a bookmark named "History1". When I finish entering information and have placed a check in the checkbox "chkHistory1" on the userform then click OK everything prints on my new document except my checkbox. I am relatively new to VB and I need some help. I have tried several different codes and I'm lost. Tag: Sum calculation Tag: 79245
  - 15
    - Find Error? When using VBA code to find "U.S." (for example), the Find range returns four words with the first three being as expected ("U", ".", "S"). However, the last word may contain not only the final period but also the next character in the document if the next one is a space or another puncuation mark such as ".)". The user interface version of the Find does not do this. Is the code version a bug or have I overlooked something? Tag: Sum calculation Tag: 79240
  - 16
    - Can I use a Macro within a Word Formula? How? Currently, I use a formula to interpret a bookmark used in a form to display a converstion. The formula is currently one of two options, so I use an if statement. I would like to change it to one of 20 options. I would like to use a Macro and pass thh bookmarked value to the Macro and have the Macro return the value. Is this possible? how? Tag: Sum calculation Tag: 79239
  - 17
    - How to call a module for returning an excel picture to the .ActiveDocument.Bookmarks("bookmarkname") Hello all I created a module which copy an area of excel cells (e.g. A45:D51). How can I call this module and use .ActiveDocument.Bookmarks("bookmarkname") to paste the copied area of cells into the Active Word document under the bookmark? If a module is returned a text string, I can use .ActiveDocument.Bookmarks("bookmarkname").Range.Text = ModuleThatReturnText How about the module which has already copied a range in Excel worksheet and want to paste it under the bookmark? Cheers Bon Tag: Sum calculation Tag: 79236
  - 18
    - Word Font Size in VBA Help Can anyone suggest an easy way to increase the font size of an entire document (including headers/footers) by a certain percentage? I know I can do it by going through word by word and setting the font size to the original font size multiplied by a factor, but this seems slow and tedious. Is there a better way? I have a document that needs to print in different font size under dofferent circumstances and I do not want to maintain two versions of it. Any ideas? TIA -- ---------------------------------------------- Posted with NewsLeecher v3.0 Final * Binary Usenet Leeching Made Easy * http://www.newsleecher.com/?usenet ---------------------------------------------- Tag: Sum calculation Tag: 79233
  - 19
    - Saving a document in multiple locations at one time. I would like to be able to save a single document in multiple folders at one time. So I guess that means all these folders must be linked. Thanks Tag: Sum calculation Tag: 79231
  - 20
    - word intellisense? does anyone has sugestions for creating intellisense in word just like the visual studio intellisense? for example, writing a specific tab after writing a word will open a combo box with all the related words from the DB. i know there is a way to do this with vsto 2005, is it possible in 2003 and does anyone has sugestions on how to do this? Tag: Sum calculation Tag: 79228
  - 21
    - Scheme-text-fields inside textboxes - tab-order issue? Hello I scanned a scheme with text-fields and I am using it as a background in a word document. As I want to use the scheme-function in word, I have added text-boxes (to accurately fit the textfields to the scanned background) with scheme-text-fields inside of the boxes. The problem is; Using the tab-key to move between the boxes is a pain in the ass, as one have to press tab 2 times to move between the first two fields, then 4 times to move to the next field, then 4 times to move to the next field, etc.. How can I change tab-key-sequence/order?` Thanks, =D8ystein Tag: Sum calculation Tag: 79226
  - 22
    - original settings? My MicrosoftOfficeWord 2003 program has all sorts of strange settings on it as soon as i open a new document. I wonder if there is any way I can change everything back to its original settings when the program was first downloaded? Tag: Sum calculation Tag: 79218
  - 23
    - Matching if not a particular color What I want to do is to find and replace if the text if not red in color. I mean: with activedocument.range.find .text="test" .font.color <> wdcolorred with .replacement . . . end with Of course, I can't say ".font.color <> wdcolorred", so is there any possible way to match any text so long as it is not red in color? Thanks, Vince Tag: Sum calculation Tag: 79215
  - 24
    - Sequential word parsing I just want to transform Word document to a text. I need to pickup all words and recognize all objects for proper layout. Let's say I have on a page a mixture of paragraphs, tables,lists. No nesting. After getting a Range for this page how can I parse this Range to pickup all elements in a proper order. paragraph1 paragraph2 table1 paragraph3 table2 paragraph4 lis1 paragraph5 TIA Michael Tag: Sum calculation Tag: 79213
  - 25
    - Populating a Word doc table from Excel I want to poulate a Word doc table with data from Excel. The Excel data is held in two adjacent 10 row columns (say A1:B10) where some Excel rows may be empty. First column contains text, the other a value. Is it possible to create a two column table in Excel, that automatically adjusts its size to the number of "occupied" data rows in Excel. i.e if there are only three rows of excel data, there are three rows in the Word doc table. Am new to VBA so any assistance with code would be much appreciated. Cheers, Peter Tag: Sum calculation Tag: 79210

Hello,

I am using Word 2000, and I have a protected document that I use as a cheque
requisition form. I would like the total box at the bottom to auto sum the
amounts being entered in the boxes above without having to right click on it,
and click on 'Update Field'. It always used to work like this, but when I
unprotected it once to change the year, it has never worked since. Can this
be done and if so, how?

Many thanks,
Chris

Top

Re: Sum calculation by Greg

Greg
Tue Jan 17 11:13:23 CST 2006

Chris,

Unprotect and toogle each variable formfield and ensure "Calculate of
exit" is checked. Then reprotect the document.

Top