Scroll list or combo box with mouse

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - 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: Scroll list or combo box with mouse Tag: 86627
  - 2
    - 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: Scroll list or combo box with mouse Tag: 86621
  - 3
    - 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: Scroll list or combo box with mouse Tag: 86608
  - 4
    - 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: Scroll list or combo box with mouse Tag: 86606
  - 5
    - 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: Scroll list or combo box with mouse Tag: 86604
  - 6
    - 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: Scroll list or combo box with mouse Tag: 86601
  - 7
    - 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: Scroll list or combo box with mouse Tag: 86598
  - 8
    - 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: Scroll list or combo box with mouse Tag: 86596
  - 9
    - 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: Scroll list or combo box with mouse Tag: 86592
  - 10
    - 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: Scroll list or combo box with mouse Tag: 86587
  - 11
    - 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: Scroll list or combo box with mouse Tag: 86572
  - 12
    - 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: Scroll list or combo box with mouse Tag: 86565
  - 13
    - 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: Scroll list or combo box with mouse Tag: 86564
  - 14
    - 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: Scroll list or combo box with mouse Tag: 86563
  - 15
    - 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: Scroll list or combo box with mouse Tag: 86561
  - 16
    - 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: Scroll list or combo box with mouse Tag: 86560
  - 17
    - 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: Scroll list or combo box with mouse Tag: 86555
  - 18
    - 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: Scroll list or combo box with mouse Tag: 86552
  - 19
    - 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: Scroll list or combo box with mouse Tag: 86548
  - 20
    - 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: Scroll list or combo box with mouse Tag: 86544
  - 21
    - Right align column does not work from vb I use vb6, win2000, and word2003. I am creating a word document in vb. After I write the data to the document I put it into a table: oRange.start = WordDoc.Range.start oRange.ConvertToTable numcolumns:=IIf(choice, 4, 1), AutoFit:=True I want to have the second column right-aligned. This code does not work: tbl.Columns(2).Select Selection.ParagraphFormat.Alignment = wdAlignParagraphRight It works as a macro in Word on the final document, but not from vb. This code works, but is slow: Dim cl As Cell For Each cl In tbl.Columns(2).Cells cl.Range.ParagraphFormat.Alignment = wdAlignParagraphRight Next cl Regards, Jan Nordgreen Tag: Scroll list or combo box with mouse Tag: 86543
  - 22
    - document active but not really? I'm using C#. I've created a new document and saved it with SaveAs. Now I want to re-open the same document and allow the user to edit it, so I do Open and then Activate. Then Word's in this odd state with the correct filename in the title bar and the menus appear as if a file is open & active, but the document isn't showing! If I go to the Window menu, the document's there (the only one there) and it's checked, but if I click on it, Word's document area stays empty (blue/grey). The code excerpt is below. Thanks for any ideas! Matt oWordDoc.SaveAs(ref WordFileName, ref Missing, ref Missing, ref Missing, ref oTrue, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing); // re-open it for user to continue editing oWordDoc = oWordApp.Documents.Open(ref WordFileName, ref Missing, ref Missing, ref oTrue, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing, ref oTrue, ref Missing, ref Missing, ref Missing, ref Missing); oWordDoc.Activate(); Tag: Scroll list or combo box with mouse Tag: 86540
  - 23
    - Macro to Save Multiple Word Documents with Different File Names Hi, I have to process some 5,000 documents, and need to change their filename at the same time. All of the documents have a name in the header in the format: Firstname Middlename (where it applies) Surname I need to save the documents as: Surname, Firstname Middlename.doc I know how to change the directory they're saved to, and I've managed to set up the macro to run on all files in a given folder. This is the only thing that's stopping me from being able to run the macro. I don't know what terms to actually search for to be able to find help on this, so I'm trying here. I've tried to create a Function that will let me create the filename, and then use that as the Save As option, but I can't get it to work, as I can't reference the Function in the SaveAs Filename:=" " It will only save as what I put in the " "... I've tried using brackets, and nothing, but no luck. Any help would be greatly appreciated, even if it's just to tell me what terms I need to search for on the web, or a website that you think could help. Many thanks, Wafty Tag: Scroll list or combo box with mouse Tag: 86533
  - 24
    - Calender views Hi I wonder if there anyone who know how to change the calender view? I want to show one or more column that i have created. Gunnar Tag: Scroll list or combo box with mouse Tag: 86526
  - 25
    - View Zoom is killing me! I have this application, see, and when a user finishes editing a document, I want to display all of the pages of the document to them and put up a simple yes/no dialog. (true, the pages are potentially very small and unreadable, but the idea is just to give the user a general reassurance that, at a quick glance, they have not put an errant page break in and left a blank page or something) If they answer no to the dialog, I want to reset the view's zoom back to whatever it was previously, which I already stored before I changed the view's zoom to x pages by y columns.. If they answer yes, I want to set the zoom to page width so anyone else outside of our company who opens the document won't get some funky zoom by default. So, I can show all of the pages by setting .PageColumns and .PageRows, and I can restore the previous view by setting .Percentage to the value that was previously captured.... BUT, this causes all kinds of issues with the zoom in Word because it is seeming to "remember" the many-pages view, and when the user performs various actions, such as maximizing/restoring Word, sometimes switching to another application and back to Word, etc., Word will set the zoom back to the multiple-page view. Here is bare-bones macro that exhibits the problem. Interestingly, this was basically recorded using the macro recorder, yet doing the actions interactively as a user via the View|Zoom dialog works fine, but running the recorded code does not work well at all (per the above gripe). Public Sub Macro1() With ActiveWindow.ActivePane.View.Zoom .PageColumns = 2 .PageRows = 2 End With ActiveWindow.ActivePane.View.Zoom.Percentage = 100 End Sub If you run this macro, then maximize/restore Word, for example, you will be put back into a view that shows 4 pages (2 x 2). Word is reverting back to the .PageColumns and .PageRows setting. Any ideas? I've verified this on Word2000, WordXP, and Word2003. I've tried using the Dialogs(wdDialogViewZoom) dialog object but can't seem to get that to work (I'm not trying to display the dialog, I'm trying to set the values the same as I did interactively and then call .Execute on the dialog object). Any help would be greatly, greatly appreciated. Tag: Scroll list or combo box with mouse Tag: 86524
- Next
  - 1
    - Editing an Embedded Excel Worksheet This one has perplexed me ... I'm automating Word from C# under VS .Net 2005. Everything about automating Word has been straightforward. I have an embedded Excel document (not linked) in the Word document that I'd like to change a single cell on. The cell is on the first and only worksheet. Does anyone have any pointers? I cannot seem to find any documention. Tag: Scroll list or combo box with mouse Tag: 86521
  - 2
    - InsertFile() formatting problem (possibly a bug ?) Hi! I need to combine a few documents together in such a way that each document retains its formatting in the resulting document. I tried to put Continuous Breaks at the start and end of each document as described here: http://www.word.mvps.org/FAQs/Formatting/WorkWithSections.htm Unfortunately, that technique does not seem to work. Formatting changes anyway. To illustrate my point I created 3 documents AAA.doc, BBB.doc and CCC.doc that can be downloaded from here: http://www.freefileupload.net/file.php?file=files/310506/1149117631/FILES.zip or here: http://fileshare.variousstuff.net/0000000492/ I need to insert BBB.doc into AAA.doc so the resulting document has the same formatting as CCC.doc (formatting of AAA and BBB was preserved). No matter what Iâ??ve done to AAA.doc and BBB.doc, I could not make it look like CCC.doc. I am truly lost. Is this a bug I need to report to Microsoft? What can I do to preserve formatting with InsertFile()? Infinite thanks in advance, --Michael Tag: Scroll list or combo box with mouse Tag: 86514
  - 3
    - protection with text form field I am using a table in word document and added a text form field in the second row. I have inserted a REF field for the same in some other table column. when i use 'protect form' button in forms toolbar, then after inserting any value in text form field, when i do tab, it reflects in REF field. it works fine. but when i apply protection from Tools menu. then after doing Tab, it is not reflecting changed value in REf field. even, it stops calling any macros associated with text form field. I want to do this through coding. can anyone please suggest me what code runs in background for protection when i click on 'Protect Form' button. Tag: Scroll list or combo box with mouse Tag: 86513
  - 4
    - Export from Word Form to Excel Spreadsheet Hi: I tried reviewing previous postings on exporting form fields from Word to Excel and as I'm new to programming, I had some difficulty in following responses to the postings. So I thought I would start fresh and post a new question. If I were to create a form in MS Word 2003 (with text fields, number fields, checkboxes and dropdowns), what are the steps should I take so that when I send the form to someone and they complete the form (do a "Save As" and send the completed form back to me), I can take the information from the completed form and import the info into an Excel spreadsheet? Is there a tutorial that someone could perhaps suggest? Any help would be greatly appreciated. Thanks! Tag: Scroll list or combo box with mouse Tag: 86512
  - 5
    - where is Auto Format? Auto Format in Word 2003. You would type common words in auto format so that when you typed the first 2 or 3 letters you would press enter for that word to be automatically inserted.. IE Gerald, Ger (Gerald would appear & Enter would make Gerald). I have searched Word & Outlook & no Auto format. As I type my E-Mail johndoe@hotmail.com, all I would type is joh & I have the option of hitting enter for my E-Mail address to fill in. Gerald H Levine Tag: Scroll list or combo box with mouse Tag: 86511
  - 6
    - Autorun Word Macro Hi I have a normal word document that has a macro in it that provides a sequential number each time I open the document: Sub AutoNew() Order = System.PrivateProfileString("C:\Settings.Txt", _ "MacroSettings", "Order") If Order = "" Then Order = 1 Else Order = Order + 1 End If System.PrivateProfileString("C:\Settings.txt", "MacroSettings", _ "Order") = Order ActiveDocument.Bookmarks("Order").Range.InsertBefore Format(Order, "00#") ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#") End Sub This works perfectly ok when I open the document and the select Tools, Macro, Run. What I would like to do is place this document on a server (so that it can be accessed by an number of users) but have it so that when anyone opens it, the macro will run automatically. (Without having to go to Tools, Macro, Run) Can anyone help me? Thanks John Tag: Scroll list or combo box with mouse Tag: 86508
  - 7
    - Word 12 Beta Is there a chat room/discussion group for Word 12 Beta? I am new to these chat rooms and could not find where to go. -- Butch Cassidy Tag: Scroll list or combo box with mouse Tag: 86506
  - 8
    - Eliminate extra pulldown menu entries for acrobat pdf & comments? I keep getting multiple pulldown menu entires for Acrobat PDF & Acrobat Comments. It is only the last set that is usable but nonetheless I currently have 10 sets of these menu options. How do I stop this from growing? Tag: Scroll list or combo box with mouse Tag: 86503
  - 9
    - green underlining during spelling check Hi, Does anyone know how to find the green wavy lines under incorrect grammar or spelling? Thanks for any tips, Regards, Gordon Filby Tag: Scroll list or combo box with mouse Tag: 86498
  - 10
    - Can't repeat nor redo VBA action The following applies to Word 2000, XP and 2003: I have written some VBA macros. When the users are using them, both the "Repeat" command in the "Edit" menu and the "Redo" button in the standard toolbar are greyed out. The "Undo" commands are okay though. One of the macros simply applies a style to the selected text: ActiveWindow.Selection.Style = ActiveDocument.Styles(sStyle) (sStyle being the tag of the action control clicked by the user) The users would like to repeat that command by using [ctrl]+[y] or by using [F4] instead of having to navigate to the action control with the mouse. How can I make the repeat/redo commands accessible for VBA macros, in particular the above command? Thanks in advance for any help! Sheila Tag: Scroll list or combo box with mouse Tag: 86495
  - 11
    - "file not found" when attempting to run macro from list While attempting to run any macro from the list that Word displays, I receive an error message of "file not found." This occurred right after running a macro successfully. The list of macros is surely there, as is Normal.dot, I believe with the same size it was before this started happening. As possible remedies (which didn't work), I ran the Office repair utility and set Windows back to the last restore point. I copy and paste the text of my macro modules to a file but I had done a lot of updating lately and hadn't done this backup procedure recently, and it would be really nice if I could figure this out and recover whatever it is that's missing. I did notice Norton running a check on Normal.dot before it happened so I guess it's possible that a virus got past Norton into the file. I have my macro security set on high (second from the top) and it says there is a viurs scanner installed, though I don't do all the updates like I should. Any ideas would be greatly appreciated. -- Bryan Tag: Scroll list or combo box with mouse Tag: 86494
  - 12
    - Customize Ribbon UI Posting here as I lack knowledge of a better place and in hopes a developer type is lurking around. I am looking for a step by step procedure (that actually works) for making a simple customization to the Word2007 Ribbon UI. All I want to do is add my own tab and add a button to that tab that will fire a macro. I have read and reread the article "Customizing the Office (2007) Ribbon UI for Developers Part 1 of 2 and tried the procedures listed there at least a dozen times and every time the resulting document won't open and generates and error that it is corrupted. Here is the procedure that I have tried: I opened an new file and created a macro as shown. I digitally signed the project. Sub MyMacro(ByVal control as IRibbonControl) MsgBox("Hello World") End Sub I saved the document as an Open XML Formats file that is macro-enabled and has the file name extension .docm. i.e., saved as Test.docm I created a file in Notepad with the following XML markup and saved it as customUI.xml: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="CustomTab" label="My Tab"> <group id="SimpleControls" label="My Group"> <button id="Button1" imageMso="HappyFace" size="large" label="Large Button" onAction="ThisDocument.MyMacro" /> </group> </tab> </tabs> </ribbon> </customUI> I put customUI.xml in a folder on the desktop named customUI I then add a .zip exention to Test.docm i.e., Test.docm.zip The next steps says to "double-click the file name to open it for viewing" Hmm...I don't really follow this part as double-click a file with a .zip extension doesn't really "open it for viewing." It does open the WinZip application and I am able to perform the next steps. I add the customUI folder to the Zip container. I extract the .rels file to the desktop. I open the .rels file in the text Notepad I add the following line between the last <Relationship> element and the </Relationships> element, and then save and close the file: <Relationship Id="someID" Type="http://schemas.microsoft.com/office/2006/relationships /ui/extensibility" Target="customUI/customUI.xml" /> I drag the _rels folder from the desktop to the Zip container file. Remove the .zip extension from the container file. Finally I *try* to open the macro-enabled file in Word 2007 and an error message is generated indicating the is corrupt and contains content that cannot be read. John McGhee in attempting to offer a solution stated that: 1. I had to have a name to go along with "someID." I have no idea what name to use and the code snippet is copied word for word from the example in the article. 2. docm files are already zipped so ignore the bit about adding the .zip extension and open the file in Notepad using WinZip. I don't follow what he means and unless I add the .zip extension I don't see a .rels folder in the file container. I have no idea what I could be doing wrong and hopefully someone can step me through a precedure that works or perhaps direct me to a group that may be able to assist. Thanks. Tag: Scroll list or combo box with mouse Tag: 86487
  - 13
    - Word/Excel toggle I have a macro that picks up information from Word and pastes it into Excel. It then makes a couple additional changes and queues the user to review the results with a mesg box. If everything is well, the user selects OK and the macro continues with some additional changes. If not, the user selects cancel and makes some changes manually. This is my first attempt at toggling between Word and Excel so I have a vague understanding of what's happening, but it seems that all of the actions to be performed in Excel require "oXL." before the line of code. However, when I get the message box, placing oXL. before the line of code gives me a message of "Wrong number of arguments or invalid property assignment". However without it, it goes back to Word to prompt. It runs fine after that, but I can't review the information in Excel without switching back and forth. How to do I execute the message box in Excel? oXL.Workbooks("MyWorkbook.xls").Activate oXL.Sheets("sheet1").Activate oXL.ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _ DisplayAsIcon:=False oXL.Range("c1").Select oXL.Sheets("sheet2").Activate oXL.Range("A1").Select oXL.ActiveCell.Value = MyWordName oXL.Sheets("sheet1").Activate ans = MsgBox("OK?", vbOKCancel) If ans = 2 Then End If ans = 1 Then oXL.Visible = True oXL.Workbooks("MyWorkbook.xls").Activate oXL.Sheets("sheet1").Activate oXL.Range("c1").Select oXL.ActiveCell.Value = MyWordName Tag: Scroll list or combo box with mouse Tag: 86486
  - 14
    - WordART in a protected word document Can WordART be used in a protected word document? The document has been protected to prevent users from changing the appearance of the document/template (EG. Letterhead), but now they arn't able to use any WordArt... Is there a way of allowing the users to use WordArt on a protected document? Tag: Scroll list or combo box with mouse Tag: 86484
  - 15
    - Converting the first character of a name to a capital? Good day all, I have a problem of which I hop you can help me out with. I have a userform to put in personal data of a client. The data my collegues put in will be ending up in al letter. Now, in one ocasion Someone's name is for example Guus van Waardenburg. When you write the name with the first name 'van' needs to be written in lower case, when you only write the last name, 'van' needs to be starting with a capital like this: 'Van Waardenburg', how can I put this in my code? My Code: Selection.GoTo What:=wdGoToBookmark, Name:="Aanhef" If TextBox4.Value = "" Then If Not TextBox3.Value = "" Then Selection.TypeText TextBox10 & " " & TextBox3 & " " & TextBox1 & "," Else Selection.TypeText TextBox10 & " " & TextBox1 & "," End If ElseIf Not TextBox17.Value = "" Then Selection.TypeText TextBox10 & " " & TextBox17 & " " & TextBox4 & "," Else Selection.TypeText TextBox10 & " " & TextBox4 & "," End If Can someone help? (TextBox17 = van) Tag: Scroll list or combo box with mouse Tag: 86480
  - 16
    - Error 4198 wdfieldlink and wdfielddocvariable - breaking & unlinki I have a word template which has a number of graphs (wdfieldlinks created by inserting manual Excel graph links with copy/paste special/link) and variables taken from a user form (wdfielddocvariable). I have tried a number of ways to get the newly created word doc to update the graphs and docvariables, and then break the links - but have reached a dead-end. The unlink method, if sent to the fields property of the active document, appears to stop the update method for wdfieldlinks, but not wdfielddocvariables - so I end up with a doc that has incorrect graphs - but correct, updated data. So, I have used the following code after the general update command in order to break the links / unlink the links by field type: Activedocument.fields.update For Each fldElement In .Fields Select Case fldElement.Type Case wdFieldLink fldElement.LinkFormat.BreakLink Case Else fldElement.Unlink End Select Next This gives me the error 4198. I am new to VBA programming and am learning from books (which I'm finding can be quite vague) so apologies if this is an elementary problem. Any help would be very gratefully received. jag777 Tag: Scroll list or combo box with mouse Tag: 86479
  - 17
    - Put each letter on a seperate line? Hi all, I want to get a vertical list of letters in a word document and cant figure out how to do it... Basically I want 'The quick brown fox' to end up looking like" t h e q u i c k b r o w n f o x Using ^l (Manual Line Break) can get it to do: The quick brown fox But thats not what Im after, I need each letter to be on a seperate line of its own. Its to sort a paragraph of Chinese or Japanese text so each character is on a seperate line. The list will then be copied and pasted to an excel worksheet so I dont know if I can bypass word altogether and do it all in excel. I'd really appreciate any help on this, it's driving me crazy! Thanks in advance :>) Tag: Scroll list or combo box with mouse Tag: 86476
  - 18
    - Text in Help Hi, When I use Help, the symbols above, for example Examples, are just empty buttons. It wonâ??t help to repair Office XP. I get the same error if I open the file FM20.CHM directly. Any hint will be very much appreciated. / Ulf Tag: Scroll list or combo box with mouse Tag: 86474
  - 19
    - Word 2003 Saving template Hello all, When I open a template in Word 2003 and I want to save it always gives a warning that autext entries will not be saved. The only way is to use Save as... any suggestions? Tag: Scroll list or combo box with mouse Tag: 86473
  - 20
    - Document length and print options I'm setting up a macro for form printing and I need help with the final details. 1. How would you go about determining a document's length and default the auto print to exclude the last page. 2.Then giving the user the option (via InputBox) for including the last page. Thanks in advance for any help! -ithaca Tag: Scroll list or combo box with mouse Tag: 86470
  - 21
    - word i install word on my desktop which no longer works so now i'm trying to install it on my laptop but when i put in the product key it says the key is not invalid Tag: Scroll list or combo box with mouse Tag: 86466
  - 22
    - Save changes to Document 1? Help - I can't get rid of this question. Using an AutoExec module, there is a subroutine to ensure that the Normal style has correct font and font size as per our company standards. However, this gives rise to the 'Save changes to Document 1?' question on exit from Word - even when changes are not made. The "ActiveDocument.AttachedTemplate.Saved = True" code was my attempt to get rid of the pesky message! Sub SetNormalStyle() If (ActiveDocument.Styles(wdStyleNormal).Font.Size = 11 And _ ActiveDocument.Styles(wdStyleNormal).Font.Name = "Arial") Then GoTo EndLabel With ActiveDocument.Styles(wdStyleNormal) .AutomaticallyUpdate = False .BaseStyle = "" .NextParagraphStyle = "Normal" End With With ActiveDocument.Styles(wdStyleNormal).Font .Name = "Arial" .Size = 11 End With EndLabel: ActiveDocument.AttachedTemplate.Saved = True End Sub -- Patricia D Tag: Scroll list or combo box with mouse Tag: 86461
  - 23
    - works word 'play' w/ 97word????? I like and have used word 97 but when I moved to a computer that has 'works word', and then download my , 'word 97' I get problmes. Do these two word programs not mix? I hve alot of old files that I used 97 word with, and I wold like to stay with word 97. The word 97 came with my old DELL, and the computer I am using now is a 2000 with Windows ME. Is there any way to make "them" play nice? thanks. cl. Tag: Scroll list or combo box with mouse Tag: 86459
  - 24
    - Arabic letters I load a text file, encoded, with the first two bytes being xFFFE. I type in Arabic and see the Arabic letters be changed into their correctly formed shapes as I type. These displayed characters are in the Arabic UNICODE range of xFE80 to xFEFF. But when I save the file, the characters that are saved in the file are in the UNICODE range of x0600 to x06FF. These are only the isolated forms of the Arabic characters - these are the keystrokes as delivered by the keyboard. I need to save the well-formed characters that are displayed, not the isolated forms. I need to use the well formed characters in another application. How can I do this? Why does MSWord display one thing and save another? Thanks Tag: Scroll list or combo box with mouse Tag: 86458
  - 25
    - jpg files to display on Form I have a series of radio button choices on a form. When the user selects one of these and the OK button clicked, a particular macro is run. I also want to have a corresponding jpg image to appear on the right side of the form, to give the user a visual of the style they are choosing, so they can click through the radio buttons and see the different choices. What would be the best approach for this? Thank you for your time. Tag: Scroll list or combo box with mouse Tag: 86457

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

Top

Re: Scroll list or combo box with mouse by Doug

Doug
Sat Jun 03 07:46:22 CDT 2006

I don't think so. While in Word 2007, the mouse wheel does scroll the vba
code window, which it did not do without a fix previously, it has no effect
on a list box.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Ed" <ed@pathagoras.com> wrote in message
news:cgegg.25778$ZW3.17854@dukeread04...
> 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
>

Top