Search string beginning at the end

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Word 2003 - Find multiple items, select entire line I have large amounts of imported plain text that I need to format. I need a macro that will look for the occurence off any number between 500 and 553 followed by two spaces then a hyphen, select the entire line containing it and making it bold. My initial attempt has the code repeated 54 times, with a different number each time. There must be an easier way to do it! Tag: Search string beginning at the end Tag: 91844
  - 2
    - Pointing an object to <current header> Hello, I need to point an object to the current page header. If d is my active document, I do: Dim MyHeader As Word.HeaderFooter d.ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader Set MyHeader = d.Sections(d.Sections.Count).Headers(wdHeaderFooterPrimary) The current header could be different type (not the primary, but firstpage, oddpage, evenpage etc.). How can I point an object var to the header in which the cursor is positioned after the View.SeekView has located that header for me? Thank you in advance, Marat. Tag: Search string beginning at the end Tag: 91839
  - 3
    - Macro must run when document opens I have a macro that updates all form fields. I want Word 2003 to run that macro automatically when it opens a document containing that macro. Any suggestions on how to do that? -- Ken Elder University of Oklahoma Tag: Search string beginning at the end Tag: 91837
  - 4
    - How to preserve line returns when saving Word as XML data? Hi, I use a custom defined schema to apply some xml tags in the Word Document. Then I save the file as XML file(data only). However, if there are several paragraphs in one XML tag, the line returns are not preserved in the result xml. How can I preserve the line returns in the result xml file? Thanks Yufei KPMG LLP Tag: Search string beginning at the end Tag: 91831
  - 5
    - Check if ActiveDocument Exists Hi, I'm attempting to determine whether there is an ActiveDocument off the Application. Scenario: Word application is running but there is no open document. User clicks a commandbar button. I need to determine in the code behind the button if there is an ActiveDocument for me to type text onto. Cannot do a Application.Documents.Count b/c it sometimes returns a hit for the Normal.dot template. I need to determine whether there is an active .doc. Thanks! Tag: Search string beginning at the end Tag: 91827
  - 6
    - Check for existence of ActiveDocument in Word Application Hi, I'm attempting to determine whether there is an ActiveDocument off the Application. Scenario: Word application is running but there is no open document. User clicks a commandbar button. I need to determine in the code behind the button if there is an ActiveDocument for me to type text onto. Cannot do a Application.Documents.Count b/c it sometimes returns a hit for the Normal.dot template. I need to determine whether there is an active .doc. Thanks! Tag: Search string beginning at the end Tag: 91826
  - 7
    - Read docx document contents via XML Hi, I am trying to read the contents of a Word 2007 document using the XML techniques. I know I have to use the System.IO.Packing namespace to crack open the document and read the contents. Does anyone have any examples or sample .NET 2.0 code I could look at to understand the XML structure? Thanks Tag: Search string beginning at the end Tag: 91825
  - 8
    - Trigger the Properties Dialog box on open This is slightly different than some of the other questions on the group. We are developing a template for drafting over 2000 instruction documents. Since most of our user base have never correctly used templates and we want the flow to be as smooth as possible; we are putting as much repetitive information into properties as we can. Of course, we will instruct them on our to use the template; but judging from past experience.... We thought if we opened the properties dialog box for them when they opened the template it would increase our odds that they will use it. Our problem is that while recording the macro, we have to close the dialog box before stopping the recorder and then it has nothing written to it when we do. How can we automatically open the Properties dialog box when a user opens the template? Thanks Tag: Search string beginning at the end Tag: 91822
  - 9
    - hyperlink I need to insert a hyperlink in a file that will kick off a macro. What I did was create a template (startmacro.dot) with this code: sub autoopen() Documents.Add Template:="mytemplate.dot" end sub The hyperlink simply opens the startmacro.dot, which creates a new file basing it on the mytemplate.dot template. The "mytemplate.dot" template contains an autonew macro which executes my code. This all works fine. What I have been unsuccessful with is closing the original template (startmacro.dot). Perhaps there is another way of inserting a hyperlink to accomplish this? Any help would be appreciated. Thanks. Tag: Search string beginning at the end Tag: 91821
  - 10
    - return from hyperlink Hi All, I've set up several hyperlinks within in a single document to jump to other areas of the same document. I would like to return to the original location (if desired) through the use of a hot key. I prefer not to set up bookmarks of any kind. I would like word to remember the previous hyperlink and return. Is this possible? Would be great feature. Thanks for any help in advance. Tag: Search string beginning at the end Tag: 91820
  - 11
    - Tabstrip tabs disappear On my userform (a substantial one), I have a tabstrip. There are also several frames located on the form which are nested within a larger overall frame for the userform. I have had lots of problems with the tabs disappearing when I click on other elements of the form in design view. I thought it was simply a matter of bringing forward or sending backward but that doesn't bring the tabs back into view. This is a tab setup and not a multi-page because so many elements are common to each tab. Please advise me how I can keep better control of what I am able to view and work on without losing view of my tabstrip (especially). For me right now, it really is a "you click, you lose" situation with my form. Thx in advance for your help. -- RMC,CPA Tag: Search string beginning at the end Tag: 91817
  - 12
    - Where is calendar template that can be used for any year? The calendar format template (for Word) I need was found in Calendars>2005. Surely there is a way to create a template that can be used for any year or used by the Calendar Wizard. Anyone? Tag: Search string beginning at the end Tag: 91816
  - 13
    - Word 2002 document merge Using word 2003, have separate files and want to merge into one document. Issue is formats are different in each file and when merged formatting does not stay consistant with original file. This merge is currently comleted via a vb script. Tag: Search string beginning at the end Tag: 91815
  - 14
    - Footnote gets some trash characters in front of it. Hi all, I have a document template which is protected for forms, but in order to let users apply headers and footers and footnotes I've added a macro to allow them to switch on/off the document protection. This works fine for the headers & footers, but for some reason the footnote option in the dropdown menus is greyed out. With "CTRL-ALT-f" I can still add a footnote though. But when I do this I get a line at the bottom of the document underneath which I can type the footnote (so far so good) and in front of that line some random characters seem to apear (on my machine it's always 2/2/2/2//2/2, other users get different strings though). The superscripted numbers of the footnote do appear normal in the main document and at the bottom and the footnote can be added normally. The trashy chars are also visible on the print preview Does anyone have an idea what's going wrong here? Can I get the footnotes option in the menus available again? Can I get rid of the messy characters? Any help would be appreciated very much! Kind regards, rVo Tag: Search string beginning at the end Tag: 91814
  - 15
    - normal.dot template becomes huge I'm having a problem with my normal.dot becoming enormous after I run a macro. This macro has a lot going on, but nothing that obviously would affect my normal.dot file. It basically goes through a folder, opens a bunch of files one at a time (about 70 or 80 files in all), looks for bookmarks with certain things in their names, and copies and pastes the text in those bookmarks into another document. I have a couple suspicions of what might be going on, but not sure how to prevent or fix these problems. First, each one of these files that the macro is opening has their own attached dot file with some special menus in them. (Those are the menus that were used to set these bookmarks to begin with.) These dot files are NOT global templates, but rather are just attached to those documents. I have a suspicion that perhaps somehow opening a file with an attached template might somehow cause your normal.dot template to be modified also. Any insight? Alternatively, I wonder if there is something to do with style definitions. All of these files that I am opening were received from different parties, and a lot of them have their own special style definitions. I know I have had major headaches before with people's styles somehow migrating into my computer. Could it be that every new style in each of these documents I am opening gets added to my normal.dot? My normal.dot files starts out at 488k, and ends up at about 4 MB after I run this macro a couple times. At that point, my computer (a rather powerful new type of computer) becomes completely bogged down, and extremely slow. I can close Word and restart my computer, but the slowness remains until I replace my normal.dot file with an archived copy. Thanks for any help. Tag: Search string beginning at the end Tag: 91812
  - 16
    - Determining Table Cell Merge/Straddle value I am creating some VBA to process the contents of Word tables. I need to capture certain properties for any given cell. One of which is whether it has been merged. That is whether it straddles columns and how many columns if it does. Horizontally and vertically. Tag: Search string beginning at the end Tag: 91807
  - 17
    - Go to a bookmark in the header in New Doc Is there a way I can have the user go to a bookmark in the header upon opening a template for the first time?I'm trying to make a document more user friendly. The document is one created by the district that everyone on staff needs to complete and there are a variety of abilities. I added a hyperlink (hidden text) to get them out of the header after they enter the Header Data....but many are frustrated upon getting into the header.... Tag: Search string beginning at the end Tag: 91795
  - 18
    - Automation Is it possible to populate a Word document from either an XML file or Access database. My reason for asking is I have the task of manually inputing names of clients onto thank you cards and rather than have to copy paste each individual name onto one of the thank you cards, I'd rather populate the 8 card per document with the different client names. I also have to generate a final certificate for each client and its so time consuming, I'm just curious what is my best way to accomplish this, thank you. Tag: Search string beginning at the end Tag: 91789
  - 19
    - How do I find old macros? Pretty basic question, I guess. Used to keep a big pack of homemade macros for my work as a translator. Then Word failed me (as it will), and I installed a newer version, with the result that all my macros had disappeared. Does anybody have an idea of where to look for them? Cheers. -- Seize the day, then kill it. Tag: Search string beginning at the end Tag: 91783
  - 20
    - VSTO 2005 and Word Action Pane Hi, I am trying to use the Action pane to insert into a document the contents of another document. So far I have been able to get the Actions Pane to work fine. I have the contents of the other document which I want to insert in a "Stream" object. Can anyone help me as to how I can insert the contents of this stream into the current document at the current cursor position?? Thanks in advance, -Pritam Tag: Search string beginning at the end Tag: 91780
  - 21
    - PLEASE HELP!! Macros keep stopping, no errors I sure hope someone can shed some light on this! One and only one user in our office has a problem running macros. Supposedly, all our computers had the same image at set up, with the same OS (Win XP) and the same version of Office (2002) with the same DLLs. I am the designated "macro guru" (which only means I know Alt+F11 and I'm not afraid to play there!), so I get called over for any problems. Any of the rest of us can run a macro with no problems (other than my coding errors). She runs the same macro and gets "Code execution has been interrupted" several times. Hit "Debug" and F5 and the macro continues until it stops again. Never an error - just "interrupted". And the macro stops on things like: "End If", "Loop Until ", and so forth. This last time, the macro was trying to process about 1500 files, and stopped 4 or 5 times on each file! Where do I start to look for the problem? Memory? An options setting? Something else? Ed Tag: Search string beginning at the end Tag: 91777
  - 22
    - Security settings and Word forms I think I am getting a better understanding of the security issues related to Word forms. Would like to know if I have it correct, tho. I plan to email a .doc file as an attachment that will be a Word form to collect survey info. I will be using basic form fields for most of the questions, tho to make checkboxes behave as option boxes, I will have some vba code in the on enter property of checkboxes. Will not use any acitvex or toolbox controls. As I understand it, this .doc form should get thru and behave as designed provided they do not have their security settings set high. If the recipients do have a high setting, the on enter code for the checkboxes will prevent the form from running. I am not clear on what would actually happen when they attempt to open the form in Word and whether the file itself would be stripeed of the on enter code when opened, or if they would just receive a warning or both. Does this all sound correct, and can anyone tell me what would happen with the Word file if their security is set high. Is there a way for me to still help them to run the Word form even if their security is set to high and how would I need to do that? Or would I need to nstruct them to set their securty to medium temporarily so they can complete the form and email it back? Thanks for all your help, Mark Tag: Search string beginning at the end Tag: 91772
  - 23
    - how to includes font into a marcro? Hi, i'm trting to do a macro. It is working but I can't put differend font and size of text. When I doing my macro after it has record, the font and size is the same as by text just after it. Thanks Tag: Search string beginning at the end Tag: 91771
  - 24
    - Can't load CustomXMLParts since Technical Refresh Hi! I'm working on a data export function from our software into Word2k7, using CustomXMLParts therefore to save the Data to docx and a COM-AddIn to step through the single DataSets. Everything worked pretty fine until i updated to the Technical Refresh. Now i can't get the CustomXMLParts out of the docx anymore. I checked the unzipped docx files and they are alright - they got the correct GUID, but when i call for: Office.CustomXMLPart customXML = _Doc.CustomXMLParts.SelectByID(MYGUID); it returns null - but that's only since the technical refresh! Did they change anything concerning this? I've already read thousands of blogs (or maybe a few dozens ;)) but I haven't found anything helpfull ... hope somebody can help me - i really got stuck on this thx in advance! -- <-~^~-> Tag: Search string beginning at the end Tag: 91764
  - 25
    - Hooking controls Is the following possible? I have a 3rd party template that comes with a product, call it XYZ. As usual, the code appears to be sloppily written and causes the document to be unnecessarily dirtied. The project is protected. Usually, using the usual techniques, I can peek at the code and determine whether I can get around this by patching my Auto macros. In this case, there appears to be NO code in the protected template, so I guess there's a hook to code in an add-in for each control on the menu. and corresponding toolbar. I was thinking of the following general fix. Say, a control has an OnAction that uses "TheirMacro". I was thinking of adding my own TheirMacro, which would: 1. First, save the dirty status of the document. 2. Invoke XYZ's TheirMacro. 3. Reset the dirty status of the document, if needed. Alas, it appears that when the OnAction is a hook, I cannot seem to find out how to do this. Is it possible? Tag: Search string beginning at the end Tag: 91762
- Next
  - 1
    - Accessing information from active directory Hi there, Does anyone have a code example that gathers information from AD? e.g. If I provide a persons logon name is it possible to provide details like phone number etc etc and show the data in a messagebox or into a document? Any help would be really great!! Thanks for your time! Tag: Search string beginning at the end Tag: 91759
  - 2
    - Question about dlls needed for Word and VB In my VB application I just added the capability of writing to a Word document. I have a reference to Office11\msword.old in the project. My client is using Office XP. On my machine, everything works fine. When I install the latest version of the EXE using this new feature on the client's machine, it crashes saying "ActiveX component can't create object". It occurs at the line, Set MyWord = New Word.Application So I surmise the problem is because they are running a different version of Word and have different libraries. What files do I need to give them so that they can use the feature of hooking up with Word? Do I need to have them upgrade to the same version of Office I am using? Or is it a simple matter of copying a few dlls/olb files and registering them on their machines? When I look at Depends that comes with Enterprise, I don't even see the references to the Office Dlls. Thanks Bill Tag: Search string beginning at the end Tag: 91751
  - 3
    - How Do I Unlock Then Re-lock a Form Without Losing Content? I am using Word 2004 for Mac. I have created a form and the form has been filled out. Now I need to make a change to the form. When I unlock the form, make the change and then re-lock the form, all the data that was entered into the fields disappears. How can I make a change without losing my data? Hundreds of the forms need to be changed and I don't want to have to completely redo all of them. Thank you so much for your help! Tag: Search string beginning at the end Tag: 91746
  - 4
    - Control Toolbox vs. Formfield Toolbar I am kind of new at this, but have a very basic question, I think. Word has a Control Toolbox, which includes text box, etc. It also has a form field toolbar, which also includes a text box. It is not clear to me why you would use the text box from the Control Toolbox instead of the text box from the formfield toolbar. Could someone explain. In particular, I am interested in using the Option Button in the Control Toolbox in a survey form since there is not a comparable control in the formfield toolbar. I have seen articles from MVP on making a formfield checkbox act like an option button, but was wondering why not just use the Control Toolbox option button instead? Thanks for any and all advice on this, Mark Tag: Search string beginning at the end Tag: 91744
  - 5
    - add one line at the end of a footer hi i need to add a new line (with some text) to the end of the footer in word (first page and other page). i need to add this line without changing the formating of the footer (i have a table in the footer) i tried some things and nothing worked how can i do this ? Tag: Search string beginning at the end Tag: 91743
  - 6
    - track changes issue for styleRef in Header while protection is ON Hi everyone, Having some issues where every revision generates a new value for the the styleref here are the relevant info: - we have a StyleRef field in the document Header (say { STYLEREF "Heading 1" } or that with (\* MERGEFORMAT) will still yield the same issue) - a text (ie. Test) with style = Heading 1 - a bookmark wrapping the text above (Test) i) turn protection on but sets the bookmark range as editable (usually indicated by a yellow highlight) ii) have some codes to turn track changes on after turning protection ON (using C#-VSTO or VBA - either of which would still produce the issue) Set focus to the bookmark and made some changes. Notice that for every change/keystroke in the reference text, a new value is generated in associated Header field. Normally, track changes button and menu item is disabled once protection is off that suggests that working with track changes while protection is something fishy but as Word allows conditional protection it should not have been a problem. I was thinking of using Locked property of the styleref field but it has another issue of ignoring the strikethroughs when the field value is updated. Your comments would be very much helpful and appreciated. Ryan Tag: Search string beginning at the end Tag: 91741
  - 7
    - How pause code but keep printer running? I have four print statements in my VBA code each of which requires that different paper be loaded in the printer. This means I have to stop the code from running until the current printing is finished. When the current printing is finished I need to load new paper and then restart the code. How do I use VBA to pause the code but keep the printer going until it finishes its current job? I have tried MsgBox but this stops both the code and printer. -- Bob Collin Tag: Search string beginning at the end Tag: 91731
  - 8
    - Problems with document and application object How do I tie a document object to the one I just opened. The document I end up saving is blank. Somehow I need to get the one I just opened into the document object that is being saved. Dim MyWord As Word.Application Dim WordDoc As Word.Document Set MyWord = New Word.Application With MyWord .Documents.Open ("c:\test.doc") Set WordDoc = MyWord.Documents.Add WordDoc.SaveAs "c:\test1.doc" DoEvents Set MyWord = Nothing Set WordDoc = Nothing Tag: Search string beginning at the end Tag: 91730
  - 9
    - Word and VB Help I have a piece of code in my vb app that opens up a Word document and then fills in bookmarks with fields from a vb form. The problem that I am having is that the fields that I am filling in have underlines and as I fill in text it is in insert mode and pushes the lines over and messes up the page formating. How do I turn off insert mode form VB. Here is a sample of my code. Dim MyWord As Word.Application Set MyWord = New Word.Application With MyWord .Visible = True .Documents.Open ("c:\BuildingChangeForm.doc") .ActiveDocument.bookmarks("BuildingName").Select .Selection.TypeText USIComboRead(cmbBuilding) Thanks in advance for any help anyone can offer. Bill Tag: Search string beginning at the end Tag: 91714
  - 10
    - Macro used to print...? Howdy, I had a macro (Word 2000 SP3) that worked properly under Win 2000 Pro. Now, under Win XP, it behaves differently. Formerly, it did a merge, and printed the result. Now, instead, it does the merge, and opens the Print Dialog. There it stays until I click "OK" to print. I had tried SendKeys "~" but with no luck. Originally, I had created the macro by recording, and then tweaking. With the help of a kind person on another group, I stripped out the extraneous stuff that the recorded generates to get the code just below. It generates the Run Time Error 438 "Object doesn't support this property or method on the line I have marked. Sub Macro8() ' ' NameTagsFirst Macro ' Macro created 5/30/2002 by Kenneth ' ' Documents.Add Template:="F:\Templates\Label 4x2.dot" ActivePrinter = "OKI" Selection.Font.Size = 36 Selection.Font.Bold = True With ActiveDocument.MailMerge .MainDocumentType = wdMailingLabels .OpenDataSource Name:="Z:\data\let.txt" .EditMainDocument .Fields.Add Range:=Selection.Range, Name:="First" >>>>> WordBasic.MailMergePropagateLabel <<<<<<< .Destination = wdSendToPrinter .SuppressBlankLines = True .Execute End With ActivePrinter = "HP Color LaserJet 2500 PCL 6" ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges Application.ScreenUpdating = True Application.Quit End Sub Apparently, Word 2000 does not support WordBasic.MailMergePropagateLabel, but I don't know what to replace that with. I will also add that in my original version, I did not record choosing "Mailing Labels." Instead, I chose "Formletters" though, in fact, I was printing those "letters" using a template that was 4"x2". Thanks for any help on this, -- Kenneth If you email... Please remove the "SPAMLESS." Tag: Search string beginning at the end Tag: 91710
  - 11
    - SaveAs dialog Below is a tiny snippet of my code. I'm needing to display the save as dialog and populate the "suggested name" with the text from a txtbox on my userform. This code almost works but I don't know how to tell the dialog what to put on the Save line. Plz advise. Dialogs(wdDialogFileSaveAs).Show ActiveDocument.SaveAs (UserForm1.TxtClientNmbr) Thanks !! -- RMC,CPA Tag: Search string beginning at the end Tag: 91709
  - 12
    - Navigate to a specific numbered paragraph Hi Gurus. I'm trying to automate word to perform the following tasks: 1. Open a given document (no problem) 2. Navigate to paragraph numbered 4.1 3. Get its content I have no idea how to perform steps 2 & 3. Can you help me with that? Thanks! Tag: Search string beginning at the end Tag: 91705
  - 13
    - converting toolbar question i have a custom toolbar for Word 2002-2003. how do i get that toolbar to show up on the ribbon in MS Word 2007? is there a change i can make to my template that will do this automatically? I have tried to add the buttons thru the QAT, but, my commands do not show up? ACK!! any suggestions? Tag: Search string beginning at the end Tag: 91702
  - 14
    - Error trapping an Input Box I have to error trap the following line of code: ActiveDocument.Variables("varmeetingnumber").Value = InputBox("Meeting Number") If the user doesn't enter any number, I want to display a Message Box and prompt the user again for a number. Being new to VBA, I don't know the code to do this. Your help is appreciated. TIA, David Tag: Search string beginning at the end Tag: 91696
  - 15
    - converting pictures to right size any way I can have all pictures in a document (will be pasted charts from another app) converted to a particular height/width? Thx. -- Boris Tag: Search string beginning at the end Tag: 91682
  - 16
    - Any other dictionary programs to import into Word? Hi all, does anyone know if I can download or buy another dictionary program to import into my Word (Office 2004 student/teacher) program? I wonder also if there is another thesaurus program available that would work seamlessly. Thanks! Fenton Tag: Search string beginning at the end Tag: 91681
  - 17
    - "compare documents" opens a new document? Why? I am new to Office 2004 and I find it disappointing that the TOOLS command "compare documents" opens a new document. I liked what I recall in former Word versions- selecting one document to compare with another highlights the changes in the existing document. I like saving original files with "created on" and "last modified" dates. Does anyone know if I can disable this or control it? Tag: Search string beginning at the end Tag: 91680
  - 18
    - Referencing an Access record from WOrd Problem: A Word doc contains words (usually in a footnote, but doesn't have to be), which are keys to records in an Access database. How can these Access records be displayed when the Word items are clicked, or selected and clicked? Tag: Search string beginning at the end Tag: 91679
  - 19
    - Link between Excel and Word... Hello all, How can I transfer strings from excel to defined location on word document? Thanks, MÃ¡rio Santos. Tag: Search string beginning at the end Tag: 91678
  - 20
    - Run Macro on form after exiting text box I am new to word and Macros so this more than likely easy I have a form with some check and text boxes on it if a user checks a check box and then later on enters a value in a text field I want it to check the check boxs and see if it is true, if so I want a value from another text box entered into other text boxes. i tried this but no luck If check4 = True Then text15 = text11 text18 = text11 End If thanks Tag: Search string beginning at the end Tag: 91677
  - 21
    - active network printer Hello, I use this code to set the active printer. objDoc.Application.ActivePrinter It works if the printer is local, but not if it's a network printer. Is the code different for network printer? Thanks for your help, Joel Tag: Search string beginning at the end Tag: 91676
  - 22
    - How to setup button that will insert a Word file into a Word file I have a Word 2002 document and at the bottom of page 1 I want to have a couple buttons where the users can either "Insert a file" or "Insert a different file". I have tried a hyperlink, but that opens the file in another document and I need to combine the 2 pages into 1 file. This form I have could be 3 pages or 20 pages depending on how many pages the user needs. HELP --- Can anyone give me a clue here? Claudia Tag: Search string beginning at the end Tag: 91675
  - 23
    - go to & highlight today's date on open I have a word document with a lengthy list of dates in a table. Upon opening, I'd like to see today's date highlighted and have it go to that date. Help??!! Thanks! -- Alan Tag: Search string beginning at the end Tag: 91671
  - 24
    - DEADLINE! Importing table into Word Form using a Command Button I'M ON A DEADLINE!! I've an Excel sheet that is saved. I want to use a Command Button in my Word form to trigger Word to find the Excel sheet and import it into my Word document. I inserted the file as an object in my word document and looked fine but I don't know how to use a Command Button to do the same. Thank you very much. Tag: Search string beginning at the end Tag: 91669
  - 25
    - Detect Cursor at Start of Paragraph Word 2003 I have the following simple macro. Sub GreenFont() If Selection.Start = Selection.End Then Selection.MoveUp Unit:=wdParagraph, Count:=1 Selection.MoveDown Unit:=wdParagraph, Count:=1, Extend:=wdExtend Selection.Font.Color = wdColorGreen Selection.MoveUp Unit:=wdParagraph, Count:=1 Else Selection.Font.Color = wdColorGreen End If End Sub If text is selected in the document the entire selection is turned to green text. Otherwise, the current paragraph is turned to green text. This works well with one exception--if the insertion point is at the start of the paragraph it will act on the *previous* paragraph. What is the easiest way to make it always act on the current paragraph--without regard to the position of the insertion point--when text is not selected? --Tom Tag: Search string beginning at the end Tag: 91663

I tried to find the answer to my question in this newsgroup's Google archive
but didn't find anything specific to my question.

Suppose I have a string that's 40 characters in length. Starting from the
end of the string, I want to search backwards to find the first occurence of
a blank space. How do I do this? Also, what is the Chr number for a blank
space?

Frederick Lorca

Re: Search string beginning at the end by Tony

Tony
Wed Oct 04 05:06:39 CDT 2006

Provided you have Word 2000 or later you can use InStrRev

TestString = "Forty characters of text as illustration"
Msgbox "The last space is at position " & InStrRev(TextString, " ")

--
Enjoy,
Tony

"Frederick Lorca" <frederickglorca@fictitious.org> wrote in message
news:n66dndNplvWjp77YnZ2dnUVZ_v-dnZ2d@comcast.com...
> I tried to find the answer to my question in this newsgroup's Google
archive
> but didn't find anything specific to my question.
>
> Suppose I have a string that's 40 characters in length. Starting from the
> end of the string, I want to search backwards to find the first occurence
of
> a blank space. How do I do this? Also, what is the Chr number for a
blank
> space?
>
>
> Frederick Lorca
>
>

Re: Search string beginning at the end by Frederick

Frederick
Wed Oct 04 21:52:31 CDT 2006

Thank you.

"Tony Jollans" <my forename at my surname dot com> wrote in message
news:eHeyT055GHA.3960@TK2MSFTNGP02.phx.gbl...
> Provided you have Word 2000 or later you can use InStrRev
>
> TestString = "Forty characters of text as illustration"
> Msgbox "The last space is at position " & InStrRev(TextString, " ")
>
> --
> Enjoy,
> Tony
>
> "Frederick Lorca" <frederickglorca@fictitious.org> wrote in message
> news:n66dndNplvWjp77YnZ2dnUVZ_v-dnZ2d@comcast.com...
>> I tried to find the answer to my question in this newsgroup's Google
> archive
>> but didn't find anything specific to my question.
>>
>> Suppose I have a string that's 40 characters in length. Starting from
>> the
>> end of the string, I want to search backwards to find the first occurence
> of
>> a blank space. How do I do this? Also, what is the Chr number for a
> blank
>> space?
>>
>>
>> Frederick Lorca
>>
>>
>
>