Replace tab with break

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - How do I add query field values to text in VBA? Im a novice at this but here is what Im trying to accomplish. My office has hundreds of memos going out on a regular basis. All of these memos go to a set group of people from a set group of people. Those people change based on the sender and recipient. The body of the memos is based on a set number of subjects. I have most of this automated now but the problem is that in VBA using the Select Case Method I have told access what to show for the body based on the subject but the body contains information that needs to be a field from a query. How do I reference that field? For example a memo to a car dealer about new cars would have a set body, part of which is the contact information from the person sending it. So the body would be something like this: Dear Mr. [Owner of Dealer] My office is interested in purchasing 3 new vehicles from your dealership. When you have time to discuss specifics please contact Purchasing Officer [PO] at [Phone Number]. Sincerely, [PO] Keep in mind that the body of this memo needs to be calculated as well based on the subject the user selects. I hope this makes sense. My job has nothing to do with cars but I cant comment on what I do so the example probably confuses things. Thanks in advance for any help you can provide! Rob Tag: Replace tab with break Tag: 90448
  - 2
    - Macro to look for highlighted text and delete it I want the macro to look through the document for any text that is highlighted (it will be in yellow), and delete the text, and remove the highlight. I'd appreciate any help. Thanks, J.O. Tag: Replace tab with break Tag: 90446
  - 3
    - Can date format be changed I have a number of paragraphs which start with the date in the format 05.09.2006 that is dd.mm.yyyy Please can you write a macro to find dates in dd.mm.yyyy format and change them to d mmm yy format, that is 5 Sep 06 Having seen how to do that, I take it that it would be straight forward to change instead to ddd, d mmm yy (Tue, 5 Sep 06) or ddd, d mmmm yy (Tue, 5 September 06) if I wished. Many thanks, Francis Hookham Tag: Replace tab with break Tag: 90444
  - 4
    - VBA question for "save as" function I am creating a Macro that will save the currently open .doc file as a .txt file of the same name. In the following line, what do I need to change/add to make the file save as the same name as the currently open file? ActiveDocument.SaveAs FileName:="<current filename>.txt", FileFormat:= _ I am new to VBA, and I don't know what the code callout is for the current filename, and I know that is what has to go in the line of code where I have "<current filename>" typed in for this example. I also realize that I will not need the quotation marks around the code command. -- I'm just a simple man, trying to make my way in the universe... Tag: Replace tab with break Tag: 90441
  - 5
    - Unable to "Save AS" document...I get a read only message. I am unable to "save as" a document in word. Even though I am the administrator and have not choosen "read only" I am unable to save a document after making changes when I try to save to my E drive. This is not removable media, it is a hard drive. If someone can help me I would appreciate it. I have tried uninstalling and reinstalling, I have tried changing the file name...etc. -- BSimon Tag: Replace tab with break Tag: 90437
  - 6
    - How can I reset page number in a Page field in the middle of doc? I am trying to create a template where the page numbers reset in the middle of a document. I need to use a Page field to hold the page number. Is there a way to reset the page number with a switch or something? Thanks Tag: Replace tab with break Tag: 90434
  - 7
    - Hide CheckBox FormField Hi, I have a work template which has 2 check box form fields. I try to hide one of the check box depending on user enter information from a text field. is this possible? How can do this. And also, can I change a text formfield's backgroud color to different color? Please help. Tag: Replace tab with break Tag: 90433
  - 8
    - Run-time Error 5981 "could not open macro storage" One of my coworkers recently started getting these errors when opening a Word document, and she doesn't remember changing any settings. She still has Office 2002 and I checked the macro security settings - they are low. I also made sure the Trust all add-ins,etc was checked. I'm thinking it might be a corrupt template, but there's about 8 different macros listed and I don't want to mess up her defaults and other settings. Is there a way to get rid of those error messages? Thanks. Tag: Replace tab with break Tag: 90430
  - 9
    - hide page number when Landscape Hi, I am trying to hide page number when the page property is Landscape. My word document contains pages in both portrait and landscape view. Or it will be really cool to write something like ...if page property is Landscape ....show page number at x" from to top and y" from right.. The main problem is i am new for macro and stuff.... Seeking your help. web address to get these information will also be helpful Thanks musa.biralo Tag: Replace tab with break Tag: 90429
  - 10
    - voice recognition it would be nice to have more training availabl I would like to see more training available for the voice recognition program installed in windows X. P. it is a very good program to have but there still is a lot of errors in the typing that I speak out I am using it right now to write this text but I think with more training available. I think it would be a lot more accurate. If somebody knows more information about how we greatly appreciate some information to know if I'm doing anything wrong . I would also like to know if I should read to the training program all over again will that greatly affect the way I speak and the machine understand my voice? Please respond to this someone at your earliest and the if need be please e-mail me at just_I_32@yahoo.com I am mostly using that e-mail so please feel free to e-mail me at your convenience or just posted here thank you. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=a5e13b37-a088-403c-adc3-1e643997ead2&dg=microsoft.public.word.vba.general Tag: Replace tab with break Tag: 90428
  - 11
    - how do i set up random numbers in a cell & row? here is what I am trying to do: I have 6 rows like so 01 01 01 01 01 01 goin down rows 1-5 I want random numbers from 1-55, In row 6 I want random numbers 1-42. How do i do that? Tag: Replace tab with break Tag: 90425
  - 12
    - count-if hi! i'm a novel programmer in vba and i am looking for a funtion or procedure that returns the number of times that a specific character appears in a given paragraph IÂ´ll put an example to explain myself better: dim text as string dim count as integer text= "name * surname * age " ' XXXXX is my desired procedure: count= XXXXX(text, *) ' this procedure must return '2', that is number of asterisks anybody knows if there is any vba funtion to make the count? or some idea to construct my procedure? Tag: Replace tab with break Tag: 90417
  - 13
    - Add a hyperlink to dropdown box When designing a web page in Word, how can I put a hyperlink into a dropdown box? I would like it to show the short name and not the URL. I have several pages I would like to list and give others a choice. Tag: Replace tab with break Tag: 90410
  - 14
    - Using Bookmarks to store User Form data, how to hide? Hi there, I'm automating our company's standard documents. The idea is to collect info about the document and author, and automatically fill this in at spots in the header and footer. This is to standardize how it's input so users don't have to worry about getting the right format. Previously, I used a stack of ASK fields to collect the info into Bookmarks, then put cross references in the header and footer. I put the ASK fields on the front title page, which doesn't get used much and so were out of the way of stray keystrokes. This worked well since the ASK fields were "invisible" unless you toggled field codes. But all those dialog boxes in a row were a bit tedious. So now I've created a User Form that collects all the info in one spot and inserts the data into Bookmarks. I inserted the Bookmarks on the title page like I had the ASK fields, but now I realize that the full text of the Bookmarks is showing up on my page! My question is: How can I make these Bookmarks invisible like the ASK fields? I have already moved the obvious Bookmarks off the title page and into the header and footer (Doc No., Doc Title, etc), but some of the Bookmarks I will only use as cross references later in the body of the document (which doesn't exist yet) such as Customer Name. I've tried highlighting the Bookmarks on the title page and selecting Font > Hidden, but when I insert a cross reference, the formatting comes along and the reference is also hidden! Is there any kind of switch or place I can stash Bookmarks that will make them invisible to the user, yet be easy to cross reference to? THANKS, Matt Tag: Replace tab with break Tag: 90404
  - 15
    - Paste text to currently open document Hi all, I have such a problem: I wrote sub to copy text form one doc to currently open document. I attached this sub to button I would like it to insert text form another doc in the selection in document which I edit. But instead of inserting text to currently open doc it copies text to the file from which this sub takes text: Dim OpisKryterium As New Document Set OpisKryterium = Application.Documents.Open(SciezkaKryterium(NrKryt)) Dim TekstOpisu As Range Dim DlugoscTekstu As Long DlugoscTekstu = OpisKryterium.Characters.Count Set TekstOpisu = OpisKryterium.Range(0, DlugoscTekstu - 1) Selection.FormattedText = TekstOpisu.FormattedText OpisKryterium.Close Set OpisKryterium = Nothing Set TekstOpisu = Nothing I think that it is because of this line: Selection.FormattedText = TekstOpisu.FormattedText but I tried to do it with ActiveDocument but result is the same. So how can I reference to currently open doc. Please help. Regards, sweet_dreams Tag: Replace tab with break Tag: 90397
  - 16
    - read and write chinese words Hi, I want to read chinese, traditional chinese,korean,japanese words from word doc and write it into text file. But I have no luck up till now. I have no problems with french and german languages but these other 4 languages just can't be written into the text file. It'll leave some empty blank spaces into my text file. Code so far: Const ForWriting = 2 Dim objFSO, objFile Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.CreateTextFile("C:\TCS.mtp", ForWriting) Dim counter as integer do while lineArray = Split(theTable.Cell(caseStartRow, 2).Range.Text, Chr$(13)) objFile.writeLine (lineArray(counter)) counter = counter + 1 wend objFile.close Please help if there is anyone know how to solve the problem. Thank you so much! John Tag: Replace tab with break Tag: 90394
  - 17
    - Adding AutoText to all headers and footers Is there a way to add an autotext entry to ALL headers and footers in a document no matter if there is a different first page or not, or if there are multiple sections or not? Tag: Replace tab with break Tag: 90392
  - 18
    - Calcuate on Exit Bug? Maybe I don't really understand what checking calculate on exit does for a form field but I've never seen this before. I've got a form with about a dozen fields, some of them are calculations but... well what they are doing is MULTIPLE calcuations as you tab through the fields. They don't calculate just once...they REPEATEDLY calculate the formulas everytime you tab out of a field in the document. so 200 becomes 400 becomes 800 becomes 1600, etc. This won't work, and I have other Word forms with Calculate on Exit that don't act this way at all. Am I missing something or is my document bugged? Tag: Replace tab with break Tag: 90391
  - 19
    - Word ComboBox values in txt file Is there a way to reference the choices provided in a drop down list of a Combo Box from a txt file or macro stored in the Word Template? I have a Word Form with many combo boxes that should have the same choices but need to store them outstide of the code because I get an error that the code is too long. Tag: Replace tab with break Tag: 90390
  - 20
    - Are single field calcuations possible? How do I get a form field to perform a calculation on a number that the user puts in it? I know how to do it with multiple fields like =(Field1)*(Field2) but what if I want it to equal what the user puts in this field itself /12, for example? so If I have one field in a document that is supposed to display how much the average person makes in a year based on an hourly rate. The field would need to accept the user's input (the hourly rate) and automatically multiply that number by 2080 and the change what they inputted to show the result. is that possible? Tag: Replace tab with break Tag: 90383
  - 21
    - Creating a format for headers I would like to create a format in word that makes it possible to transfer a word from the text to a header. For example, if I write: "This is my header" in the text, I would like to be able to mark that text and chose a format which automatically converts that text into a header. Does anyone understand what I mean? And if so, is it possible? Tag: Replace tab with break Tag: 90381
  - 22
    - Create macro in a template? Yesterday I submitted a question about disappearing macros. It was suggested that I create a macro in a template that I should save in the Word Startup folder. How do you save a macro as a template? Tag: Replace tab with break Tag: 90380
  - 23
    - macro to make picture in-line with text hi all, wxp pro sp2, office 2003 pro sp2, i have a large document with lot of figures (300+). it just transpires to me that as a result of collaborative work, we end-up with a mix-bag of figures that are in-line with text, square or tight in layout. i wonder whether someone would be kind enough to provide me with a macro that would enable figures to be changed to in-line with text, if this is macro-able. or is the solution one of swallow the bitter pill and check/convert figure 1 by 1? thanks for your advice/help, jes Tag: Replace tab with break Tag: 90370
  - 24
    - Word version independent macros Hi, I have created word template with some subs and functions. Generally this macros, copy content of other .doc dokument and paste it to active document, create tables and format text. I created this template in wrod 2003. But it turned out that this template will be used on computers where are Word versions form 97 to 2003 and in the future perhaps 2007. So my question is what can I do to make this template (especialy macros in this template) Word version independent? Can I use objects like ActiveDocument, Selection??? Or Should I rewrite this macros using late binding??? Any help, suggestions will be appreciated. Regards, sweet_dreams Tag: Replace tab with break Tag: 90365
  - 25
    - Selecting just one word in document When I use: Selection.Words.Count with nothing selected I get Selection.Words.Count =1 I get the same result when I actually select just one word (which I expected). Likewise if I use Selection.Words.First, I get then next word after cursor. How do I know if the user REALLY just selected one word? thanks Tag: Replace tab with break Tag: 90362
- Next
  - 1
    - Setting savepath through Word Automation. Hi. I'm currently using MS Word automation to open up a template and fill in user information automatically based on the person who opened it. However I can't figure out how to set the savepath so when the user chooses to save, the save dialog goes to the path given by me. Does anybody have any solutions regarding this? Best regards Svein Arild Tag: Replace tab with break Tag: 90360
  - 2
    - pop up messages when printing or sending Is there a feature in Word to automatically show pop up messages when printing or sending a document? If not, what would the Visual Basic code be to make this happen? Tag: Replace tab with break Tag: 90353
  - 3
    - Transfer Calculator Result I know how to display the Microsoft calculator in Word. MS says that a two step 'Copy/Paste' operation is the only way to capture the result of a calculation. Is there any way via VBA to more directly capture the answer and automatically get the calculator's answer into the document or into a form field (by clicking one button, for example)? Thanks, Ed (in Virginia) Tag: Replace tab with break Tag: 90352
  - 4
    - Macros in Office Basic vs. Office Professional I have documents whose macros run fine in Word in Office Professional but do not run at all in Word in Office Basic. I need to use the documents on both computers. How can I make this work? Tag: Replace tab with break Tag: 90351
  - 5
    - How do I Word Macros from Office Professional in Office Basic? Tag: Replace tab with break Tag: 90350
  - 6
    - how to insert a picture to a word document how to insert a picture to a word document,and align Center both Horizontal and Vertical Tag: Replace tab with break Tag: 90349
  - 7
    - Creating a second word instance to run my project (Word 2000) Hello I have one last obstacle to overcome with my project. At this stage it is working more or less as i want it, application is hidden with only a userform in view, and my labels are printing out fine, time after time of button clicking, documents are opening and closing correctly etc etc. My (final???) problem now is that when I close the applicatiion the way I need to, ie Application.Close wdDoNotSaveChanges - so that its ready to be used again another time, it also closes with it any documents that are laying open at the bottom of the screen - this could well cause much anguish amongst the users who (hopefully) will be using it in our office, and I'm sure to become little miss unpopular!! I think one option, if it can be done, would be to fire up the document in a new instance of word, separate from the one that is already open with documents at the bottom of the screen. Is this possible, and if so can someone point me in the right direction of where to place the required code. I have seen some code in a book that will open an instance of word from another program - do I do this in the same way? And where should the start up code be placed? Thanks Tag: Replace tab with break Tag: 90345
  - 8
    - VBA Code I have a seeming simple task that I can't figure out. I have a macro set up to refresh a query and then do some copying and pasting of cells. What code can I use to tell the macro to wait until the query is finished refreshing until it does the copy and paste? Here is the simple code. Sub GetData() ThisWorkbook.RefreshAll ' I need the following code to be run after the refresh is finished' Range("J5").Select Selection.Copy Range("J6:J65000").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveWindow.LargeScroll ToRight:=-1 Range("D1").Select End Sub Tag: Replace tab with break Tag: 90343
  - 9
    - How do I import macros from Word 2002 to Word 2003? Not working... Tag: Replace tab with break Tag: 90342
  - 10
    - How can I stop the reviewing toolbar from popping up? I am using another program called iRedline for document comparisons and changes. After I compare documents with iRedline, Word's native Reviewing toolbar pops up. It is redundant sitting there next to the iRedline toolbar; and I don't want to confuse my users. Tag: Replace tab with break Tag: 90334
  - 11
    - Print all docs in folder macro I loaded a macro that sounded promising, that would print all documents in a folder to a file. Wonderful. Now, how do you choose a folder to print it? I can choose documents, but have no idea how to choose a folder. Tag: Replace tab with break Tag: 90324
  - 12
    - Caption of a frame I am desperately trying to find a way how to print the captions of my userform's frames. Right now, these captions do appear on the userform but do not when I print it. Thanks for your hints on this matter. Sebastien Tag: Replace tab with break Tag: 90322
  - 13
    - Macro created one day, next day gone I created a Macro, save to two places by gmayor. I was going to go in and edit it. Today it is gone. Totally gone. I had saved, closed it, gone back to it two or three times, and even added it to one of my drop down menus. It's dead, Jim. Where did it go? Do I have to recreate it every time? WTH!? Tag: Replace tab with break Tag: 90313
  - 14
    - Macros to delete track changes and comments Is there a macro code that I could use to remove all track changes and comments (not just hide them) before saving and sending a document? I've tried the Reject and Accept Changes, but sometimes if I click Reject all changes, it takes away changes that weren't tracked to begin with. And I always have to go to View > Markup, making sure that markup is checked, in order to reject and accept. Sometimes I'll have to delete comments separately, sometimes I just click Accept all changes and it gets rid of them. Is there one process that will work the same for everyone? (everyone here is upgrading to 2003 and we have to republish some old docs) This is confusing to instruct others about, since docs were saved in different ways with different kinds of markups. I don't want to use the Remove Hidden Data tool because it messes up templates and other settings. thanks Tag: Replace tab with break Tag: 90311
  - 15
    - See solution for : Want to get rid of the Word warning dialogue Regards Jean-Yves Tag: Replace tab with break Tag: 90309
  - 16
    - resolving combo box data to HTML e-mail hi, I am creating a template in word to replace an existing paper based form with a e-mailed word document. To do this i am using VBA in word to send the document once finished and i am using several combo box's to select data on the document. The problem i am having is that when the template is sent (as HTML) the data selected in the combo box's is not sent. I would like to have it set so that only the text selected in the combo box is sent - without any of the actual comboi box. (i am aware that the combo box can be sent by activating active x in outlook, however i was hoping that there might be another way) where can i find the answer??? thanks. Tag: Replace tab with break Tag: 90301
  - 17
    - ListBox_Click event does not work! I used ListBox couple of times and each time the click event worked fine, but in one particular userform the ListBox_click does not work! However it "works" when i set listbox selected value via code, for example: ListBox1.Selected(0)=True but when i click a value on the listbox, the event simply does not "fire"... I checked this by placing the breakpoints inside of the click event. Of course, nothing "breaked" because event doesnt fire.... Please help. Thanks. Tag: Replace tab with break Tag: 90299
  - 18
    - copy text Depending on an input choice i have to select a part to copy and paste. All the text is included in one document and i can type all i want for bookmarks. But how can i write the code that on choice 1 i have to copy from text "a)" till text "b)" and so on? Tag: Replace tab with break Tag: 90295
  - 19
    - RE: Opening Excel for editing Hello, I have a Word form that has a user form within. In this user form some data is entered and thus written to another Word form. I would like to open an Excel for and write some data to a cell, how can this be done? Below is a code snippet for the Word document, I would like to write the same data to the Excel document named 'jobs.xls'. Thanks Documents.Open FileName:="C:\!Job Setup\Project Information.doc" With ActiveDocument .FormFields("ProjectName").Result = frmProjectName .FormFields("ProjectNumber").Result = frmProjectNumber .FormFields("ProjectTo").Result = frmProjectTo .FormFields("ProjectAttention").Result = frmProjectAttention .FormFields("ProjectAddress1").Result = frmProjectAddress1 .FormFields("ProjectAddress2").Result = frmProjectAddress2 .FormFields("ProjectAddress3").Result = frmProjectAddress3 .FormFields("ProjectManager").Result = frmProjectManager .FormFields("ProjectForeman").Result = frmProjectForeman .FormFields("ProjectSuper").Result = frmProjectSuper .FormFields("ProjectScope").Result = frmProjectScope .FormFields("ProjectDate").Result = frmProjectDate .FormFields("ProjectRDF").Result = frmProjectRDF .FormFields("ProjectPhone").Result = frmProjectPhone .FormFields("ProjectFax").Result = frmProjectFax .Close SaveChanges:=wdSaveChanges End With -- A response to the newsgroup will allow us all to learn from your expertise! -Lumpjaw Tag: Replace tab with break Tag: 90287
  - 20
    - Updating Table of Contents Hi. I'm trying to update a Table of Contents (TOC) from a macro. Nothing I try works. When I do it manually, I get a prompt that asks me if I want to replace the TOC. None of the methods seem to take a parameter for replacing the TOC, which is what I need to do. Recording the manual operations basically gives the same code that I am using, but it doesn't work at run time. Here's what I have now: For Each aTOC In ActiveDocument.TablesOfContents aTOC.Update aTOC.UpdatePageNumbers Next aTOC What is the trick to regenerating a TOC that works every time? Thanks, Gaston Tag: Replace tab with break Tag: 90283
  - 21
    - "Save to two locations" macro I used the gmayor macro to save a document to two locations at once. It worked wonderfully. However, with each file it saves, it puts the word "Backup" in front of each file. Is there any way I can get around that? Tag: Replace tab with break Tag: 90282
  - 22
    - IF/Then variable in form? Anyone know how to write the code so that IF a # in a field (call it Premium) is LESS THAN $50. THEN this field = that field plus whatever it takes to be $50... otherwise, the field is Zero? Tag: Replace tab with break Tag: 90279
  - 23
    - assigning variable to DB field value In the following code (brackets [] replace actual path name, etc.), what is the syntax for assigning the value of the database field to a variable? And a few more questions: What would be the equivalent code for doing the same but using a recordset just to get the data field value then assign it to a variable? In other words, this would just retrieve the field's value and not make the document into a merge document, correct? If I didn't want to use the .odc shown below, what would be the correct syntax to just reference an Access database named DB.mdb? (I'm asking because I recorded this from a macro; and I'd like to know all the options so I can better understand the syntax and principles behind the code.) ActiveDocument.MailMerge.OpenDataSource Name:="[path]\[datasource].odc" _ , ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _ WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, Format:=wdOpenFormatAuto, Connection:= _ "Provider=MSDASQL.1;Persist Security Info=False;User ID=b;Extended Properties=""DBQ=[path]\[database].mdb;DefaultDir=[path];" & _ "Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=[path]\[DSN].dsn;MaxBufferSize=2048;MaxScanRows=8;PageTi" _ , SQLStatement:="SELECT [field] FROM `[query]`", SQLStatement1:="", SubType:=wdMergeSubTypeOther [variable]=??? -- Thanks in advance, Bryan Tag: Replace tab with break Tag: 90278
  - 24
    - Create Form with Bookmarks that are underlined I have a problem with my form. I've created the fields for the bookmarks, but I am unable to keep them underlined. I've tried to highlight the field and underline it so that when it fills in it is underlined, but the text goes before the underline. Hope that makes sense...I'm using Word 2002 Thanks for any help. Tag: Replace tab with break Tag: 90276
  - 25
    - Loadpicture in Mail Merge I am developing a Word mail merge to create letters from an Excel spreadsheet. I would like to load a picture on each page using a path in the excel spreadsheet. I have written a macro which loads the picture. How can I get the macro to run for each record in the mail merge? Any thoughts or code samples would be appreciated. Clark Tag: Replace tab with break Tag: 90274

Please help me find the third Tab Character in each paragraph and replace it
with a Manual Line Break.

NB I might need to change to second or fourth Tab Character.

Francis Hookham
(I thought I had posted this request but I cannot find it - please excuse me
if this IS the second request)

Re: Replace tab with break by Jean-Guy

Jean-Guy
Fri Sep 01 16:47:58 CDT 2006

Francis Hookham was telling us:
Francis Hookham nous racontait que :

> Please help me find the third Tab Character in each paragraph and
> replace it with a Manual Line Break.
>
> NB I might need to change to second or fourth Tab Character.
>
> Francis Hookham
> (I thought I had posted this request but I cannot find it - please
> excuse me if this IS the second request)

Selection.HomeKey wdStory
Selection.Find.ClearFormatting
With Selection.Find
.Text = "(*^t*^t*)(^t)(*^13)"
.MatchWildcards = True
.Wrap = wdFindContinue
.Forward = True
.Replacement.Text = "\1^l\3"
.Execute Replace:=wdReplaceAll
End With

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Re: Replace tab with break by Klaus

Klaus
Sun Sep 03 20:28:14 CDT 2006

>> Please help me find the third Tab Character in each paragraph and replace
>> it with a Manual Line Break.

"Jean-Guy Marcil" <NoSpam@LeaveMeAlone> wrote:
> .Text = "(*^t*^t*)(^t)(*^13)"
> .Replacement.Text = "\1^l\3"

Hi Jean-Guy,

Very nice pattern! It took me a while to see why this expression always
works, and it's really not easy to find something that works both for
paragraphs that start with text, and with a tab.

.Text = "(*^t*^t*)(^t)(*^13)"
does the trick because the pattern matching stops each tentative match
(whether successful or not) when it encounters a ^13, and then starts anew
right after each paragraph mark.

Regards,
Klaus