How to use the system ListView to programming in VBA?

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - How to use the system ListView to programming in VBA? During a question of discussing setting line space in a listbox of VBA,I realized (not very sure)that the ListBox control of VBA is different from that of VB?The reason is the class name of ListBox in VBA isn't the same as that of in VB.So I guess they are two different kinds of controls. ------------------------------------------------ An Tag: How to use the system ListView to programming in VBA? Tag: 86727
  - 2
    - Create macro to save existing filename and increment it if duplica Sub test1() ' ' test1 Macro ' Macro recorded 6/6/2006 by rachel ' Sub SaveIncrementedFilename() Dim PathAndFileName As String, n As Long PathAndFileName = "C:\Documents and Settings\itlap\Desktop\temp" If Dir(PathAndFileName & ".doc") = "" Then ActiveDocument.SaveAs (PathAndFileName & ".doc") Else n = 1 Do While Dir(PathAndFileName & n & ".doc") <> "" n = n + 1 Loop ActiveDocument.SaveAs PathAndFileName & n & ".doc" End If ActiveDocument.Close End Sub -- Rachel Tag: How to use the system ListView to programming in VBA? Tag: 86726
  - 3
    - Temporary Toolbars I want to create a toolbar, but I don't want to affect the normal (or any other global) template. By that, I mean I don't want, upon exit, the normal (or other) template to save (or ask to save). I thought that by creating a temporary toolbar, I could accomplish this. Here is the code Set myBar = CommandBars.Add(name:="Custom", Position:=msoBarFloating, temporary:=True) But, that does not do the 'trick.' When I exit Word, normal.dot saves. Is there any way to create a truly temporary toolbar in such a way that normal.dot doesn't think it was modified? (I did try CustomizationContext and set the reference to another global template, but when I exited Word, Word asked if I wanted to save the context template. I need a 'clean' exit, if at all possible.) Thanks. (I was, of course, hoping that a truly temporary toolbar would not cause Word to think anything was modified.) Ed in Virginia Tag: How to use the system ListView to programming in VBA? Tag: 86723
  - 4
    - word should let you create and customize shortcuts to features word should let you create and customize shortcuts to features on the toolbar. i use the symbol function frequently, and it is a pain to keep having to move my hand from the keyboard. is there a way that i can set custom shortcuts? i know that in word perfect the shortcut is ctrl+w. if someone can let me know about how to create custom shortcuts or the existing one for symbol, that would be great!! thanks ---------------- 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=00fe37bf-fa81-4680-b504-742669a41c89&dg=microsoft.public.word.vba.general Tag: How to use the system ListView to programming in VBA? Tag: 86721
  - 5
    - Word vba issue I made two textboxes in a Microsoft Word document. They're called text2 and text3. When I click on text3. I wanted a word to appear in text 3 if text2 contained a certain string, but it doesn't work. Private Sub text3_click() If text2 = "john" Then text3 = "Doe" End If End Sub Tag: How to use the system ListView to programming in VBA? Tag: 86715
  - 6
    - Send email with active doc attachment to specific person Hello, I have searched this site for my answer and have found this question posted many times but don't find a clear answer (at least not to me). Hopefully someone can clear it up for me? I need to send a form out to many recipients -- all are in the same organization, on the same version of Word (2002), and the same version of Outlook (2002). Once they complete the form I would like to add a Submit button at the bottom of the page which will open an email addressed to a specific person, and attach the active document. Here's is the code I found: Activedocument.HasRoutingSlip = True With Activedocument.RoutingSlip .Subject = "New subject goes here" .AddRecipient "Firstaddress@Mail.com" .AddRecipient "Secondaddress@Mail.com" .Delivery = wdAllAtOnce End With Activedocument.Route ....but I don't know what to do with it. Do I create a macro and then assign that macro to a submit button? If so, I don't know how to assign a macro to a specific object. Any help would be appreciated. Thanks, Christine Tag: How to use the system ListView to programming in VBA? Tag: 86713
  - 7
    - Seeing Entire Subject Line of Posts Is double-clicking to bring up a thread in a new window the only way I can see the whole subject line when it's particularly long? Adjusting the widths of the panes doesn't seem to do it. I'm sorry to post this on this board, but I could not find a "How to use the boards" type area to ask. Thank you. Tag: How to use the system ListView to programming in VBA? Tag: 86708
  - 8
    - Built-in Dialogs I want to use the built-in Word dialog for page setup but I would like to know if it's possible to remove or gray out the "Default" button that is on this dialog. In addition, is it possible to use one of the built-in dialogs but add a custom button to it? Tag: How to use the system ListView to programming in VBA? Tag: 86707
  - 9
    - LDAP 1.0 type library Hello, I have a module which includes ADO connections. When I run it, everything is fine, but when I put it on anyone else's machine they get and error that they are missing the LDAP 1.0 type library. As far as I know I am not using any LDAP connections, just ADO. Could someone tell me where I can get the LDAP type library? I'm not sure what file it is and the references in VBA don't really help. Thanks in advance for any help you can provide. Tag: How to use the system ListView to programming in VBA? Tag: 86702
  - 10
    - removing all existing projects & toolbars is there any way to do this programatically? currently all our users have toolbars & macros installed locally which has become rather time consuming when there are changes/additions/updates. one office has been using a shared network location as the startup directory and we're going to implement it nationally - would like to create an install macro that removes all existing toolbars & macro projects and then updates the startup directory if possible? thanks in advance! Tag: How to use the system ListView to programming in VBA? Tag: 86699
  - 11
    - saving variables to normal.dot i've got users' startup directory set to a shared network location that is read only. i'd like to be able to save some local preferences/info for each user - is it possible to do this to the normal.dot file, or is there a better method available? thanks in advance Tag: How to use the system ListView to programming in VBA? Tag: 86697
  - 12
    - VB.NET to Word: Error 4608 - Value Out Of Range I'm having a problem with some VB.NET code that is using automation to create and print a Word document. When I try to set the page margins in code, I'm getting an error 4608, "Value out of range" error. When I check the value of the TopMargin property before I try to set it, it's got a value of 9999999.0. And then when I try to set the value to 43.2 points (.6 inches), which is well withing the allowable range, I get the error. The code looks something like: ' wvhWndWord is defined as Word.Application, WithEvents With wvhWndWord .Visible = True .WindowState = Word.WdWindowState.wdWindowStateMaximize ' wvnDocNo is defined as Word.Document wvnDocNo = .Documents.Open(wvDocName, , True, True) With wvnDocNo.PageSetup .TopMargin = .Application.InchesToPoints(0.6) .... As soon as I try to set .TopMargin, I get the error. I have made sure that the .Application.InchesToPoints(0.6) is working. This returns a value of 43.2. Thanks for any help you can give. Tag: How to use the system ListView to programming in VBA? Tag: 86687
  - 13
    - Format Changing in Referenced Bookmarks Hi there, I have a number of bookmarks in a template which I reference in several different areas of the document (ie, they're initially on the coversheet - at a large font - then I've referenced them in the headers and other areas of the document). When I run the template the format of the "referenced bookmarks" changes to the size of the original bookmark. The confusing part is some of them are fine (ie, they don't change and stay to the format I've set them at) but others do change. Is there something I'm doing incorrectly, a setting I'm missing, or extra code I need to put in? Using VBA in Word 2002 - I insert the bookmark [bookmark] then go to the other areas I need the text and select: Insert, Reference, Cross-reference, Bookmark, Bookmark Text. Thanks kindly for any advice Beth Tag: How to use the system ListView to programming in VBA? Tag: 86684
  - 14
    - VBA forms populate document - Keeping Focus Hi, i have developed a corporate memo template for our organisation using VBA forms to populate fields in bookmarks on a document. This works a treat except that the final document does not get focus and the user has to click in the window in order to continue typing. I have tried numerous different code samples that i have found on the net but to no avail. The cusror seems to flash once but then focus is lost. Could someone please help before my sanity is lost aswell? Tag: How to use the system ListView to programming in VBA? Tag: 86680
  - 15
    - Userform data to create form fields Hi, I want to create a template that asks multiple questions and then based on the user's answers, inserts relevant text and form fields. For example: Question: Do you require packing service? If the answer is Yes, then insert (Heading format) Packing Charges: (Form Field - Drop down) (Form Field - Text Currency) If the answer is No, insert nothing Question: Do you require additional services? If the user answers Yes then insert (Heading Format) Additional Service Charges: If the answer is No, insert nothing Question: Do you require car transport? If user answers Yes then insert (under additional services heading from above) (Form field - Dropdown) (Form field - Text Currency) If No, insert nothing Etc. there are a lot more options but I can create them later - if I can even achieve this! Tag: How to use the system ListView to programming in VBA? Tag: 86674
  - 16
    - Help with a Macro for Word The macro is very simple. I want to find the font size other then default and insert a tag before and after the text to list the font size. I am running into two issues First, getting the default font size for the document. Second, I think I broke my current script and I can't figure out where it went wrong LOL. Any help would be appreciated. -TIA- [code] Private Sub ConvertSize() Dim fSize& If convertFontSize = False Then Exit Sub If DefaultFontSize = 12 Then DefaultFontSize = 12 fSize = 12 For fSize = 1 To 50 If fSize > DefaultFontSize + 1 Or fSize < DefaultFontSize - 1 Then 'at least two points difference ActiveDocument.Select With Selection.Find .ClearFormatting .Font.Size = fSize .Text = "" .Format = True .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False .Forward = True .Wrap = wdFindContinue Do While .Execute With Selection If Len(.Text) > 1 And InStr(1, .Text, vbCr) Then ' Just process the chunk before any newline characters ' We'll pick-up the rest with the next search .Collapse .MoveEndUntil vbCr End If ' Don't bother to markup newline characters (prevents a loop, as well) If Not .Text = vbCr Then If fSize = DefaultFontSize Then .InsertBefore "[size=" & fSize & "]" .InsertAfter "[/size]" End If End If If useDefaultStyle Then .Style = ActiveDocument.Styles(DefaultStyleName) 'must be localized to your language, see CONST on top .Font.Size = DefaultFontSize '.Collapse wdCollapseEnd '.MoveLeft , 4, True 'ClearFormatting End With Loop End With End If Next End Sub [/code] Tag: How to use the system ListView to programming in VBA? Tag: 86671
  - 17
    - Bookmarks and reference fields again! Can anyone please help me with this code. I cannot get the text that is placed in the reference field to take on the default font of the paragraph where it is placed via the reference field. It keeps showing up as the font of the bookmark text. Dim bBkm As String Dim bText As String Dim bIndex As Long Dim oRng As Range For bIndex = 1 To 8 bBkm = Choose(bIndex, "ReportDate", "Addressee", "AttentionLine", "ReferringPhysician", _ "PatientName", "SSN", "ReportTitle", "County") bText = Choose(bIndex, ReportDate3, Addressee, AttentionLine, RequestForConsultation, _ PatientName, SSN, ReportTitle, County) If ActiveDocument.Bookmarks.Exists(bBkm) = False Then GoTo NextBkm End If Set oRng = ActiveDocument.Bookmarks(bBkm).Range oRng.Text = bText Select Case bIndex Case 2 'Addressee oRng.Font.Bold = True Case 3 'AttentionLine If ReportType = "SSI" = True Then oRng.Font.AllCaps = True Else: oRng.Font.Bold = True End If Case 4 'RequestForConsultation oRng.Font.Bold = True Case 5 'PatientName If ReportType = "SSI" Then oRng.Font.Bold = False Else: oRng.Font.AllCaps = True oRng.Font.Bold = True End If Case 6 'SSN If ReportType = "SSI" Then oRng.Font.Bold = False oRng.Font.AllCaps = True ElseIf ReportType = "EDD" Or ReportType = "EDG" Then oRng.Font.Bold = True oRng.Font.AllCaps = True End If Case 7 'Report Title oRng.Font.Bold = True oRng.Font.AllCaps = True End Select ActiveDocument.Bookmarks.Add Name:=bBkm, Range:=oRng NextBkm: Next ActiveDocument.Fields.Update Dim oFld As Field For Each oFld In ActiveDocument.Fields oFld.Result.Style = "Default Paragraph Font" On Error Resume Next Next Much Thanks...!! -- singeredel (Julie) Tag: How to use the system ListView to programming in VBA? Tag: 86669
  - 18
    - Will macros creating new menus break with Ribbon? I've been reading a few things about the new Ribbon UI coming up. Currently, I have some macros which create new toolbar menu items using code like: Set newMenu = tlbr.Controls.Add(Type:=10) With newMenu .Caption = "Restore Toolbars" .Enabled = True With .Controls.Add(Type:=msoControlButton) .Caption = "Restore" .OnAction = "TlBarsReturn" End With End With When the Ribbon comes out, will this code be disallowed and break my macros? Ed Tag: How to use the system ListView to programming in VBA? Tag: 86667
  - 19
    - Copying modules from Excel to Word I wrote a set of macros that modify a text file and import the result into Excel. Once in Excel, more formatting changes are made, and finally I want to copy three modules into the target's VBE. These modules provide for a custom outline expansion, and the code for these works once in Excel. I am having trouble with the copying. I took my method from Chip Pearson's "Programming to the VBE" website, but I've noticed that Word seems to use the VBE differently than Excel. I either get a message that says "Subscript out of Range" or it fails to copy the modules completely. Here is the code: Sub addCollapse(xlApp) Dim fname As String Dim fso Dim VBCodeMod As CodeModule Dim VBComp As VBComponent Dim LineNum As Long Application.Activate ' Search for "collapse" modules and transfer code to target For Each Module In Application.VBE.ActiveVBProject.VBComponents If Module.Type = 1 And (Module.Name = "copy_collapse_functions" Or _ Module.Name = "copy_collapse_main" Or _ Module.Name = "copy_collapse_hide") Then ' Export module to text file fname = ActiveDocument.Path & "\" & Module.Name & ".txt" Module.Export pthVisual & Module.Name & ".txt" Module.Export fname ' Import module into spreadsheet xlApp.ActiveWorkbook.VBProject.VBComponents.import fname ' Delete text file Set fso = CreateObject("scripting.filesystemobject") fso.deletefile fname End If Next ' Rename modules xlApp.ActiveWorkbook.VBProject.VBComponents("copy_collapse_main").Name = "collapse_main" xlApp.ActiveWorkbook.VBProject.VBComponents("copy_collapse_functions").Name = "collapse_functions" xlApp.ActiveWorkbook.VBProject.VBComponents("copy_collapse_hide").Name = "collapse_hide" xlApp.Application.Run "collapse" End Function In the code, xlApp refers to the Excel Application. If anyone could help me find the error or ambiguity, please let me know. Thank you Pflugs Tag: How to use the system ListView to programming in VBA? Tag: 86659
  - 20
    - How do i setup a print command button on a template? I want to setup a print command button on a template that will allow me to print to a certain network printer? For example we have a template called green sheet and a printer called wcpy_green I want to know if there is a way to have a command button that will print to wcpy_green or maybe even set it up so that it will only print to that printer. Tag: How to use the system ListView to programming in VBA? Tag: 86658
  - 21
    - Word VBA: PC and Mac differences? compatibility? I have some code and userforms developed in PC Word97 (for compatibility purposes back to users still using that version). I have a Mac user who has asked for a copy of my workbook; is there a list anywhere of what does (and does not) work across platforms for different versions of Word, so I can check to see if there is likely to be any issues with my code on the Mac platform? I'd rather be aware and warn a potential user of problems before they occur... Thanks! Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. Tag: How to use the system ListView to programming in VBA? Tag: 86657
  - 22
    - Format MACROBUTTON field text? I am adding a MACROBUTTON field using ActiveDocument.Fields.Add Range:=rng, _ Type:=wdFieldEmpty, Text:= _ "MACROBUTTON LeftOffHere ""Doubleclick HERE to go to last edit"" ", _ PreserveFormatting:=False Can I format the visible text (Doubleclick HERE to go to last edit)? I would like to highlight the text red, or at least turn the font color red. So far, though, I've been unable to accomplish this using Range.Font.HighlightColorIndex or Range.Font.ColorIndex. Am I trying to do what isn't possible? Ed Tag: How to use the system ListView to programming in VBA? Tag: 86655
  - 23
    - Word To Jpeg/Png --I have also posted this post on Office forum so please excuse me for that Hi! I have a problem. I need to convert word doc pages to Jpegs and I am facing a very starnge issue. I have tried an approach that fails on windows server 2K3 where as works fine on XP systems. Since I need to deploy my app on the server I am facing this issue. I have tried the following code in C# as well as VB6 and VBA. It fails in all 3 on the win2K3 server where as works perfectly in WinXP. Dim oPageStart As Word.Range oPageStart.Sections(1).Range.Bookmarks("\page").Range.Select Clipboard.Clear oPageStart.Sections(1).Range.Bookmarks("\page").Range.Copy '(Both The option s Copy as well as Copy ASPicture) oPageStart.Sections(1).Range.Bookmarks("\page").Range.CopyAsPicture SavePicture Clipboard.GetData(), ImgName 'This gives an error "Invalid Property Value" in Win2K3 Is there something that I am missing that is required for Win2K3 Does anyone have a better or a different solution. Please help. -- Regards, Abhishek Tag: How to use the system ListView to programming in VBA? Tag: 86652
  - 24
    - how do I remove microsoft word from default to open web pages Tag: How to use the system ListView to programming in VBA? Tag: 86650
  - 25
    - Dictionary Objects - Looking up an item creates an item? Using Scripting dictionary in Word, it seems that a retrieval of a non-existant item creates an item. In the code below the persons.count = 1 after the failed retrieval. How would one lookup an item and add one if not in the dictionary? Thanks. Sub dictionarytest() Dim c(2) Dim persons As Object Set persons = CreateObject("Scripting.Dictionary") Dim keys As Variant, dcount As Long On Error Resume Next ' This statement seems to add the item "foo" to the dictionary - why? dcount = persons("foo")(2) On Error GoTo 0 dcount = persons.Count MsgBox ("count1 = " & dcount) c(1) = "foo" dcount = persons.Count + 1 c(2) = dcount ' and it bombs here because "foo" is already in the dictionary persons.Add "foo", c End Sub Tag: How to use the system ListView to programming in VBA? Tag: 86645
- Next
  - 1
    - can't open a url by using document.open Hello, I use to save html pages in to text format by open it as: a) Documents.Open FileName:=http://teletekst.nos.nl/tekst/101-01.html followed by: b) Documents(1).SaveAs "D:\tmp.txt", FileFormat:=wdFormatText But the program does not respond anymore after a) hope somebody can help me out regards, Gerie Tag: How to use the system ListView to programming in VBA? Tag: 86644
  - 2
    - Limiting the Print Button I work in a centre for people with disabilities and we have a problem with students pressing the print button many multiples of times when they go to do a print. I did post a message a while back asking for any VBA that might be able to limit printing, the only suggestion I got was to replace the print button with the print dialog. This didn't really work and only slowed it down a bit :) I've been doing a bit of a search and come up with the following: Public Sub FilePrint() With Dialogs(wdDialogFilePrint) If .Display = -1 Then If .NumCopies > 1 Then MsgBox "You cannot print more than 1 copy." Else .Execute End If End If End With End Sub Unfortunately this only allows limiting of the number of copies :( What I really need is some way of making the print button only work once in say, 30 seconds or so...... enough time for the students to see that something is coming out of the printer. Is there any way in VBA that I could put a timer of sorts on the print button ? Cheers, Tag: How to use the system ListView to programming in VBA? Tag: 86641
  - 3
    - Tools menu is gone! In my Word 2000 I suddenly discover that the menu Tools is gone. How can I get it back? /BosseH Tag: How to use the system ListView to programming in VBA? Tag: 86639
  - 4
    - Print view should be in the View tab on the ribbon (office beta) Instead of (or on top of) File > Print > Print preview, in View > Print Preview. 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=f9f1f145-178c-4c6a-904e-be1c0e5f5630&dg=microsoft.public.word.vba.general Tag: How to use the system ListView to programming in VBA? Tag: 86638
  - 5
    - Scroll list or combo box with mouse Is it possible to scroll a User Form list box or a combo box with the scroller wheel on a standard mouse? If so, how? Thanks. Ed in Virginia Tag: How to use the system ListView to programming in VBA? Tag: 86635
  - 6
    - Bookmark Selection Question I have nested bookmarks in a document (for example [xxxxx[yyyyyy]xxxxx]). Is it possible using Word VBA to identify if the cursor is in the "yyyyy" bookmark instead of the "xxxxx" bookmark? When I use "Selection.Bookmarks(1).Select", I always get the larger of the two bookmarks returned. Many thanks. Tag: How to use the system ListView to programming in VBA? Tag: 86627
  - 7
    - Control Box Conditional Formatting --cross post from 'other' Word Programming board--this board looks to have more action. Word 11 I have a check box (control) in my document that I would like it to be bold when checked and regular when clear. I believe this can be done with VBA but beyond recording/editing Macros, I don't know how to write the code. Any information would be greatly appreciated. Please advise if more information is needed. TIA Tanya Tag: How to use the system ListView to programming in VBA? Tag: 86621
  - 8
    - Mail Merging I'm trying to merge data from an Access query. The problem I have is that my query has to display by grouping. I have a table query that shows over 200 company assigned cell phones where an employee is shown to have more than one. My query groups the information in a report that shows the employees FirstName, LastName, and the numbers each has under PhoneNum. I can trim their first names and middle initials and concatenate with the @company.com domain for their email addresses. I want to send out an individualized email to each asking them to confirm service: Dear <<FirstName>>, You have the following phone numbers assigned to you: <<PhoneNum>> this is where they are grouped from two to seven per employee then I want to have each sent to their individual email address. The mail merge wizard doesn't allow for grouping as an option, so it would only give me one line per record, duplicating each name with each phone assigned as a separate record. I'm looking to see if there's a way to control this programmatically. Can anyone help me? Tag: How to use the system ListView to programming in VBA? Tag: 86608
  - 9
    - Bookmarks and respective reference fields I have set up a bookmark called "ReferringPhysician" in a document as well as a reference field {ReferringPhysician} to repeat the bookmark text at another location in the document. The fields are updating fine. Since I have a variety of different bookmarks and reference fields, I need to know how to reference a specific reference field so that the particular field and some surrounding punctuation can be deleted from the document if the variable for the ReferringPhysician bookmark is blank or empty of text. I think I have figured out how to format the text that appears in the various fields to take on the default paragraph font, as follows: Dim oFld As Field For Each oFld In ActiveDocument.Fields oFld.Result.Style = "Default Paragraph Font" On Error Resume Next Next Is there any way to include in this code to delete the { ReferringPhysician } field as well as the preceding comma and space and trailing comma. The text would appear as follows in the template itself: "Thank you, { ReferringPhysician}, for participating..." If there is no variable information for the bookmark "ReferringPhysician", I want the text in the document to look as follows: "Thank you for participating..." Thanks for any help! -- singeredel (Julie) Tag: How to use the system ListView to programming in VBA? Tag: 86606
  - 10
    - VBA need to minimize Excel from UserForm I have a VBA application that displays a UserForm that has a Minimize button on it. When I click it, the UserForm minimizes as it should but the Excel workbook that contains the UserForm does not. I can not even click on the minimize button on the workbook because it is grayed out (I think because the UserForm has focus). How do I make the Excel workbook that contains the UserForm that was launched also minimize when I minimize the UserForm? Thanks, Gary Tag: How to use the system ListView to programming in VBA? Tag: 86604
  - 11
    - reading picture metafile (I apologize if this is a second post of the same question.) I would like to retrieve the metafile of a picture. More specifically I would like the metafile stored with an embedded OLE object (rather than after converting it to a picture). If Word stores the information internally, then shouldn't it be accessible? If so, how? Tag: How to use the system ListView to programming in VBA? Tag: 86601
  - 12
    - Word goes "non-responsive" during macro run I have a macro which, literally, every other time I run it, it makes the VB editor and Word hang and go non-responsive. I would understand if it were this unpredictable with different macros or target files or even pieces of text that I work on; but it puzzles me since it's always the same circumstances that produce varying results. Any ideas on how to prevent this? -- Bryan Tag: How to use the system ListView to programming in VBA? Tag: 86598
  - 13
    - WdBuiltinStyle Enumeration Hi, I noticed that "myPar.Style = wdStyleHeading1" (where myPar is a Paragraph) is never true (you need to use the actual style name). Which property of the Style object returns a value of the WdBuiltinStyle Enumeration? Thanks! Raph Tag: How to use the system ListView to programming in VBA? Tag: 86596
  - 14
    - Range contains full table rows? Hello, What's the best way to find whether a range (or selection) contains only = table rows (and possibly, non-table text)? Thanks, Alex. --=20 Address email to user "response" at domain "alexoren" with suffix "com" Tag: How to use the system ListView to programming in VBA? Tag: 86592
  - 15
    - Opening a new document from a template I have a tempate with some vba code that fills in teh document from a database. The code works by writing to ActiveDocument I want to modify this so that it can read in a text file of values and create one document for each row. Within the code How do I add a new document and then make it the active document sio it is written to?. I have tried using this but it just writes to the same document each time. Thanks Application.Documents.Add (ActiveDocument.Path & "/" & ActiveDocument.Name) Application.Documents(Application.Documents.Count).Activate Tag: How to use the system ListView to programming in VBA? Tag: 86587
  - 16
    - FILE OPEN DIALOG - CHANGE VIEW I posted earlier posts regarding this and couldn't find a solution. I have since just about lost my head but never gave up in trying to solve my problem. I thought I should post this solution on how to change your file open dialog to change your view to the details view using the SendKeys commands. Thanx to everyone out there advising about the sendkeys although I had to figure out which keys to be pressed. There were many similar questions and never a suitable solution. Hope this helps everyone. With Dialogs(wdDialogFileOpen) SendKeys "%(L)" SendKeys "{Left}" SendKeys "(D)" .Show End With Tag: How to use the system ListView to programming in VBA? Tag: 86572
  - 17
    - Find last cell in Word Table Hi, I would like to write a macro that finds that last cell in a table and inserts a new row (which I have saved as AutoText). Thanks Tag: How to use the system ListView to programming in VBA? Tag: 86565
  - 18
    - Restart Numbering Macro Hi there, I have a number of restart numbering macros that I record and I find when these are run on other machines, I get a run time error. The numbering has a style associated with it and so should pick up the correct Outline level associated with the style. I think I have something missng from my code. Any suggestions welcome. Tag: How to use the system ListView to programming in VBA? Tag: 86564
  - 19
    - macro help - convert copied text to new filename The code for a simple word macro (built using macro recorder) is below. I use it inside of Outlook to save messages with a filename that is extracted from a specific line of expected text. I'm close, but I am failing miserably in the simple task of converting the copied text I have cleaned (brute force method), selected and copied into a new filename! The offending line, of course, is: sNewFileName = Selection.Paste and I can't fix it!!... bsteiner Sub test() ' ' test Macro ' Macro recorded 6/1/2006 ' Selection.Find.ClearFormatting With Selection.Find .Text = "item" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Selection.MoveRight Unit:=wdWord, Count:=1 Selection.MoveUp Unit:=wdLine, Count:=1, Extend:=wdExtend Selection.MoveDown Unit:=wdLine, Count:=1, Extend:=wdExtend Selection.MoveRight Unit:=wdCharacter, Count:=25, Extend:=wdExtend Selection.Copy Selection.MoveDown Unit:=wdScreen, Count:=1 Selection.Paste Selection.TypeParagraph ActiveDocument.SaveAs FileName:="Matrix System plus spares.doc", _ FileFormat:=wdFormatDocument, LockComments:=False, Password:="", _ AddToRecentFiles:=True, WritePassword:="", ReadOnlyRecommended:=False, _ EmbedTrueTypeFonts:=False, SaveNativePictureFormat:=False, SaveFormsData _ :=False, SaveAsAOCELetter:=False End Sub Sub MRSave() ' ' MRSave Macro ' Macro recorded 6/1/2006 by US Army ' Dim sNewFileName As String Dim sOldFileName As String Selection.MoveUp Unit:=wdScreen, Count:=3 Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "/" .Replacement.Text = "_" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll With Selection.Find .Text = ":" .Replacement.Text = "_" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll With Selection.Find .Text = "\" .Replacement.Text = "_" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll Selection.Find.ClearFormatting With Selection.Find .Text = "item" .Replacement.Text = "_" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Selection.MoveRight Unit:=wdWord, Count:=2 Selection.MoveRight Unit:=wdCharacter, Count:=30, Extend:=wdExtend Selection.Copy sNewFileName = Selection.Paste ChangeFileOpenDirectory _ "S:\Updates\" sOldFileName = ActiveDocument.FullName ActiveDocument.SaveAs FileName:=sNewFileName, _ FileFormat:=wdFormatDocument, LockComments:=False, Password:="", _ AddToRecentFiles:=True, WritePassword:="", ReadOnlyRecommended:=False, _ EmbedTrueTypeFonts:=False, SaveNativePictureFormat:=False, SaveFormsData _ :=False, SaveAsAOCELetter:=False ActiveDocument.Close End Sub Tag: How to use the system ListView to programming in VBA? Tag: 86563
  - 20
    - add lines to page/paper????? I want to add lines to form I am trying to build/make. I want "it" to me like this,,,, the tablets that you buy and have numbers (1 to 25 or so on them) But in my case I would like to make a form/file/paper, I don't know what to call it,,,,,, that will be like this............ A. B. C. D. but inbetween the letters will be devided by lines. How do I do that????????????? thanks in advance, cl Tag: How to use the system ListView to programming in VBA? Tag: 86561
  - 21
    - Previewing/Modifying Pictures in VBA Is there a link somewhere on how to possibly use windows picture and fax viewer on a VBA Form. I need to view a picture, and possibly rotate it before i put it into a word document. Image Boxes are fine and all, but it just seems like too much work. thanks, -- Jeff "Spike" Zapinski Faurecia Automotive Seating - Project Engineer Tag: How to use the system ListView to programming in VBA? Tag: 86560
  - 22
    - How to Create a Userform Hi: Recently, I've been creating some forms in Word and would like to add some automation to them. I've seen how some Userforms work and believe that would be helpful for my users to have a dialog box appear, they complete the fields and sections of the the form is automatically populated with their response. However, I don't know any VBA or where to even start in creating the userform. I tried to do some searching on the web for tutorials but I still had problems understanding the steps. I found that some tutorials jumped right into coding and I had difficulty understanding the different code commands/values. Can anyone provide any links to free online tutorials or books that would help me in learning? Thanks. Tag: How to use the system ListView to programming in VBA? Tag: 86555
  - 23
    - auto insert a date that is two weeks away I'm working on a letter that will generally be used as a form letter. In the letter we refrence a date that is always two weeks from the date that the letter is written. Is there a way to automatically insert this date? Thanks in advance, Tag: How to use the system ListView to programming in VBA? Tag: 86552
  - 24
    - for loop not working Hello, I have the following subroutine that breaks right after it reaches the last value of "i" which is 102. I've added watches for every variable in the routine and all the variables are there. The actual For Loop is working fine, and the bookmark exists but when I put in a message box, it won't even go to the message box. I have an identical For Loop higher in the code that works fine. I'm totally flummoxed by this. Thank you for any help you can provide. _________________________________ Public Sub AddBarAdmissionsListInfo(varBookmark As String, varRecords As Long) Dim i As Integer Dim strListInformation As String Dim rng As Range Set rng = ActiveDocument.Bookmarks(varBookmark).Range For i = 0 To varRecords If frmAttyBio.ListBarAdmissions.Selected(i) = True Then strListInformation = _ strListInformation & frmAttyBio.ListBarAdmissions.list(i) strListInformation = strListInformation & " | " End If Next i MsgBox "Out of ForLoop" rng.Text = Left(strListInformation, Len(strListInformation) - 2) Tag: How to use the system ListView to programming in VBA? Tag: 86548
  - 25
    - Printing Current Page problem Please can anyone tell me why the below does not work. Many thanks Private Sub CBOXCURRENTPLAIN_Click() If CBOXCURRENTPLAIN.Value = True Then With Dialogs(wdDialogFilePrintSetup) .Printer = "\\rother\CanonMF13" .DoNotSetAsSysDefault = True .Execute ActiveDocument.PrintOut Range:=wdPrintCurrentPage End With End If End Sub Tag: How to use the system ListView to programming in VBA? Tag: 86544

I've found the function of system's ListView control
(see,main view of Explorer on the bottom right) is
better than the ListBox in VBA,and want to use it
to VBA programming.How to use it?
--------------------------------------------------
An

Top