how insert new line in MsgBox?

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Help, my template file size is out of control!! Hi all. I've been following everyone's advice and creating a template and using styles, no direct formatting, etc etc. Now, my template has grown to over 1 MB and there is not even any content to it yet!! Is there a way I can go through the document and see what's eating up all the space? (my latest addition was a table of contents and table of figures, and I noticed that jumped it up from 450k to 1.1MB ... however, it seems like 450k is even too large!!) Tag: how insert new line in MsgBox? Tag: 72735
  - 2
    - Programmatically creating charts with Word and VB.Net Hi to all! I have an issue that has been bugging me for quite some time and I hope that someone might be able to point me into the right direction here. The story is â?? I am writing an application that would allow a user to create a Word output from pre-defined data tables. The output can contain both charts and tables. While generating the output, Word or MSGraph cannot be visible to the user. What I have is something like this [CODE] private sub AddChart(params) Dim oShape As Word.InlineShape Dim oChart As Object oShape = _wordDocument.Bookmarks.Item("\endofdoc").Range.InlineShapes.AddOLEObject(ClassType:="MSGraph.Chart.8", FileName:="", LinkToFile:=False, DisplayAsIcon:=False) oChart = oShape.OLEFormat.Object If (chartOptions.UpdateDataSheet(oChart) <> True) Then CLogger.Log("Chart has no data present. Check to make sure you are not hidding the entire chart", CLogger.EntryType.Warning) End If CLogger.LogIf("Updating Chart Options") chartOptions.UpdateChart(oChart) oChart.Application.Update() oChart.Application.Quit() AddSection() End sub [/CODE] Here is what happens â?? first time we run this â?? everything is good, second time, Word document becomes visible as well as the MSGraph window appears. It happens when we hit the line with oShape = â?¦â?¦. I am wondering if someone knows the way to hide that Word document and that MSGraph window. Thanks in advance. Tag: how insert new line in MsgBox? Tag: 72730
  - 3
    - How do I UNHIDE ALL the toolbars in Word? Whenever I start up Word, I only see the Blue bar at the top of the window and the blank Word document. There are NO TOOLBARS shown (at the top, bottom, or on the sides of the window). How do I get the toolbars back? Tag: how insert new line in MsgBox? Tag: 72727
  - 4
    - set field sequence mandatory completion in form I would like to create a form with the the first few fields to be a mandatory completion before going on to the next. Tag: how insert new line in MsgBox? Tag: 72725
  - 5
    - Track changes, deletions and additions I have a bunch of documents with addition and deletion markups. I want to make a macro that will go through an entire document, find everything that is a deletion, put a true strikethrough on it, then deny the changes, so it stays on page, and keeps the strikethrough. Then i want the macro to go through and find all additions, font.color them wdColorRed, and accept the changes, so they're on the document and color of red. If anyone can help it's much appreciated. Tag: how insert new line in MsgBox? Tag: 72704
  - 6
    - Auto-create chart objects I have an excel spreadsheet with 600 rows in it. Each row has the name of an item followed by several columns of numbers. I need to create 3 different small charts in a Word document for each row in the spreadsheet. In word, you will see a Item Name, with 3 small, but different charts on the next line, followed by a blank line. I know I can create the charts in Excel using a macro and then copy and paste them into word as pictures. Once that is done, I can tell word to run a macro to format the pictures. But the quality of the text breaks down depending upon how much I stretch the charts. WHAT I WOULD RATHER DO is, either from Excel, tell word to insert Excel chart objects or from Word, get the data from Excel and create the chart objects. Using the first method, I have created a macro in Excel to tell Word to run a macro to put in a line of text with the item name in it, followed by a paragraph break, followed by inserting an Excel object. But where do I put the macro that tells the Excel object how to format itself? I do not want to store the macro in each Excel object as that would bloat the document. I have tried to place the Macro back in the original Excel sheet, but when I tell it to run, it seems to want to run within the original Excel sheet, not within the Excel object in Word. What am I doing wrong? Or am I missing something even simpler that would solve my problem? Tag: how insert new line in MsgBox? Tag: 72703
  - 7
    - View.ShowBookmarks problem Hello, if I change the value of View.ShowBookmarks for a specific document = window, it seems that Word will remember the setting and apply it to the = all the documents it opens subsequently. Is there a way to avoid this? Best wishes, Alex. --=20 Address email to user "response" at domain "alexoren" with suffix "com" Tag: how insert new line in MsgBox? Tag: 72702
  - 8
    - Word 2000 Merge with VBA I have a name badge document that I routinely merge with an Access data base on a server. I create name badges for several offices. Each office is generated with a make table and 2 append queries, with a query for the final data. The final data query for each office is used to create the name badges for each office. I recorded the merge process for one query, then copied for each office. The code is: Sub Merge_EventsDataBase_HOU() ' ' MailMerge Macro ' Macro recorded 8/17/2005 by cm9125 ' ActiveDocument.MailMerge.OpenDataSource Name:= _ "I:\Access\Registration_Lists_Pinnell\RegistrationLists_Original.mdb", _ ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _ WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _ Format:=wdOpenFormatAuto, Connection:= _ "QUERY Qry-N_B-Office-HOU-4-FinalData", SQLStatement:= _ "SELECT * FROM [Qry-N_B-Office-HOU-4-FinalData]", SQLStatement1:="" With ActiveDocument.MailMerge .Destination = wdSendToNewDocument .MailAsAttachment = False .MailAddressFieldName = "" .MailSubject = "" .SuppressBlankLines = True With .DataSource .FirstRecord = wdDefaultFirstRecord .LastRecord = wdDefaultLastRecord End With .Execute Pause:=True End With End Sub Copied this code and changed the query name for each of the other offices. This code ran fine, but when I tried the other offices got "Run-time error '5922': Word was unable to open the data source." Can someone help me with this? Also, on my computer it goes to the "I:" drive. On someone else's computer it may not be "I:". Is there a way to let the other user enter their drive number? Tag: how insert new line in MsgBox? Tag: 72697
  - 9
    - Basic Newbie Question: What's the ":=" operator for? I think the subject says it all. For some reason I can't find it in any references online. Thanks Tag: how insert new line in MsgBox? Tag: 72696
  - 10
    - genreate ms-word doc from excel Hi all, I have worked on an excel project recently with a lot of help form this board. The goal was to assort couple of tables from one sheet to another to make things easier for comparison. Now I have a new task. I need to generate couple of ms-word documents from this excel sheet. The plan right now is to have a menuitem like "Generate docs" in excelsheet and by clicking on that we can generate about 40 word documents or so. We have a word template file. For each word document we need to have the folowing things 1. Module name as the heading 2. Description of the module 3. Table of data All these information are in the excel sheet. They are stored in excel sheet using named ranges. Now, I need to gather these data and generate the word docs. What would be the best approach to solve this problem. Ideally we would like to do this with out even opening the word application. I am requesting your valued suggestions on this problem. Thanks in advance, shishi Tag: how insert new line in MsgBox? Tag: 72694
  - 11
    - Passing values from one .dot file to another .dot file Iam New member for this group!!!! My project is to pass values from .dot file to another .dot file (lets say two .dot files test1.dot and test2.dot) test1.dot: When user runs the macro go(), the wizard / form will be open to enter the employee number, once he enters, it prints the Employee number in a document (Doc1) and saved it to the disk, after this it will open test2.dot test2.dot: This should calculate the salary based on the employee number received from the test1.dot, and attach the salary component to the earlier created file (Doc1) by test1.dot Iam not sure how to pass the values from one .dot file to another .dot file test1.dot code =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Private Sub CmdFinish1_Click() ActiveDocument.Bookmarks("Firs=AD=ADtName").Range.Text =3D Me.txtFirstName.Text ActiveDocument.Bookmarks("EmpN=AD=ADumb").Range.Text =3D Me.TextBox1 test1.Enabled =3D False ActiveDocument.SaveAs FileName:=3D"C:\doc1.dot" ActiveDocument.SaveAs FileName:=3D"C:\doc2.dot" Call test2 Unload Me Application.Quit End Sub Public Function test2() Dim wrdAppl As Word.Application Set wrdAppl =3D New Word.Application wrdAppl.Documents.Open ("C:\test2.dot") Set wrdAppl =3D Nothing End Function test2.dot code =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Private Sub Document_Open() ActiveDocument.Bookmarks("bksa=AD=ADlary").Range.Text =3D salary test2.Show End Sub Public Function salary() As String Dim sal As String If (ActiveDocument.CustomDocument=AD=ADProperties.Item("Employee").V=ADa=ADlue =3D "1") Then salary =3D "100K" ElseIf (ActiveDocument.CustomDocument=AD=ADProperties.Item("Employee").V=ADa=ADlue =3D " ") Then salary =3D "Salary not generated" End If End Function Private Sub CmdFinish2_Click() ActiveDocument.Bookmarks("Last=AD=ADName").Range.Text =3D Me.txtLastName.Text Dim Doc1 As Word.Document Set Doc1 =3D GetObject("C:\doc1.dot", "Word.Document") Doc1.Range =3D Doc1.Range + ActiveDocument.Range Doc1.SaveAs FileName:=3D"C:\doc3.dot" Doc1.Close 'close doc3 Set Doc1 =3D Nothing Unload Me ActiveDocument.Close 'close test2.dot End Sub in test2.dot =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D I have written code to read the values from customdocumentproperties if we want to see manually ..open any document go to File menu -> Properties -> Custom Tab. What i need is to get the employee number from test1.dot to the custom properties of the test2.dot so that i can perform necessary salary calculations If any of know how to pass the values from .dot file to another .dot file will be a great help You can directly mail to me if you need the test1.dot and test2.dot files for any clarification I will also update the groups as and when required=20 Thanks=20 Srini Tag: how insert new line in MsgBox? Tag: 72693
  - 12
    - OT: Agent Forte and Private Groups Hi everybody, since the last harddrive crash I'm trying without success to get back to the private groups. I'm using agent forté. Maybe someone can help me via EMail, as I don't want to molest the group with this. Might become a long story, as I am completely lost and I don't have the faintest idea where to start. Helmut Weber Tag: how insert new line in MsgBox? Tag: 72689
  - 13
    - Problem with Word Code in 2003 I am performing a mail merge in Word through an Access database. As part of the process, I check to see if a Word document is already a mail merge document, and then, if it is, if it has the correct data source. Thus, from within Access, I use: If objWord.ActiveDocument.MailMerge.State=wdMainAndDataSource Then ... This has worked fine with Access/Word 2000, or if the program is used with Access/Word 2002. However, with Access/Word 2003, the MailMerge.State value returns wdNormalDocument (0) instead of wdMainAndDataSource (2). I double-checked the document, and it clearly is a mail merge main document with a data source. When when read through Access, I get the return value of a normal document. Any ideas as to what's going on? Thanks, Neil Tag: how insert new line in MsgBox? Tag: 72688
  - 14
    - date code question I am trying to modify the date code field to automatically populate a date in my word document X number of days from the present date. Would I be able to modify the following to accomplish this task and if so, how would you go about doing it? { DATE \@ "dddd MM/dd/yy"} So, when this document is edited today (08/18/05), the code will produce: Thursday 08/18/05 I want to modify the code so it is always smart enough to add X days to the date automatically. So, if I wanted it to display a date 7 days into the future (X=7), output would automatically be adjusted to display: Thursday 08/25/05 How can the date code listed above be modified to accomplish this? Thanks. Tag: how insert new line in MsgBox? Tag: 72687
  - 15
    - Controlling text wrapping around an image. Hello We generate word documents from content in a database (AuthorIT application). I want to have an image on the front page of my document _behind_ the text. When generated, the text is wrapped around the image. I want to use a macro to set the image to display beneath the text. I have come up with this macro: Sub MoveImage() Dim iShape, Shape On Error Resume Next For Each iShape In ActiveDocument.Sections.First.Range.InlineShapes iShape.ConvertToShape Next For Each Shape In ActiveDocument.Sections.First.Range.ShapeRange Shape.WrapFormat.Type = wdWrapThrough Next End Sub This doesn't work when run as soon as the doc is generated, but curiously does work if i manually select the image then run it. Can anyone help me to develop a macro that will set the desired wrapping without any manual action? Thanks Dave. Tag: how insert new line in MsgBox? Tag: 72671
  - 16
    - HELP!!- Object or class does not support set of events Hi. I'm trying to run a mailmerge from VB6(sp6) which produces a set of labels. It works fine from my development machine but when I install the app anywhere else I get the error above. I'm not even sure where to start in trying to solve this error. Any help at all would be greatly appreciated. I'm developing on XP and the project references Microsoft Word 11.0 Onject library...if that helps. Thanks Tag: how insert new line in MsgBox? Tag: 72668
  - 17
    - Some method to have allways 'macro' docs ? Hello again : I know all the conditions regarding macro security, but I really want a corporate system to avoid that somebody can't open a doc without use it's autoopen macro. I know about server solutions, but my ask is the next : If user have top level of security set, is it possible to force to user to execute corporate macros ? Thanks and excuse my bad english Antonio Pérez Tag: how insert new line in MsgBox? Tag: 72665
  - 18
    - Find method rebound sometimes Hello : I have a document with paragraphs and tables, in some cases I have nothing ( only a carriage return symbol ), but ( because many people worked in the docs ) it has a style I want to change. I have a macro to find all these cases but my 'do... loop macro' rebound eternally when find those cases. I fix the problem making : Selection.MoveRight(Unit:=wdCharacter, Count:=1) Selection.MoveDown(Unit:=wdLine, Count:=1) but it is not the solution ( in addition it fails ) Some idea ??? Antonio Pérez Tag: how insert new line in MsgBox? Tag: 72664
  - 19
    - Print Directly To PDF What line of code would I use in word to print a document directly to a PDF without getting in information form the user. The variables that I would want to set in code would be: For the PDF to be saved in the same location as the original document. I want to set the name of the PDF in code The name of my PDF printer is: "Adobe PDF" I just want to put a button on a word document that prints the current to a PDF storing it in the same location as the original document and with a file name that I set in code. Thankyou in advance for your help. Tag: how insert new line in MsgBox? Tag: 72660
  - 20
    - Word should have a dumb mode Word should have a mode that turns off all the auto-formatting to that you can write a document in free format. I'm thinking of a simple toggle button rather than having to go into a menu and uncheck a bunch of boxes. Recent versions of Word have become too damn helpful..... ---------------- 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=f76929cd-0b91-4043-bcb1-22c087f0e219&dg=microsoft.public.word.vba.general Tag: how insert new line in MsgBox? Tag: 72658
  - 21
    - document object prompt unexpected save as dialog In my VB6 DLL, I create a word document object, and some mailmerge and save to a file. It works well before but now (No any change to this DLL) it prompt an unexpected save as dialog, and after I save the document, dll raise error "you cann't insert the selection into table". In vb code I called document.saveas funcion. Can anyone help? Tag: how insert new line in MsgBox? Tag: 72650
  - 22
    - Display Print Dialog Thankyou in advance. I have the bellow code capturing the print event. But what I would like to do is still display the Print Dialog so the user can change which Printer they wish to print to instead of just the default. Sub FilePrint() ActiveDocument.txtBox = "Job File Copy" ActiveDocument.PrintOut ActiveDocument.txtBox = "Client Copy" ActiveDocument.PrintOut ActiveDocument.Save End Sub The requirement for the document is that it prints out in duplicate and the heading needs to be different on each print out. The above code achieves the printing in duplicate and changing the headings but only to the default printer. I would like to display the Print Dialog so that they can change the printer. Thankyou again. Tag: how insert new line in MsgBox? Tag: 72648
  - 23
    - .Next feature In the following code why does the line MsgBox aWord.Next return just the first letter of the next word rather than the complete word? Thanks Sub Testing() Dim aWord For Each aWord In ActiveDocument.Range.Words MsgBox aWord MsgBox aWord.Next Next aWord End Sub -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. Tag: how insert new line in MsgBox? Tag: 72647
  - 24
    - Programatically adding new autotext entries to a global template I'm in the process of (hopefully) improving the overall use of Word XP in our small office. Being a self-taught newbie to VBA, I've found this newsgroup to be of real value as a source of info and tips. As part of the process, I've created a global template ( called RI_Global.dot) which will hold, amongst other things, all our generic autotext entries, ie - ones we want to be available all the time in any document. What I'm seeking guidance about concerns the way a new user-created autotext entry is "saved" to a template. My understanding is that the default choice is the normal.dot template, whereas I want the entry to be saved into RI_Global.dot. Is it possible to "force" a newly created AutoText entry to be saved into RI_Global.dot, rather than relying on the users to remember to choose this template when they access the Insert/AutoText/AutoText command? Also, can I intercept the "Alt+F3" shortcut to again force the entry to be saved to my global template? I've found the appropriate(?) dialog which might be interceptable [ie: Dialogs(wdDialogEditAutoText)], but I can't see how any of the options can be manipulated through VBA. Using the macro recorder and selecting the global template from the "Look in:" drop-down box doesn't shed any light on the steps involved when I look at the resulting code. Thanks in anticipation. Regards, Gavin Tag: how insert new line in MsgBox? Tag: 72645
  - 25
    - Amending the File Open dialog Since upgrading to Word2003 I notice that the "Look in" box in File/Open dialog always seems to point to the last directory I used. Whilst this is sometimes convenient, most of the time I want to open files in the specific directory, "DirName", which I have created to contain my most used files, with its own tree substructure. I therefore wish to ensure that "Look in" always defaults to that given directory. Could (or should) this be achieved by modifying the following module already installed which ensures that the "Files of type" box always shows "All Files":- Sub FileOpen() With Dialogs(wdDialogFileOpen) .Name = "*.*" .Show End With End Sub Or should a separate new module be used. Being not too familiar with the Visual Basic codes, can someone kindly advise how to do this. Thanks Jack Sadie Tag: how insert new line in MsgBox? Tag: 72643
- Next
  - 1
    - drag & drop to word Hi, how to enable drop function(have a drag icon displaying, like drag something from outlook to Word) when I drag files in my application(VB application) into MS word document. Please help. Thanks. Tag: how insert new line in MsgBox? Tag: 72638
  - 2
    - Creating documents with a serial number I'm trying to figure out how to serialize documents when printing. For example, if I want to print 30 copies, I'd like each copy to have a different serial number for each one from 01-30. This would ideally be placed in a document footer, and would reset (or not reset) each time the document is openedAny help would be greatly appreciated. Tag: how insert new line in MsgBox? Tag: 72637
  - 3
    - How to Add Hyperlink to Protected Word Form Not sure if this is possible but I have a protected Word form where I need the following to happen: I have a checkbox where if it is unchecked then TextBox1 should be "N/A". However if the checkbox is clicked, I need Textbox1 to populate with Null, and Textbox2 to populate with a hyperlink. Anyone have any ideas how to do this? BTW I'm a beginner when it comes to programming so layman's terms would be great! Tag: how insert new line in MsgBox? Tag: 72636
  - 4
    - Clean Up for Merge Code Dear All, I have a template that is creating a new document using data from an access query that is merged into a Word template. All Office 2003 apps on Win2K and XP pro workstations. The document is created -- but there is also an additional "Document 1" that is created every time that has to be deleted -- a copy of the template with no data in it. If anyone can point out how I can eliminate that extra clutter, I would appreciate it. Additionally, my code is messy, since a lot of it was generated by recording. I'd appreciate gentle recommendations for cleaning it up. Right now, it says" Sub autonew() ' Perform Merge using CatalogTextSource.txt ActiveDocument.MailMerge.MainDocumentType = wdFormLetters ActiveDocument.MailMerge.OpenDataSource Name:= _ "C:\TEMP\MtgNoticeSource.txt", ConfirmConversions:=False, _ ReadOnly:=False, LinkToSource:=True, AddToRecentFiles:=False, _ PasswordDocument:="", PasswordTemplate:="", WritePasswordDocument:="", _ WritePasswordTemplate:="", Revert:=False, Format:=wdOpenFormatAuto With ActiveDocument.MailMerge .Destination = wdSendToNewDocument .MailAsAttachment = False .MailAddressFieldName = "" .MailSubject = "" .SuppressBlankLines = True With .DataSource .FirstRecord = wdDefaultFirstRecord .LastRecord = wdDefaultLastRecord End With .Execute Pause:=True End With ' Save New Merge Document as NewMeetingNotice.doc ChangeFileOpenDirectory "C:\My Documents\" ActiveDocument.SaveAs FileName:="\\cpa_comp\chapters\_chapter Programs\-Chapter Notice E-Form\__Current\NewMeetingNotice.doc", FileFormat:= _ wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:= _ True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:= _ False, SaveNativePictureFormat:=False, SaveFormsData:=False, _ SaveAsAOCELetter:=False Followed by code to clean up and format the document Thnak you in advance for any assistance. Sincerely, Ridge (in New Joisey) Tag: how insert new line in MsgBox? Tag: 72631
  - 5
    - Identifying Pictures and Drawing Objects I've done some work with a template that shows and hides graphic images -- allowing a user to fax a document (show image of logo) or print the document on letterhead (hiding image of logo). I found that the picures came in as "Picture 11" and "Picture 22" and so on. I was able to identify them by using the recorder and selecting them and then looking at the code. But I was wondering if there is any, more efficient way, to identify image and drawing objects? Ridge (in New Joisey) Tag: how insert new line in MsgBox? Tag: 72628
  - 6
    - PrivateProfileString I have been using this method to store user defaults for client templates. In probably 8 years I've never had a problem with it. Now, I've had two testers run into problems where the .ini file doesn't seem to be storing, or if it does, it's not where I expect it to be. Since the client is in another city, I can't just sit at their PCs and figure out what's going on, so wonder if anyone here might have experienced any problems with this method. Word 2003. System.PrivateProfileString _ ("c:\" + vUser, "CHRTemplates", Key) = Value sGetProfile = System.PrivateProfileString _ ("c:\" + vUser, "CHRTemplates", Key) vUser is Application.UserName -- Colleen Tag: how insert new line in MsgBox? Tag: 72627
  - 7
    - Previous bookmark I'm using code to check to make sure an entry was made in a bookmarked field. After the message box prompts the user that the field requires an entry, how do I get back to the original bookmark, so that the user cannot go any further until an entry is made? Thanks. Amy Tag: how insert new line in MsgBox? Tag: 72625
  - 8
    - Strange toolbar behavior I have several toolbars with macros assigned to them. Two macros, for no apparent reason I can figure, rearranges the toolbars when I run them. The macros themsleves don't appear to have anything in them that would affect toolbar positions. They are both used to convert fill-in form fields to plain text -- one does the whole document, the other just does whatever is selected. When either macro runs, it moves two of the custom toolbars from one location to another. One toolbar has these macro assigned to it, the other is a custom toolbar with other macros, but not these particular ones. None of the other macros move toolbars around. The macros appears below, for what it's worth. Anyone have any ideas what might be causing this? Macro 1 ActiveDocument.PrintPreview ActiveDocument.ClosePrintPreview Selection.WholeStory Selection.Fields.Unlink Selection.HomeKey Unit:=wdStory Macro 2 ActiveDocument.PrintPreview ActiveDocument.ClosePrintPreview Selection.Fields.Unlink Selection.MoveLeft Unit:=wdCharacter, Count:=1 Tag: how insert new line in MsgBox? Tag: 72623
  - 9
    - Incorrect page numbers after inserting files MS XP / Word 2000 â?? 2003 Page Numbering Woes â?? I am having a hard time getting my document to correctly number pages, any help greatly appreciated. I am working on a macro that allows users to apply formatting to a document, add table of contents and insert other documents (called boilerplates) to the beginning of the original (after TOC). I am able to insert the requested documents using the following code: Note: at the time of inserting the documents the table of contents has already been inserted. Sub _Boilerplates() 'add selected boilerplates to current document Dim iCnt As Integer For iCnt = 0 To frmSpecMain.lbBoilerplates.ListCount - 1 If frmSpecMain.lbBoilerplates.Selected(iCnt) Then Selection.HomeKey Unit:=wdStory ActiveWindow.ActivePane.View.Type = wdPageView ' Go to second section Selection.GoTo What:=wdGoToSection, Which:=wdGoToFirst, Count:=2, Name:="" Selection.InsertFile FileName:=gstrDocFullPath & _ frmSpecMain.lbBoilerplates.List(iCnt), _ Range:="", ConfirmConversions:=False, Link:=False, Attachment:=False Selection.InsertBreak Type:=wdSectionBreakContinuous End If Next ActiveDocument.Save End Sub After inserting the boilerplates I run the following code to number the pages: Sub _PageNumbers() ' ' Add page numbers to the final document ' Dim i As Integer i = Selection.Sections.Count ' go to top of document and clear find area Selection.HomeKey Unit:=wdStory Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting Selection.HomeKey Unit:=wdStory With Selection.Sections(1).Headers(1).PageNumbers .NumberStyle = wdPageNumberStyleLowercaseRoman .HeadingLevelForChapter = 0 .IncludeChapterNumber = False .ChapterPageSeparator = wdSeparatorHyphen .RestartNumberingAtSection = True .StartingNumber = 1 End With Selection.Sections(1).Footers(1).PageNumbers.Add PageNumberAlignment:= _ wdAlignPageNumberRight, FirstPage:=True For i = 1 To Selection.Sections.Count + 1 ' Skip to Next Section and number those pages Selection.GoTo What:=wdGoToSection, Which:=wdGoToNext, Count:=1, Name:="" Selection.Sections(1).Footers(1).LinkToPrevious = False ' Now number body With Selection.Sections(1).Headers(1).PageNumbers .NumberStyle = wdPageNumberStyleArabic .HeadingLevelForChapter = 0 .IncludeChapterNumber = False .ChapterPageSeparator = wdSeparatorHyphen .RestartNumberingAtSection = True .StartingNumber = i - 1 End With Selection.Sections(1).Footers(1).PageNumbers.Add PageNumberAlignment:= _ wdAlignPageNumberRight, FirstPage:=True Next End Sub What happens is that the newly inserted boilerplates all have the page number 1, as well as the beginning of the original document. Harrumph. Again any suggestions greatly appreciated, thank you all from Sunny Central Florida. Tag: how insert new line in MsgBox? Tag: 72622
  - 10
    - How to insert a field in a table cell I use "ActiveDocument.Fields.Add Range:=..." all over the document and it works fine. When the range is myTbl.Columns(1).Cells(1).Range I get "Runtime error '4605' This command is not available". What am I doing wrong please? Tag: how insert new line in MsgBox? Tag: 72619
  - 11
    - Replacing Bookmark Text - Userforms (FYI - I posted this on the beginners, general, and userforms boards.) I have created a template where I created a userform with 2 "fields" (ProjectName and TaskName). Each field corresponds w/a bookmark. I'm using REF commands to link/repeat the bookmarks in the footer of the report. It is all working well except that the data that is input through the userform is getting added to the (default) bookmark text instead of replacing it. I found a MVP document that gives me a general idea of what I need to do (set a bookmark range variable) {MVP Doc: Inserting text at a bookmark without deleting the bookmark}. It includes a subroutine when using a macros/userform, but I'm not sure where to put it. Can anyone help me with this??? THANK YOU! Wendy Now, template bookmarks look like: [ProjectName] and [TaskName]. If I input a 1 (for project name) and a 2 (for task name) in the userform when I open a new document, the bookmark data changes to: [1ProjectName] and [2TaskName]. I need it to change to [1] and [2] (but keep the bookmarks). My VBA code has: AUTONEW MODULE Sub AutoNew() ' ' AutoNew Macro ' Macro created 8/16/2005 by wdaniels ' UserForm1.Show End Sub USERFORM - Commandbutton1 Private Sub CommandButton1_Click() With ActiveDocument .Bookmarks("ProjectName").Range _ .InsertBefore TextBox1 .Bookmarks("TaskName").Range _ .InsertBefore TextBox2 End With UserForm1.Hide End Sub Tag: how insert new line in MsgBox? Tag: 72617
  - 12
    - How to open an embedded Word doc using VBA? I have an embedded Word document within an open Word document. I would like to create a macro that opens the desired embedded Word document and goes to a predefined bookmark within it. Does anyone know how to do this programmatically? I'm using Word 2000 but the doc will be used by Word 2000 & 2003 users. Thanks for your help! -- JoAnn Tag: how insert new line in MsgBox? Tag: 72616
  - 13
    - Duplex Printing In Word Greetings, I found a macro that is suppose to manually print duplex for printers that don't have the duplex option. The code is suppose to print the current page in the active document, open a messagebox so the user can manually flip the page, and then print the second (or even) page after the user presses ok. The macro does print, but only after the code finishes running. For some reason, it only spools the the first print current page command, and then prints it when the code finishes running. Any help would be great! Thank you! Here's the code: Sub PrintBothSides() ' ' PrintBothSides Macro ' Dim iTemp As Integer ActiveDocument.PrintOut (ManualDuplexPrint), Copies:=1, Range:=wdPrintCurrentPage iTemp = MsgBox("Switch paper to continue", vbOKCancel, "PrintBothSides") If iTemp = vbOK Then ActiveDocument.PrintOut Copies:=1, PageType:=wdPrintEvenPagesOnly End If End Sub Tag: how insert new line in MsgBox? Tag: 72615
  - 14
    - Access Database Update I have an Access database which contains information for a form. I use the database for merging with a Word template which is then sent out to customers via email. I also have text form fields for the customer to fill out in response to the original information. These transactions happen 5 or 6 times a day and cutting and pasting just doesn't cut it since the returned information is lengthy. Everything is working beautifully, except I don't have an easy way to import the data from the text form field back into the database. I would like the returned form to be able to be attached to the Access database much the same way that it works the other way around. Is that possible? The users of this system need a button to be able to do this. If I got hit by a gasoline tanker tomorrow, they wouldn't have a clue as to what to do with the returned info from the Word form. Tag: how insert new line in MsgBox? Tag: 72614
  - 15
    - Outlook type Library not available as a reference I am using MIcrosoft Office Word 2003 SP1. I am trying to use code contributed by Astrid Zeelenberg in the article "How to send an email from Word using VBA." The article says I need to set a reference to the Outlook type library under Tools-References. I can not find a reference to Outlook type library. Is this something I need to install seperately? If so, could someone please tell me what I need to do to have access to this reference. Thanks Tag: how insert new line in MsgBox? Tag: 72613
  - 16
    - CreateButton - EraseButton Hi, I have created a new button in CommandBar: Sub CreateButton() Dim nBtn As Office.CommandBarButton Dim cBar As Office.CommandBar Dim BtnExists As Boolean Dim Pos As Integer Dim i As Integer On Error GoTo eh Set cBar = Application.CommandBars("File") Let BtnExists = False For i = 1 To cBar.Controls.Count If cBar.Controls(i).Caption = "MyButton" Then Let BtnExists = True End If If cBar.Controls(i).Caption = "Save &As..." Then Let Pos = i + 1 End If Next If BtnExists Then Set nBtn = cBar.Controls("MyButton") Else Set nBtn = cBar.Controls.Add(msoControlButton) Let nBtn.Caption = "MyButton" End If Call nBtn.Move(Before:=Pos) Let nBtn.OnAction = "RunAPI" Exit Sub eh: MsgBox ("Error " & CStr(Err.Number) & ": " & Error) End Sub Then I need to erase that button while closing document. I tried either to reset CommandBar (cBar.Reset) or call Delete method (Call nBtn.Delete(False)) on that button. Works fine, but only for current session. After that, when I open Word, button is still there. Any suggestion? I need to erase the button permanently. Thanks in advance. Jiri Tag: how insert new line in MsgBox? Tag: 72612
  - 17
    - Add a record to an Access table from Word I have a document database in Access. When I create a new document in Word I would like a new record added to Access. When the record is created, Access generates a simple sequential number for the document. Word then retrieves the number. How do I have Word instruct Access to make a new record? -- Stephenc Tag: how insert new line in MsgBox? Tag: 72600
  - 18
    - Undo event Hello All, 1/ Is it possible that we somehow restrict word to add entries in Undo stack. else 2/ Is it possible that we group some events as one Undo event. Please help as i am making a addin for office in vb.net GS Tag: how insert new line in MsgBox? Tag: 72589
  - 19
    - Wildcard Search and "OR" Hello, using wildcards can I search for one word OR another? For example I would like something like the following to work: "apple|pear", but I can't seem to find out what the Word wildcard equivalent of the regular expression symbol "|" is, to mean "OR". Thanks Tag: how insert new line in MsgBox? Tag: 72578
  - 20
    - DocumentBeforeClose problems Hello, The DocumentBeforeClose event gives me grief. The problem is that I have to perform a certain cleanup operation when a = document is closed. Unfortunately, DocumentBeforeClose is called before the user is = presented with the "Document changed, do you want to save?" dialog, = which can cancel the close. So, I do not know whether the document was actually closed. Is there a way around it? Thanks. Best wishes, Alex. --=20 Address email to user "response" at domain "alexoren" with suffix "com" Tag: how insert new line in MsgBox? Tag: 72573
  - 21
    - Remembering document-specific window position Certain of my editing tasks involve having multiple open docs in Word. Given limited screen real estate, I carefully size the windows before setting to work, which is a pain. I'd like to write up or find a macro that would, on a document-by-document basis (very important), save the window size/position for that particular document on closing, then, on reopening, have Word get the window properties from the individual doc template or information and restore to the saved position. Ideally, I'd load this in Normal.dot and invoke it with a keystroke combo as an alternative way to close docs. Is there a way to do this? I've searched high and low, but can't find anything on how to do it with VBA (I'm in Word 2002 on WinXP, with VB 6.3). I know it's possible because so many apps do it (including WordPerfect back in the day when I used it), but I don't know if it's doable in VBA. The only thing I find in online VBA resources is discussion of saving the /application/'s main window position and writing to the registry to do so -- but that's not what I'm seeking. Any ideas? TIA, Ed ed [at] coherenow.com Tag: how insert new line in MsgBox? Tag: 72564
  - 22
    - Conditional format a table cell (background colour) Hello all, Very little experience with Macros but I have created a project plan template containing various form fields and any number of macros (mainly via the recorder with a bit of code tweaking). One of the text fields in the table is a due date. Via VBA is there any way to highlight the date cell or even the entire row by changing the background colour red when the date is overdue? I guess this would be quite straight forward in Excel via Conditional formating but I would really like to do it in Word. Any help appreciated. Thanks. Paul. Tag: how insert new line in MsgBox? Tag: 72559
  - 23
    - maintaining the formatting of a string I used to know this but forget--If a text selection has character formatting such as underlining, and I'm turning the selection into a string and then inserting that string elsewhere, how do I maintain the formatting of the string? Tag: how insert new line in MsgBox? Tag: 72558
  - 24
    - Real and curious problems with vba office2000 et office2003 on a computer Since some days, I have some problems with VBA (with Access as well as Word). All these problems exist in Office 2000 as well as in 2003 Some VBA functions do not vork anymore. ========================================================== So the function 'Kill' is completly unefficient. I mean that 'Kill' doesn't kill files, but, worse, give no error message if I ask to 'Kill' a file which does not exists (for example with a bad path). So the line : ----------- Kill "c:\program files\internet explorer\iexplore.exe" ----------- does not give a message. Just the program quit the function where is the line without executing the lines after. There is no error treatment un function. If I put a Rem or a "'" at the begining of the line, the lines after are executed. If the path of the program to kill is bad (for example "c:\progr files\internet explorer\iexplore.exe" , there is no error message! ========================================================== The function 'Mkdir' does not work anymore. So the line : ----------- MkDir "c:\xxxxx" ----------- doen't create the dirextory 'xxxxx'. ========================================================== The procedure : ----------- Sub Test () Dim FileNumber as integer FileNumber = FreeFile Open "c:\TEST" For Output As #FileNumber Write #FileNumber, "Ceci est un exemple" Close #FileNumber End Sub ----------- does'nt create the file and the error message says that the file does not exist ! It do not accept to create it... ========================================================== The function 'Shell' does not work anymore. So the line ----------- Shell "c:\program files\internet explorer\iexplore.exe", vbMaximizedFocus ----------- does'nt launch Internet Explorer. If the path given in string is bad, there is no error message. ========================================================== I don't know if the following problem is bound to there others problems, but now I cannot use the function "Export in Word" or "Export in Excel" or "Export in 'presse-papier'" for exportations of preview of report. No problem if I export to Word a preview of a form or of a table or of a query. But it is now impossible to export a report preview towards Word. =========================================================== I have Windows XP PRO. I have Office 2000 developer, and Office 2003. All these problems can be observed VBA 2000 AND VBA 2003 (in Accesss 2003). ============================================================ I have uninstalled and reinstalled twice both Office 2003 and Office 2000. No results. ============================================================ On my second computer, all is good. To replace filesystem functions I use 'Scripting.FileSystemObject', which works PERFECTLY. ============================================================ The functions that does not work on my pricipal computer work on the second computer. Which can be ABOVE VBA in the first computer which can cause this kind of problems ? HOW CAN I REPLACE the 'Shell' function ? Thanks for responses. And excuses for my english. I am french... Tag: how insert new line in MsgBox? Tag: 72557
  - 25
    - Command Button in Word I want put a button on 15 pages this button the next commando must carry out, if I click on the button he the page where this button on state must remove. there is someone who can me give the complete code to let work to this button Tag: how insert new line in MsgBox? Tag: 72556

In the [prompt] argument of MsgBox, how do I start text on a new line?
Thanks.

Re: how insert new line in MsgBox? by Jay

Jay
Fri Aug 19 23:03:32 CDT 2005

Precisely. :-)

On Sat, 20 Aug 2005 11:17:38 +0930, "Jezebel"
<warcrimes@whitehouse.gov> wrote:

>GMTA
>
>
>
>"Jay Freedman" <jay.freedman@verizon.net> wrote in message
>news:mvrcg11t039h8tv5d1rmugnvnijh7a2026@4ax.com...
>> On Fri, 19 Aug 2005 17:41:26 -0400, Rick Charnes
>> <rickxyz--nospam.zyxcharnes@thehartford.com> wrote:
>>
>>>In the [prompt] argument of MsgBox, how do I start text on a new line?
>>>Thanks.
>>
>> Insert the constant vbCr in the proper place, like this:
>>
>> MsgBox "Line 1" & vbCr & "Line 2"
>>
>> --
>> Regards,
>> Jay Freedman
>> Microsoft Word MVP FAQ: http://word.mvps.org
>

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

Top