north west passage

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - How to add an IF statement to Macro I have a Word 2002 document produced from an external application with many Equation editor objects. However, the equations do not properly line up with the other text on the line. If I select an equation and open the Equation editor then close it without making any changes, the misalignment gets corrected. I need a macro to go through the document and for each Equation Editor object, open Equation Editor and close it. I recorded a macro to do this with Find ^g. (I did get help with the SendKeys to close the application). It works OK until it finds a graphic which is not Equation Editor then halts. I think I need to add something like this: If .Type = msoLinkedOLEObject Then If .OLEFormat.ClassType = "Microsoft Equation 3.0" Then But I cannot figure out where and how to do this. Your help is greatly appreciated. Sub OpenCloseEqEd() ' ' Macro recorded 2/4/2004 Application.DisplayAlerts = wdAlertsNone Selection.Find.ClearFormatting With Selection.Find .Text = "^g" .Replacement.Text = "^&" .Forward = True .Wrap = wdFindContinue Do While .Execute Selection.InlineShapes(1).OLEFormat.DoVerb VerbIndex:=1 With Selection.Application SendKeys "%fx", True End With Loop End With End Sub Tag: north west passage Tag: 79394
  - 2
    - Rights Managment issue Hi, pardon my ignorance, but in updating to office 2003, I now get a pop-up message regarding Rights Managment. I am unable to even print preview the document. Can this managment be turn off ? Thank you Tag: north west passage Tag: 79391
  - 3
    - Parsing Fields in VBA code I have a document that will have fields inserted by the user. Somehow I need to allow the user to insert text in these fields that is freeform, the only way I guess this can be done is via the fields add method. Assuming I can do this in code, and set the user text as the QUOTE section of the field, is there some means that I can later parse the document for a given field code, and then strip out the QUOTE text in code? Tag: north west passage Tag: 79389
  - 4
    - Convert WP .frm with Perfectscript to Word file I have several WP .frm files with Perfect script code and I need to re-create them as Word files that will do the same thing. I don't really know where to start in Word. Any suggestions/recomendations on how to go about this? Tag: north west passage Tag: 79388
  - 5
    - Automation Error Small Business Edition I have a client running Office 2003 Small Business Editon. I loaded Payne Metadat Assistant. Got automation error. Their tech support says Small Business edition does not support automation. Is this true? How am I supposed to know this - is there a document somewhere that says which versions support automation? Is there any way to install automation? Thanks! Jeffrey M. Gagen Tag: north west passage Tag: 79385
  - 6
    - Modify Filename Field I'm trying to pull only a portion of the document filename field, but I would like it to remain in Feild format so that it remains dynamic. Basically we have a document managment system that assigns numbers automatically. I would like to capture just the document number and version which is placed into the wdFieldFileName information, not the entire filename. This way if the User copies to a new document number, the number doc number will be displayed dynamically. ~Lori Tag: north west passage Tag: 79378
  - 7
    - Sum calculation 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 Tag: north west passage Tag: 79377
  - 8
    - 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: north west passage Tag: 79374
  - 9
    - 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: north west passage Tag: 79370
  - 10
    - 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: north west passage Tag: 79366
  - 11
    - 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: north west passage Tag: 79361
  - 12
    - 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: north west passage Tag: 79357
  - 13
    - 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: north west passage Tag: 79356
  - 14
    - 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: north west passage Tag: 79342
  - 15
    - 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: north west passage Tag: 79340
  - 16
    - 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: north west passage Tag: 79336
  - 17
    - 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: north west passage Tag: 79334
  - 18
    - 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: north west passage Tag: 79332
  - 19
    - 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: north west passage Tag: 79330
  - 20
    - 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: north west passage Tag: 79318
  - 21
    - 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: north west passage Tag: 79314
  - 22
    - 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: north west passage Tag: 79313
  - 23
    - 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: north west passage Tag: 79312
  - 24
    - 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: north west passage Tag: 79309
  - 25
    - 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: north west passage Tag: 79308
- Next
  - 1
    - I would like to add hebrew lanquage to my translation list I would like to add hebrew lanquage to my translation list Tag: north west passage Tag: 79303
  - 2
    - 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: north west passage Tag: 79301
  - 3
    - 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: north west passage Tag: 79300
  - 4
    - 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: north west passage Tag: 79299
  - 5
    - 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: north west passage Tag: 79298
  - 6
    - 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: north west passage Tag: 79290
  - 7
    - 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: north west passage Tag: 79285
  - 8
    - 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: north west passage Tag: 79283
  - 9
    - 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: north west passage Tag: 79282
  - 10
    - 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: north west passage Tag: 79279
  - 11
    - 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: north west passage Tag: 79277
  - 12
    - 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: north west passage Tag: 79276
  - 13
    - 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: north west passage Tag: 79267
  - 14
    - 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: north west passage Tag: 79262
  - 15
    - 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: north west passage Tag: 79258
  - 16
    - 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: north west passage Tag: 79257
  - 17
    - 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: north west passage Tag: 79253
  - 18
    - 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: north west passage Tag: 79250
  - 19
    - 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: north west passage Tag: 79248
  - 20
    - 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: north west passage Tag: 79246
  - 21
    - 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: north west passage Tag: 79245
  - 22
    - 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: north west passage Tag: 79240
  - 23
    - 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: north west passage Tag: 79239
  - 24
    - 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: north west passage Tag: 79236
  - 25
    - 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: north west passage Tag: 79233

hey yo man get my keys here now i need them for my new range rover.

Top