Threads Replies Last Post 23 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23   changing textfile with VBA Hallo, how can I delete the first line from a textfile by vba, or how can i delete a special string from a textfile by vba. Greetings and thanks Tobias Wolff ... 2 27.10.2005 17:31:06 Help needed with Mailto: command Can the mailto command use strings and variavbles from inside the word document? e.g. have a block of text once in a document and reference this text in the mailto: command so that many mailto: command can use the same bit of text and then the full text be in the email (not just a link to the text in the document.) Thank You... 3 27.10.2005 06:07:01 Change Footer in Protected Document I want users to be able to change the footer of a copy of a protected template. Is there a macro for that? Thanks!! ... 9 26.10.2005 15:14:46 Command button to e-mail current document I'm glad this group has "beginner" in the title. I have a form template and I'm just trying to put a command button on the form that e-mails the current document when pressed. This is what I attached to the click event of the button (from the help): Private Sub CommandButton1_Click() Options.SendMailAttach = True ActiveDocument.SendMail End Sub BUT nothing at all happens w... 2 26.10.2005 12:51:19 Toggle macro button Hello all, I'd like to know how a macro button can be turned into a toggle, like the bold button in the format bar, for example. TIA, Guillermo... 21 25.10.2005 23:18:46 Select Table cell Please could someone give me the code for selecting all the text in a table cell from either the bottom or top of the cell. I would be grateful for some help please. Margaret ... 3 25.10.2005 17:51:03 Envelope font macro Hi all, I was just wondering if anyone has the same problem as me, or something similar. I have written some code to print out onto a label. When I do this without the code I can modify the font (by going to tools, letters and mailings, and then envelopes and labels), with the code, the only way I have found so far to change the font is to set it to what I want previously as a defaul... 1 25.10.2005 11:05:06 Code work unless certain code is run Code work unless certain code is run then it messes up if the selected text is in a bookmark and is part of a table Sub Draft() 'Application.ScreenUpdating = False Dim i As Integer Dim strBookmarkName As String Dim strTest As Variant Application.ActiveWindow.ActivePane.View.ShowAll = True 'Find tables with blue italics text Selection.Find.ClearFormatting With Selection.Find ... 6 24.10.2005 21:49:54 Coding error that is killing me Sub SendToClient() Application.ScreenUpdating = False Application.ActiveDocument.Save Application.ActiveWindow.ActivePane.View.ShowAll = True Dim strNewName, strFileName, strLength, strFilePath, strLengthPath As String Dim intTableCount, intTablesLeft, i, j As Integer Dim BMName As String Dim BMCount As Integer Dim CurrentBM As Bookmark ReDim ary(ActiveDocument.Bookmarks.Count + 1) As Va... 5 21.10.2005 14:27:04 replace + format My macro replaces all manual line breaks (Chr(11)) within a paragraph. The problem is that for example all bold words turn into plain after the makro was applied. How can I preserve my formatting??? Thx. My Makro: Sub replace11() Set mr = Selection.Range mr.Expand (wdParagraph) mr.Text = Replace(mr.Text, Chr(11), Chr(32)) End Sub ... 2 20.10.2005 14:39:11 Hidden text does not let the paragraph wrap up to the next line WindowsXP pro Word 2002 here is the problem: numbers indicate what paragraph i am talking about [ start of a choise ] end of a choise 1 and 3 are choises you can have either paragraph 1 or 3 but not both. 2 is a specifier table that is hidden with the paragraph symbol below it when the final macro is run. when 1 is hidden and the final macro is run 3 does not wrap back to where... 4 20.10.2005 13:43:40 The Dir$() function and searching files under a directory Hello, I was wondering if it was possible to search filenames under a directory using Dir$() or if I would have to use If and Instr statements to search individual filenames. In other words, I have a directory, in which there are a bunch of files with filenames that all begin with the same pattern. I want to grab only those files and not have to search the entire directory. Here's wh... 7 20.10.2005 09:07:02 altert if style is used? Hi I am trying create a macro that prompt a message box only if a particular style has been used in a document. Below is what I have tried, however, the message box appears regardless if the style is in use or not: Dim objStyle As Word.Style With ActiveDocument If objStyle.InUse And objStyle.NameLocal = "MyStyle" Then MsgBox "Incorrect Style in use" End If End With With than... 4 18.10.2005 04:23:23 VBa- code to DLL Is there a way to convert VBA-code into a .DLL (Dynamic Link Library)? Jan... 9 17.10.2005 20:56:27 repeat MS - Word Macro until end of document Hello 2 All! I recorded a macro which does some search & replace to a whole paragraph in a MS Word document. Does anyone know how can I make that macro to repeat itself untill end of line i.e. end of the word document. The logic would be: While not eof do execute macro move 2 the next line/block od the word document end while Thanks. Regards, ... 2 17.10.2005 17:24:18 add page n of m text to footer The following code puts the page number in the footer easy enough, but how do you do something like "Page N of M"? ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary).PageNumbers.Add(wdAlignPageNumberLeft) ... 6 17.10.2005 15:08:33 a "Bookmarker" for word documents I am CONSTANTLY reading very long documents in word. When reading such documents - I often have to jump back and forth. Is there a "bookmarker" or "placeholder" button that I can use to record the current location. Then... if I navigate the cursor far away... I can just click it and it'll go back to that position? If not - any ideas on how to program it? The extent of my windows progra... 4 16.10.2005 02:07:45 I still have some problems with the check boxes. A MS Word XP (an agreement) has a userform attached from which I have to select various "variable text" to personalize the agreement. I have found how to use the text fields, the drop down lists and radio buttons and bookmarks, but I still have some problems with the check boxes. I have to check few boxes to select in which canadian province(s) the agreement is valid. All provinces are l... 4 14.10.2005 04:15:50 Show White Space I was hoping there was a property for the Word view object for 'show white space', but I can't find it. Is there such a thing?, or is there another way to do it? ... 3 13.10.2005 21:50:02 Set ParagraphFormat.SpaceAfter based on the style of the previous paragraph Not sure where to start on this and would appreciate any help anyone can offer. I've searched the archives a fair bit, but haven't seen anyone doing this. I want to set the Spacing Before to be the rough equivalent of double spacing before a particular style ("Case Heading") EXCEPT when preceded by the style "FolioNumSepLine". In that case I want to suppress the spacing before. So in... 3 13.10.2005 17:51:34 Macros deleted when emailed Hi, I have a few templates with two macros in them. When I mail a document based on one of these templates to someone else, it arrives without macros. I suspected the anti-virus of deleting them, but even with anitvirus disabled (on server, sending client and receiving client), the macros do not survive mailing. Where should I look for a way to fix this? Jeroen ... 7 13.10.2005 07:12:00 Text formatting with gotobutton This code does what I want it to except one thing: When you click the field and start typing I want the text to change to black. The field looks like this [One list] the [] are not part of the field, they are demarkators for the user to know this is an option in the text. They are also bold and red. When the user types over the field it is red bold text and i want it to be normal black ... 3 12.10.2005 14:11:24 set document title I am looking for a way to use VB automation to reset the title of a document. i.e. File-->Properties-->Summary-->Title I can't find any properties or methods related to this. Is it possible? Thanks. ... 3 11.10.2005 18:43:17 INSTALL VOLUME I have no sound help if any one can help me e-mail me at Pigbear48@aol.com... 1 10.10.2005 02:05:02 Difference between MacroButton field and CommandButton Hi, Being very new, I am interested in when you might use one of these over the other. I have a macro written in VBA editor called MoveData that opens another document and passes values from the first docuemnt into it. The macro works well. I need to put a button on the first document for a user to invoke the MoveData procedure when he is ready. I added a command button and subroutin... 2 08.10.2005 04:17:48 23 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23