how to automate drop-down forms in a word doucment

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Durability of objects I've managed to confuse myself. I open a document and set objTable to the first table in the document. Now I close the document, but I'm still able to access objTable and its contents. How can this be? I thought setting the object to some part of the document meant that the object was pointing to the same area of memory used to hold a range of the document. Am I wrong? Is it only by luck that I'm able to access that area of memory with the document closed? Is what I'm doing bad practice? Would it be better to load the table into an array? Confused, Bear Tag: how to automate drop-down forms in a word doucment Tag: 87694
  - 2
    - On Entry Macro behaviour with Mouse click (Word 2003) I have a simple protected form with Text1 DropDown1 and Text2 If the user leaves Text1 empty I want to return to Text1 if the tabs or "mouses" to DropDown1 or Text2 This is my code: Sub OnEntry() Dim oFFLd As Word.FormFields Set oFFLd = ActiveDocument.FormFields If oFFLd("Text1").Result = "" Then oFFLd("Text1").Range.Fields(1).Result.Select End If End Sub and it is set to run onentry to DropDown1 and Text2 This works as expected using the Tab key and it works if the users mouse clicks to "Text2". However, if the user mouse clicks to DropDown1 the user is given access of the field and the code isn't executed until *after* the user makes a selection. I don't want the user to be able to change the value of Dropdown1 until they have entered text in Text1. Can this be done? Tag: how to automate drop-down forms in a word doucment Tag: 87684
  - 3
    - Do not Print Header&Footer HI. I create Letter Template with some Macros. Firts page header ist diferent from primary header. both include some pictures. my problem is I need to print the letter on blank paper or preprinted paper. when I print on preprinted paper I do no want to print header&footer. 1,I try select the pictures from H&F then Selection.cut then print and followed by selection.paste. was not working properly(to many problems) 2,I try to select just the content and then print selection. ActiveDocument.content.select but H&F will be selected as well. I need help or ideas thanks Tag: how to automate drop-down forms in a word doucment Tag: 87677
  - 4
    - Add Slash-StrikeThru to Format options. StrikeThru hard to read Recommended addition to Format options: Add Slash-StrikeThru (/) to Format options. Normal StrikeThru (-) is difficult to read unless it includes several sequential character. Slash StrikeThru will stand out even if only one character in teh middle of a string is "removed" by StrikeThru. ---------------- 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=8002e431-8f3d-459e-b375-5ce8d383d4b3&dg=microsoft.public.word.vba.general Tag: how to automate drop-down forms in a word doucment Tag: 87673
  - 5
    - Call VBScript from VBA, pass variable, return result to macro? I've been looking at newsgroup posts and VBScript sites all morning, and can't seem to find a simple explanation and method for calling a script from a Word or Excel macro and passing a variable into the script, then returning the result of whatever the script does into the macro. That can mean there isn't any simple way to do this, and I need to stop looking. In the hopes, however, that I am too unlearned to recognize the answer when I see it, I'd like to just ask: how do I do this? For instance: ~~VBA macro~~ Sub Foo2Script Dim x As Long x=2 Call script here MsgBox scriptresult End Sub ~~VBScript~~ Dim x, y x = x_from_macro y = x + 2 scriptresult = y Any help is greatly appreciated. Ed Tag: how to automate drop-down forms in a word doucment Tag: 87668
  - 6
    - Font issues in Word Hi, I use Word 2003 with Windows XP on my system. Today when I open my word application all my fonts are missing in Font formatting dialog and also on formatting toolbar. It lists only three fonts. they are: Device Font 10cpi, Device Font 12cpi, Device Font 17cpi. no other fonts are available in word application. There is no problem in Excel. The problem is with Word only. So, i am unable to use any fonts other than these fonts in my documents. I hope this is clear. Till yesterday it was OK. I haven't installed any new programs/softwares. I reinstalled word but the problem is not solved. Anyone know what happend? Please help me. Thanks, CS. Tag: how to automate drop-down forms in a word doucment Tag: 87664
  - 7
    - Set Filename & Path for newmerge document I have a document template which our database merges information in to using merge fields and then it automatically puts the result in to a new document. I want set the filename and path of the new document as a combination of 3 fields: G:\Saved Quotes\<<Number>><<Sequence>>, <<Surname>> Any ideas? Any code that I had on the template does not seem to carry through to the new merge document! Tag: how to automate drop-down forms in a word doucment Tag: 87661
  - 8
    - How can I un-block Visual Basic Editor in MS Office 2003? Hello, I have a PC which was recently upgraded from office XP to office 2003. Now I am unable to use ACT or Quickbooks in conjunction with word 2003. It appears this is related to VBA scripts being blocked. However, I cannot find any reason why they would be blocked. Also this PC is running behind an SBS 2003 server, if this may be the issue. Lastly, I also cannot access the Visual Basic Editor. Both trying to use ACT or Quickbooks as well as trying to open Visual basic Editor gives me a very generic error stating that your macro security settings should be set to High or lower. I have tried setting the macro security to all settngs from Very High down to Low, which no change. I have also forced the settings via a GPO policy on the SBS server to make sure that VBA and macros are allowed. Your help is greatly apreciated. Tag: how to automate drop-down forms in a word doucment Tag: 87658
  - 9
    - Large Word doc size This is my first request for help so please be gentle! I am using Word 2004 v11.2 on a 2005 pre-Intel G5 iMac (OSX v10.4.7). I am an experienced Word user. We use Word primarily for building participant worksbooks for our workshops. These contain tables, text, images (pasted from Powerpoint as pictures - not linked), a watermark, colour and shading (mainly in the tables). We are building a new workshop and the participant's workbook has suddenly blown out to a surprising 28MB in size. I have tried the old tricks to reduce the size: 'save as' on top of the original, removing some of the larger size images, removing the watermark but nothing seems to make a substantial difference to the overall file size. My issue with the size is that it is now impossible to email which I would like to be able to do again. Our work-around has been to utilise the .Mac server (public folder, password protected). These documents are copyright. The review team are all on separate continents (Africa, north America and Australia). Two use Mac and one is still using PC. Any suggestions would be welcomed. Thank you Mark Tag: how to automate drop-down forms in a word doucment Tag: 87655
  - 10
    - One server for ftp, web,etc abstractly rerefenced to office for An integrated server ( say, http, web, ftp, telnet) that ASP.NET governs, but retains an abstract refernence to Word or any Office product. The application could be looked at as object to log onto the net and perform data transfer quiclky. Strangely, this type of server could be used to login to unsecured sites ( those who transfer data in binary or traverse the wire in ascii) and overfow the character input buffer prior to the site's validation of visitor. On a different note, I have had registry issues because of invalid Program ID's and the ActiveX/COM sections: they don't map. CLSID's name the implementation of methods, but support for ascii text names give a Program ID, but only by convention. The COM API's may change in updated OS versions, but the function signatures may not reflect that. The extended functionality now has inaccurate key values for the literal item. The CPU then has to give attention to the suspension. ---------------- 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=9e28a29b-ddf0-4cf0-999d-454ca9ca2e5b&dg=microsoft.public.word.vba.general Tag: how to automate drop-down forms in a word doucment Tag: 87651
  - 11
    - Add-In macro doesn't show in ALT+F8 list? I wrote a macro and put it into an Add-In (in a template, in the right folder, added and everything). Tools>>Templates and Add-Ins shows the template and it's checked. If I do ALT+F8, with the list showing macros in "All active templates and documents", the macro name doesn't show up. If I change the drop-down to show only the name of the Add-In, the macro name shows. What do I need to do t fix this? Ed Tag: how to automate drop-down forms in a word doucment Tag: 87649
  - 12
    - I want a united kingdom dictionary in word, help? I am trying to find a way to import a more "Oxford" English dictionary into my MS Word 2003 program. I am a US and Canadian citizen. It is just that "Oxford" is a far better version of our language. Tag: how to automate drop-down forms in a word doucment Tag: 87643
  - 13
    - Lock Form When Text Field is Clicked I am working in Word 2002. I have created a template, the first section of the form the user types freely (no fields). The next section contains the fields that the user will tab to to complete the form. I would like to have a macro that will lock the template when the user clicks on the first field (Text1) with the mouse. Can this be done? -- Jamie Tag: how to automate drop-down forms in a word doucment Tag: 87640
  - 14
    - Add-on encountered a problem What should I do as my computer has the "Add-on encountered a problem - Adobe PDF Reader ..." Tag: how to automate drop-down forms in a word doucment Tag: 87638
  - 15
    - Adding autotex to a template I have a letter template macro as a form chooser and I would like to add various autotext in a list so that they can be added to the address bookmark in the template. Is there a way or would I have to add each company name to a module as an additem and then put the addresses in a macro in the form chooser? If there is a better way which will pick up the autotex which are contained in a global template in startup then that would be great as then I wouldn't have to add a new macro every time someone requires a new address adding to the list. Many thanks Tag: how to automate drop-down forms in a word doucment Tag: 87632
  - 16
    - Need to extract a Date value (text) from a Word doc Hello, We have about 950 word docs that have a date value in them, to which we need to know so we can bill them for a specific period. Each doc has the specific date contained in this phrase: "REPORT DATE: August 25, 2004". If it's relevant, the actual date (August 25, 2004) begins on line 10, col 15. All of the 950 docs have a file name in this format, eg: 1-1-111-111 and then the DOC extension, eg: 7-5-047-053.doc So, I need a routine that I can run WITHOUT having to open each and every one of the word docs. If the routine needs to run inside an empty (IOW: where no file is actually loaded or created) Word session, that's OK. The routine needs to extract the date (AND the filename) and put them into a text file (which I will import into Excel later) with two columns like below: FILE NAME REPORT DATE 7-5-047-053.doc August 25, 2004* * Note: if it is easier to change the date into another format such as 8/25/04 or whatever, that's OK with me. Looking forward to seeing your responses! Tag: how to automate drop-down forms in a word doucment Tag: 87630
  - 17
    - Custom Macro My Documents defaulting error , We use word 2003 in our company. We have some shared folders that we want our users to have a direct path to from word. We created a macro Sub ISP() ChangeFileOpenDirectory "\\Xpcdc001\Plans\ISP\" SendKeys "^o" ' End Sub This macro browsers to the \\Xpcdc001\Plans\ISP\ share and then does a control O to open the open file box. We added this macro under tools --> macros --> macros then added the macros name and typed the vba code between the sub and end sub into the editor. Next we wanted to create a custom menu item linking to this macro so that our users would be able to run it easy . We went to tools --> custom --> comands added a new menu and added the macro to the menu. We get very odd results. When word is started and you go to the menu and click the macro it opens the open file box and defaults to my documents (which is incorrect because it should default to the share specified) When you close the file open box and reclick it without closing word you get the correct location in the file open box. You get the correct location everytime then when you click the macro till word is closed and reloaded. Always on the first time it defaults to the my documents location. I have downloaded all patches and service pack 2 from office website and still did not resolve the problem. Any input on this problem will help alot. Danewman@ahrc.org Tag: how to automate drop-down forms in a word doucment Tag: 87625
  - 18
    - How to show a list of words for me to choose? Hi, I need to type a lot of documents in which some phrases occur very often. Some of the examples are "medical evidence", "medical report", "Statements of Claim", "Statements of Damages". Given that some groups of words appear very frequently, I would like to use VBA to let me choose from a list of phrases after I have typed a few letters of the target phrase. For example, when I type "med", the list of "medical", "medical report" and "medical evidence" will pop up automatically and I can choose a phrase, say "medical report", that I need from this list. Can someone tell me how to do this or tell me the good books about Word VBA teaching me to do this? Thank you. David Tag: how to automate drop-down forms in a word doucment Tag: 87623
  - 19
    - word files with embedded excel objects I have a user that has ~300 word files. Each of these word files have embedded excel objects in them. The powers that be want a program written that will open these word files and edit hyperlinks that are inserted into the excel objects. Is this doable? Any help getting started would be apreciated. Thanks Mike Tag: how to automate drop-down forms in a word doucment Tag: 87617
  - 20
    - String too long error I am a complete novice at programming in Word so please bear with me. I am a developing a Lotus Notes application that needs to output a document to Word. I have created a tabular Word template and am outputting the individual fields as strings, so for example: worddoc.FormFields(1).result = RaisedBy This is working fine for all of the fields except for the final one which is a text field that can contain a fair amount of data and is generating a Word "Script too long error".. Does anyone have any suggestions as to how I can get around this? Could it be because the field is contained in a table cell? I've been really struggling with this output and the best way to do it as I have no experience of the features of Word at all. Any help would be greatly appreciated. Kate Tag: how to automate drop-down forms in a word doucment Tag: 87616
  - 21
    - attaching a document to email Hi, I am sorry for reposting, but i have lost original thread I am attaching a doucment to an email using Options.SendMailAttach = True ActiveDocument.sendmail i have been trying to use mailEnvelope to add the to: field and the Subject: field. but cant get the correct syntax. Can someone help please Thanks J Tag: how to automate drop-down forms in a word doucment Tag: 87615
  - 22
    - How to include macros in .doc file HI, I am using Word 2003. I wrote template lets call it "test.dot" which uses macros. When I create .doc file using test.dot on my PC I can use macros. In Tools->Template and Add-ins->Document Template is path to the template the .doc is based on. For Example C:\\...\test.dot But when I created .doc on my PC and send it via email as attachment the user in the other site can not use macros while the path to the template the .doc is based on is not actuell. My Problem is how can I include macros to the .doc document that it works on every machine without having information about template. Is it possible? Tag: how to automate drop-down forms in a word doucment Tag: 87607
  - 23
    - Strange Print Error With VBA Created Doc - Solution The solution was in the Word Application itself. Tools->Options->Print->Hidden Text. Selecting this option fixed it. Seems on some machines, Word treats vba created text in text boxes as hidden by default. hals_left Hi This may or not be vba related. Has anyone ever encountered a prioblem like this before, Or know a solution A table cell in a word doc contains multiple address lines, created using the code below in a template. The address loooks just fine in Word and even in print preview, but on the actual paper on the first line appears. Also intermittent , works ok on some printers. Users have found a workaround, cut the address then paste it back before printing. Any thoughts ? Thanks hals_left Set objRS = objConn.Execute(strSQL) If Not objRS.EOF Then strAddress= objRS("BusinessName") strAdd1 = objRS("Add1") strAdd2 = objRS("Add2") strAdd3 = objRS("Add3") strTown = objRS("TownCity") strCountyLine = objRS("County") & vbTab & objRS("PostCode") If strAdd1 <> "" Then strAddress = strAddress & vbCrLf & strAdd1 If strAdd2 <> "" Then strAddress = strAddress & vbCrLf & strAdd2 If strAdd3 <> "" Then strAddress = strAddress & vbCrLf & strAdd3 If strTown <> "" Then strAddress = strAddress & vbCrLf & strTown strAddress = strAddress & vbCrLf & strCountyLine ActiveDocument.Tables(2).Rows(1).Cells(1).Select Selection.Text = strAddress Tag: how to automate drop-down forms in a word doucment Tag: 87604
  - 24
    - Count files Part of my Word macro is using for counting files in a folder. The problem is that result of counting also includes all open files in that folder. So the number of files is correct only if no documents are open in that folder. This worked well in Office 2000 (Word 2000). Result didn't include open files. The macro is the same and it doesn't work correctly in Office 2003 (Word 2003). The code: Dim stevec As Integer With Application.FileSearch .FileName = "pr????.doc" .LookIn = "\\_server_\_folder_\" .SearchSubFolders = False .Execute For stevec = 1 To .FoundFiles.Count Next End With MsgBox Stevec Regards, Iztok Tag: how to automate drop-down forms in a word doucment Tag: 87603
  - 25
    - how can I set tab stops for only fill-in areas of the document? I want to be able to tab to different areas of my document where a blank needs to be filled in, and ONLY those areas. I want to start at the top of the document and have my tabs go to the next blank that needs to be filled in, and so on. Tag: how to automate drop-down forms in a word doucment Tag: 87599
- Next
  - 1
    - esoteric Word VBA run order issue - not trying to scare off anyone I created a form and some VBA code behind it in a Word doc file. Under the ThisDocument (Microsoft Word Objects) for Document_Open() I have the following code: Private Sub Document_Open() form1.Show End Sub That kicks off the form but I get a Run-time error '5852': Requested object is not available. I did a line by line execution run and found that the error occurs in this line strPatMasterID = ThisDocument.MailMerge.DataSource.DataFields("PatentMasterID").Value The problem is order in which the code is executed. The mailmerge (based on msquery) is kicked off after the form opens (or in this case because of the error, when I click "end" to stop the code)... so obiviously it cannot retrieve the mailmerge.datasource.datafields if the mailmerge doesn't run first. So, does anyone how now I can manipulate the run order of the VBA code or explicitly force the msquery to run first before I retrieve the data? Would setting a timer work? thanks in advance for your help Tag: how to automate drop-down forms in a word doucment Tag: 87594
  - 2
    - Formatting in endnote to text macro? I've just come across a Word macro Doug Robbins posted on Google Groups some time back to convert endnotes to text (below). I'm grateful for this, which will be useful as I and a co-author have a lot of endnotes to convert before submitting a book. When I run it, however, I lose all the formatting in my endnotes, which is a problem for all the italicized book titles in my notes. Is there any way to retain this formatting? Thanks for any help you can provide. Yours, David. -- From: Doug Robbins- view profile <http://groups.google.com/groups/profile?enc_user=n5ytSBIAAADLukhUwkIQqTf lNRzxM-TQII73Nnd8MGuFrQYThHx-nw> Date: Wed, Jan 19 2005 3:41am Email: "Doug Robbins" <d... <http://groups.google.com/groups/unlock?msg=a80683a23dc18ad5&_done=/group /microsoft.public.word.formatting.longdocs/browse_frm/thread/e186d433d465 8f5/a80683a23dc18ad5%2523a80683a23dc18ad5%3F> @NOmvpsSPAM.org> Groups: microsoft.public.word.formatting.longdocs ' Macro created 29/09/99 by Doug Robbins to replace endnotes with textnotes at end of document ' to replace the endnote reference in the body of the document with a superscript number. ' Dim aendnote As Endnote For Each aendnote In ActiveDocument.Endnotes ActiveDocument.Range.InsertAfter vbCr & aendnote.Index & vbTab & aendnote.Range aendnote.Reference.InsertBefore "a" & aendnote.Index & "a" Next aendnote For Each aendnote In ActiveDocument.Endnotes aendnote.Reference.Delete Next aendnote Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find.Replacement.Font .Superscript = True End With With Selection.Find .Text = "(a)([0-9]{1,})(a)" .Replacement.Text = "\2" .Forward = True .Wrap = wdFindContinue .Format = True .MatchWildcards = True End With Selection.Find.Execute Replace:=wdReplaceAll Tag: how to automate drop-down forms in a word doucment Tag: 87589
  - 3
    - how do i get the paragraph symbol out every time i create a page? every time i get into a word office to type something i get a paragraph sign and i can't delete it. it's not temporary either it's every time i get in Word and my space isn't a space they are dots. like this.....but a little higher.so it's not on the line. am i confusing people more now? please help it's driving my nuts!!!!!! thank you Hope Tag: how to automate drop-down forms in a word doucment Tag: 87586
  - 4
    - WHERE IS A SAVE OPTIONS LOCATED AT? Hello dearest, Today I am posting these questions, because I really do not know how to find out how to work of problems. That why I really need help from all of you people, please help me to solving out, Thanks. PS. I have open an application forms, and when I get into an application forms trying to filling out, however I cannot typed. Is because of the hand have showing and it will not let me type. I cannot figure out how to solving problem. Could you please helping me to solving out of those problems please? Thanks. My e-mail address is (tolovingyouforever4@yahoo.com); please reply an answer back to me, Respectfully yours, A.H.K. Tag: how to automate drop-down forms in a word doucment Tag: 87585
  - 5
    - How can I design form templates to give textbox on checkbox click I am trying to create a form template so that when you click on a checkbox, another form field will appear. For example: I want to give someone the option to put recommendations and the number 1) But if they have more than 1 recommendation I want to be able to have them click a checkbox and another (Number 2) textbox will appear. Does anyone know how to do this or where i can go for some answers? Thansk, Tag: how to automate drop-down forms in a word doucment Tag: 87578
  - 6
    - value for record at EOF (Using Word 2003) I have 20 records in a database and the ID of the 20th record is 24. Whenever I attempt to extract the ID# of the last record, it only shows the count (in other words, returns 20 instead of 24), using this code: jbID = ActiveDocument.MailMerge.DataSource.DataFields("jbID").Value If someone can show me an example of what should go before this so as to return the value of the last record, I'd appreciate it. I've tried different things with recordsets and EOF but I keep getting errors, even after setting up all the references for ADO and DAO. I'm connecting to the database since it's returning the record count, but I can't seem to pull up the actual value of the ID field in the last record. Many thanks in advance for your help. -- Bryan Tag: how to automate drop-down forms in a word doucment Tag: 87566
  - 7
    - Search and Replace This is probably a crude, brutish way to attack my problem, but given my limited knowledge, that is all I have. My question is: Is there a way to search for particular text and replace each instance with a blank Text Form Field? Background: I have made a merge document to fill in data from our client(s). There are some areas of the document that are not worth tracking in our database and will need to be filled in manually. I have found that mergefields and form fields do not play well together because of the locking requirement for form fields. Our secretaries are not well-versed in Word, and I am trying to make it as easy and error-free as possible to complete these documents. My idea was to complete the merge and then have them run a macro (from a custom menu) that unlinked the mergefields, replaced "**" throughout the text with a Text Form Field, then locked the document for the remaining data entry so that they could tab from area to area and fill in the required missing information. Like I said probably crude and brutish in an attempt to be efficient and helpful. Thanks for any pointers. Tag: how to automate drop-down forms in a word doucment Tag: 87557
  - 8
    - Please Help with My Document ASAP Hello, I need help with my document. The date on one page needs to be on two lines, not one. I need to add an extra page so I can finish my notes for my job. Information is confidential as far as contents. I'm using Microsoft Word and have Windows XP. Susie ncirisgal@gmail.com Tag: how to automate drop-down forms in a word doucment Tag: 87555
  - 9
    - Create custom toolbar controls How do you create toolbar controls (besides ordinary buttons), e.g. similar to the default highlight control, font color control, etc. Visual basic does not seem to be able to create these. Tag: how to automate drop-down forms in a word doucment Tag: 87550
  - 10
    - Outlook object not being created When I ran the following code the first couple of times it created the object, but now it won't. My objective is to create an e-mail with variables defined previously in macro, and not sending it right away. Any suggestions? (The reference library Outlook item is check-boxed in the menu.) Dim objOutlookApp As Outlook.Application, objItem As Outlook.MailItem With objItem .To = strEmail .Subject = strCo & ", " & " " & strJ .Body = "message" .Display End With Selection.InsertFile FileName:=strNew, Range:="", ConfirmConversions:=False, Link:=False, Attachment:=True Set objItem = Nothing Set objOutlookApp = Nothing -- Bryan Tag: how to automate drop-down forms in a word doucment Tag: 87549
  - 11
    - Fonts for Word "Fields" when setting values We have a java application in which we create custom fields in MS Word using JACOB. On user initiation the fields are populated with values. If after creating the fields and change the FONT to a BARCODE font and when the fields are getting replaced with values, the BarCode font is not retained. The values are shown in original font. This happens only in Word 2003. The Bar Code font is retained for field values in Word 2000. Is there any setting or property to be set so that Bar Code fonts are retained for field values. The machine has Bar Code fonts installed. Thanks in advance for any suggestion. Tag: how to automate drop-down forms in a word doucment Tag: 87546
  - 12
    - Multiple styles in a selected range I'm using Word 2000 on XP Pro. My problem arises when I select a range that contains multiple paragraph styles, and attempt to determine whether or not all the styles are the same. Any code like objRange.style results in this error: Run-time error '91': Object variable or With block variable not set The MSDN Library says: When you return the style for a range that includes more than one style, only the first character or paragraph style is returned. Why doesn't this happen? Am I reading this wrong? Is it a Word 2000 thing? Bear Tag: how to automate drop-down forms in a word doucment Tag: 87544
  - 13
    - Designate Path when using SaveAs How do I designate the path when using SaveAs. I found that it saves it to My Docs. How do I change the Path, while telling word that it's a text file format at the same time? Thanks. Tag: how to automate drop-down forms in a word doucment Tag: 87543
  - 14
    - TOC helper - replace hidden paragraph with style separator I work at a help desk with a large number of Word users and occassionally run into the problem where users either are not familiar with using the style separator (to assist in creating run-in headings so that only the heading, not the body text, shows up in the TOC) or are older documents that used hidden paragraph marks. Since multiple people can work on a document, we sometimes end up with documents that partly use style separators and partly use hidden paragraph marks - VERY confusing. So I created the following script to replace the hidden paragraph mark with the style separator (for Word 2002 & above). Although this code has been working well for the past several days, we are still testing it. If you would like to use it, PLEASE PLEASE PLEASE save the document you are going to try it on first. Although I cannot imagine why it would cause any problems, it is designed to replace items in the document, so there is always the chance I may have overlooked something. Mike Sub HiddenParaToStyleSep() Selection.HomeKey Unit:=wdStory ' Find hidden paragraph With Selection.Find .ClearFormatting .Text = "^p" .Font.Hidden = True .Forward = True While .Execute ' If hidden paragraph is Style Separator, do not replace If Selection.Paragraphs(1).IsStyleSeparator = False Then ' Replace hidden paragraph with auto color, unhide With Selection.Font .Hidden = False .Color = wdColorAutomatic End With ' Insert style separator Selection.InsertStyleSeparator End If Wend End With End Sub Tag: how to automate drop-down forms in a word doucment Tag: 87542
  - 15
    - Find and Replace only once using .Find Can you only find and replace once using .Find? If I have multiple words to find and replace, is there a better way? Here is my code: Option Explicit Set myrange = appWord.ActiveDocument.Content With myrange.Find .Text = "SiteIn" .Execute replacewith:=SiteInfo & "." & SiteScheme .Text = "SiteBad" .Execute replacewith:=SiteInfo & "_" & SiteScheme & "bad" .Text = "SiteDiscard" .Execute replacewith:=SiteInfo & "_" & SiteScheme & "dis" .Text = "SiteNum" .Execute replacewith:=SiteInfo End With Tag: how to automate drop-down forms in a word doucment Tag: 87539
  - 16
    - Macro to detect manual style overrides (e.g. StyleName + Bold) Hello, I need a diagnostic macro that detects manual style overrides in a document. These style overrides are shown in the Styles and Formatting task pane as "<StyleName> + Bold", for example, if 'Formatting in use' is selected. Apparently, they do not belong to the Styles collection, but I don't know how to address them. Does anybody know how I could list them using a macro? Thanks in advance Heike Tag: how to automate drop-down forms in a word doucment Tag: 87538
  - 17
    - Inserting "notes to pages nn to nn" in endnote page headers Is there any way of inserting "notes to pages 32 to 55" in the header for the endnote pages (where the first endnote that appears on the page occurs in the text at page 32 and the last to appear on the page occurs in the text at page 55)? 1. Is there any way to do this without writing VBA code to do it? 2. If the answer to 1 is no, does anyone have some sample VBA code to do this? Thanks! Tag: how to automate drop-down forms in a word doucment Tag: 87537
  - 18
    - Inserting HTML into Word (Word 2003) Hi, I have a situation in which I need to copy the contents of an HTML, complete with its CSS files and images, into a Word document. The simple solution is to use the command Selection.InsertFile which is equivalent to choosing File / Insert from the menu. However no matter what parameters I give to Selection.InsertFile, I keep getting the same message: "Recording Clipboard style sheet will require copying many styles. Do you want to use Normal style instead?" The correct answer to this question is NO because it preserves all the formatting. However I can't find any switch to make this dialog disappear and answer NO. How can I close this dialog while answering NO programmatically? Thanks, Arie Tag: how to automate drop-down forms in a word doucment Tag: 87536
  - 19
    - Find & Replace Iâ??m using Windows XP and Word 2003. Word has a Find and Replace feature. How do I implement this to find all sequences of letters, symbols, and numbers between a specific word ,â??Startâ??, to the end of the line so that it can be replaced with a new set of letters, numbers and symbols. Example: Start <Appendix 12A> Tag: how to automate drop-down forms in a word doucment Tag: 87530
  - 20
    - I had Microsoft Office 2000. Can I get it back? Last year my computer crashed so I had to buy a new one. I lost my Microsoft Office 2000. Is there a way of redownloading this software without having to repay for it a second time? Tag: how to automate drop-down forms in a word doucment Tag: 87527
  - 21
    - Exporting This Discussion Is there anyway to export all the content of these discussions for offline reading/printing? Thanks! Tag: how to automate drop-down forms in a word doucment Tag: 87521
  - 22
    - Delete Table Rows (Blank) Macro Question Hi all, I have this macro delete table rows blank which does not work on a table after I make changes to a row such as split cell 2 columns or insert rows using CTRL ALT I - am I missing something? Is there a macro that can delete blank rows regardless of how they are inserted. If you just create a blank table using Insert Table, ie drag mouse across number of colums rows and type in some rows it is fine and deletes blank rows. The moment you add rows or split cells on a row it gives this error: Runtime error 5941 the requested member of the collecton does not exist (after running). Can I refine it to acknowledge blank lines inserted using CTRL ALT I and split cells in a blank row? Is it viable? What am I missing? Thank you to whomever can assist. Public Sub DelTableRowsBlank() Dim flag As Boolean, I As Long, j As Long, atable As Table Set atable = Selection.Tables(1) With atable For I = .rows.Count To 1 Step -1 flag = False For j = 1 To .Columns.Count If Len(.Cell(I, j).Range) > 2 Then flag = True Exit For End If Next j If flag = False Then .rows(I).Delete End If Next I End With End Sub Tag: how to automate drop-down forms in a word doucment Tag: 87515
  - 23
    - OutPersonals OutPersonals http://outpersonals.com/go/g671669 Tag: how to automate drop-down forms in a word doucment Tag: 87510
  - 24
    - Deleting bookmarks I am inserting some text via vba from Acces into a Word doc. It is working well except afterwards teh book mark is deleted. Any thoughts?? TIA Bob Tag: how to automate drop-down forms in a word doucment Tag: 87509
  - 25
    - OutPersonals OutPersonals http://outpersonals.com/go/g671669 Tag: how to automate drop-down forms in a word doucment Tag: 87508

I have inserted drop down menus in a word document to make a template, if i
lock the form and have a drop down box that is A-Z for example. How can I
make it so that when a user hits the letter P, P shows up?? I can only find
out how to make it work if the user drops down the list and selects the
option, I'm sure there has to be an easier way.

Thank you so much!

Top

Re: how to automate drop-down forms in a word doucment by Doug

Doug
Thu Jun 29 22:56:27 CDT 2006

You cannot do that with DropDown FormFields.

If appropriate, use a userform instead.

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

--
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

"Patrick" <Patrick@discussions.microsoft.com> wrote in message
news:925AC559-8AC8-4145-91A3-302A3C987292@microsoft.com...
>I have inserted drop down menus in a word document to make a template, if i
> lock the form and have a drop down box that is A-Z for example. How can I
> make it so that when a user hits the letter P, P shows up?? I can only
> find
> out how to make it work if the user drops down the list and selects the
> option, I'm sure there has to be an easier way.
>
> Thank you so much!

Top