Nonmodal user form focus

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Selecting a combo box in a nonmodal user form Hello: I have a user form with a combo box that shows the style of the selection. I'm displaying the user form in nonmodal fashion. How do I get that combo box to have focus AND show the current text as being selected? When ShowModal is True, using the SetFocus method highlights the combobox text. When ShowModal is False, it doesn't. Neither do the SelStart and SelLength properties work. Any ideas? Bear Tag: Nonmodal user form focus Tag: 76684
  - 2
    - How can I manipulate Word table cell alignment from Excel? Hi everyone I am writing an Excel application that creates and then formats a Word table in a new document. I want to be able to set the cell alignment using VBA to Centred. I have tried using the Range object but to no avail. I also tried running a macro in Word, referring to the VBA code it generates but it refers to the Selection object that does not work inside the VBA I am using in Excel (I already set a reference to the Word Object library). Can anyone help? Tim Tag: Nonmodal user form focus Tag: 76678
  - 3
    - Example: How do I set up a repeating meeting in Outlook Tag: Nonmodal user form focus Tag: 76677
  - 4
    - Formatting table cell externally Hi everyone I am developing an Excel application where a report in Word is to be generated. The report consists of a table which I want to create and format through VBA in Excel. In particular I want to be able to set certain table cells so the text in them is Centred rather than the default Left. I have tried using the range object but am getting nowhere (the cells remain Left formatted). The final step is to display the document with all the correct formatting. I tried running a Word macro, carrying out the centering and then checking the VBA for clues but it refers to a Selection object that is not recognised in VBA in Excel (even though I have set a reference to the Word Object library). Anyone able to help? Thanks in advance Tim Tag: Nonmodal user form focus Tag: 76675
  - 5
    - WordStar to MS Word conversion engine. I have a number of documents in WordStar format (a defunct word processor) that I need to convert to MS Word "doc"s. I have looked through the HELP function in MS Word with no success. Microsoft's web-site topic search doesn't recognize the term "WordStar." Is there a conversion engine and how can I get it. (Free, if possible.) Tag: Nonmodal user form focus Tag: 76674
  - 6
    - is there a way tHat i can create an overlay with word I have a form that I want to put data on. I want to scan the form into word and then merge data over it. Anyone know how to do that??? Mike Tag: Nonmodal user form focus Tag: 76673
  - 7
    - Dropdown List of References I currently have a toolbar macro that a user can select to insert a cross-reference to an endnote that is already referenced in the document. What the macro does is have a pop-up box requesting the user to input the reference number into a text box, it stores the reference in a variable, and performs the cross-reference using the variable number. Now the user's want to have the pop-up give them a list of the currently available references. Is this possible to populate a drop-down list with the current references in the document? -- Debra Ann Tag: Nonmodal user form focus Tag: 76670
  - 8
    - Inserting HTML images in a Word doc Hello, I recorded a Word macro that inserts an image that exists on the internet. I started recording and went to Insert->Picture->From File. Then I inserted the URL in the path bar. The file inserted fine and the vba code was recorded. However, when I play back the macro, it says "Error 5152" - something about the file not being valid. Anyone know how I can do something like this? I have images on a webserver that I want to display on my page using a macro. I am using Word 2000. Here is the vba code it records: Selection.InlineShapes.AddPicture FileName:= _ "http://www.site.com/test.gif", _ LinkToFile:=False, SaveWithDocument:=True Thanks Danny Tag: Nonmodal user form focus Tag: 76669
  - 9
    - Word should have translation for Tagalog (Philippines). I do not see any translation in Word for the Philippine dialects. I am trying to learn Tagalog and would like to see a translation tool in Word. ---------------- 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=2d4ab57d-fa53-4912-87b9-3cc79ea84890&dg=microsoft.public.word.vba.general Tag: Nonmodal user form focus Tag: 76666
  - 10
    - Word should allow making a macro for formatting an imported EPS When turning on the macro recorder, I have discovered that the tools associated with formatting an imported picture are turned off. I consistently import full-page EPS images, to be positioned and sized to fit the page. The settings I need are the same, every time. Frustrating that I can't record this in a macro. ---------------- 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=f895c9e5-8cfe-47f6-bf7c-11232a6d4dee&dg=microsoft.public.word.vba.general Tag: Nonmodal user form focus Tag: 76662
  - 11
    - How to hide caret in Word 2003? Hi everyone, I need to hide caret in Word 2003. I tried HideCaret API function like this HideCaret GetFocus() but without success. Function returned 1 (success) but the caret remained visible. I tried also EnumChildWindows API to find handle of the window containing the caret. In both cases I got the same hWnd but also the same result - nothing happened. Does anyone know how to hide caret in Word? Thank you in advance. Regards, Robert Tag: Nonmodal user form focus Tag: 76660
  - 12
    - Avery 9490 Labels Need to print these labels and can't find template in Word. Tag: Nonmodal user form focus Tag: 76656
  - 13
    - Saving HTML Fill In Forms I have created a fill in form in Word using the Web Tools toolbar. Then saved as a Web Page. The form will be sent to users who do not have Word but have a browser to access and fill in the Word form. How do I get the data the user fills in? When the user emails the form, I get the form back blank. Thanks for any input! Tag: Nonmodal user form focus Tag: 76645
  - 14
    - Toolbar Button in Word to Open Access Database I'm using Word 2003 and need to be able to create a button on a toolbar which will open an Access 200 database which has addresses in it. Can anyone assist me with this. Thanks! Tag: Nonmodal user form focus Tag: 76643
  - 15
    - Parsing a Word doc and using data to create new doc I want to programatically parse a Word document and create a new Word document with the extracted data. I think creating a wizard/VB application to do this would be ideal. As an alternative, I guess I could create a macro. Does anyone have some VB code that I could look at? Tag: Nonmodal user form focus Tag: 76640
  - 16
    - Question on automating Dialogboxes in VBA Hello, I was wondering if the following is possible in VBA. I am running a model that pops a dialog box up once in a while - each time, the button I click to rerun the model is exactly the same, i.e. 'Run'. Is there anyway I can automate this process, so everytime the dialog box pops up, it automatically clicks the 'Run' button. If not VBA, what other program would be useful here. I was wondering if the answer might be as simple as being able to run a Newline function within a dialog box. Thanks. Tag: Nonmodal user form focus Tag: 76636
  - 17
    - How to check whether a file is a valid word document or not? I would like to know how i can check whether a particular file is a valid Word Document or not. I tried to read the "Application Name" atribute in the summary information of file using ActiveDocument.BuiltInDocumentProperties collection. But it always returns "Microsoft Word" even though i open a PPT or Excel file. Please help me in addressing this issue. Thanks a lot in advance. Tag: Nonmodal user form focus Tag: 76632
  - 18
    - template and menubar i am using office xp, word 2002 - sp3. i have created a toolbar and a menubar for my new template. when i open this template in a different computer (using same office version), my menubar disappears, only the toolbar is available. please advice how to accociate the menu with my template and make it available in other computers. thanks in advance Tag: Nonmodal user form focus Tag: 76630
  - 19
    - ComboBox Hi, Is there a way to determine the difference between typing in a combobox and changing it by using the drop-down? I can only find the change-event. / Ulf Tag: Nonmodal user form focus Tag: 76629
  - 20
    - Findout the solution of my project I'm using Visual Basic 6. I'm doing my project which is related with VB and Word. I've designed One Button and Rich Text Box. (RunTime )Copy Word Document contant and paste it in this RichTextBox. If you click this button it should autometically saveas Word Document. It's working but the alignment not in order. Could you please tell me what we are getting from our word document it should appear on our document in the same manner Tag: Nonmodal user form focus Tag: 76626
  - 21
    - need help for hooking the selectcert dialogbox Hi all I am looking for tweaking the current behavior of Word when it comes to apply a digital signature. Actually a dialogbox pops up showing available certificates in my store when applying following code in a macro dim sig as signature set sig = activedocument.signatures.add 'here the dialog box pops up and we select manually a certificate 'then to save the signature attached we need : activedocument.signatures.commit I would need to pass a time stamp (date) as parameter to tweak the digital signature , I would like to hook in the select_cert_struct used to build the listbox showing the certificates (Article on MSDN about selectcert function as well) only with filtered certificates (signer name, certificate issuer and expiration date) I can't figure out how to proceed... Any of you can help me ? looking forward to hear from you soon I remain regards Tag: Nonmodal user form focus Tag: 76621
  - 22
    - How to deselect floating text box In Word 2000 I have a floating text box in a cell of an many-row table. I am trying to create a macro that will delete the box, the paragraph mark that it is anchored to, and the 3 blank paragraphs after it (all in the same cell). "Selection.ShapeRange.Delete" will delete the text box, but the cursor jumps to the top of the document. I tried some GoBack commands to bring the cursor back to where the box had been but they don't always take the cursor to the right location. What I really want to do is start the macro with the text box already selected by the user, then deselect the box and put the cursor immediately in front of it so I can delete the paragraph containing it. What code do I use to that is equivalent to "deselect the text box and put the cursor immediately before the box"? ("Collapse" puts the cursor in front of the text that is in the box, not before the box.) TIA, Vivian Tag: Nonmodal user form focus Tag: 76615
  - 23
    - Embed files in Word (OUTLOOK.Fileattach) I have RTF files which have embedded ole objects whose classtype is "Outlook.FileAttach". I've been trying to use the inlineshapes property in the word object model. I can't do inlineshape.oleformat.object.saveas. There is a Run-time error 430: Class does not support automation or does not support expected interface. My code works for other classtypes besides this. Is there a way around these classtypes? Tag: Nonmodal user form focus Tag: 76611
  - 24
    - Convert slide object to jpg I'm using "Send To Word" to get my slides and speaker notes to a Word document for further editing and reformatting. The slides are sent as "slide objects"; this results in an enormous Word file size. In m.p.powerpoint I asked if there is a way to get "Send To Word" - or some similar function - to send jpgs or some other image style. My other option is to convert the slide objects, programmatically, to jpgs. I tried the following: Selection.InlineShapes(1).OLEFormat.ConvertTo ClassType:= "Paint.Picture", DisplayAsIcon:=False but I get "Run-time error 5360: The server application, source file, or item cannot be found..." Is there a way in vba (or other way) to convert the slide objects to pictures? BTW, my workaround is to use SnagIt to capture the image of the slide object in the clipboard, delete the slide object, and paste the image in its place. Tedious for long documents, however! Thanks, Bob Tag: Nonmodal user form focus Tag: 76610
  - 25
    - Show/hide large pieces of a document? Hi, Here's an interesting challenge... I was asked to create an application that would let users choose paragraphs to show or hide using a checkbox. The basic idea is that they would look at several alternate paragraphs per page, choose one by checking its checkbox, and then generate the "final" version of the document, which would hide the non-checked paragraphs on each page. In some cases, entire pages could be shown or hidden with page-level checkboxes in addition to the paragraph-level checkboxes (e.g., if a page is checked, only show the paragraphs on that page that are also checked). I don't know where to start on this one. I've fiddled around with bookmarks and ranges, and neither seems to offer an easy answer. Can anyone offer any good suggestions to make this a straightforward kind of project? Thanks to anyone who can help... ...Jay Tag: Nonmodal user form focus Tag: 76607
- Next
  - 1
    - How to prevent the wdPaneComments pane from opening I have a toolbar to add comments using: Selection.Comments.Add Range:=Selection.Range Selection.TypeText Text:=MyText How do I prevent the wdPaneComments pane from opening. The ActiveWindow.ActivePane.close, works but flashes the screen. Please help. Thanks. Tag: Nonmodal user form focus Tag: 76605
  - 2
    - how do i add items in the drop down box using Visual basic? HI all Can anyone tell me how do i use vb to add items in the dropdown box as i am making a form and using control toolbox to create a drop down. please Help!!!!!!!!!!!! Tag: Nonmodal user form focus Tag: 76596
  - 3
    - Repost: PDF four versions of a document then delete interim saved Word files I posted this the other day but it seems to have fallen off the radar screens because of the weekend. Thanks Mike So I'm working on this template and the client wants it to have the ability to make PDFs of four different versions of the same document... basically changing the logo to reflect the different businesses that are part of the corporation. Okay, I've got that all set up. A couple things are challenging me, though. 1. I've got a button the user can click to generate the four different PDFs. In order to do so, I have to give the document a different file name for each one, otherwise when I create the PDFs it would just overwrite the same PDF file and I'd only end up with one. So I modify the filename and do a "Save As..." and everything's cool. However, I'm unable to pass the path to the Acrobat Distiller printer so I have to have the user manually browse to the directory where the PDF files should be saved. Anyone know of a way I can programmatically pass the appropriate path to the Acrobat Distiller print dialog? Of course, I'd rather not have to have the Acrobat Distiller print dialog display at all but it doesn't seem there's a way to just have it all happen under the hood. Any pointers would be welcome. 2. Because I'm doing the "Save As...", I'm ending up with four separate .DOC files. When I create the file I initially save it with a compound filename, consisting of a filename string the user provides (I put up a dialog box requiring the user to enter a filename) with a string representing the initial logo. So, for example, the initial file might be named "Document1-logo1.doc". When I go through the PDF process, I modify the filename to reflect the change of the logo and do a "Save As...", ending up with three other files... "Document1-logo2.doc", "Document1-logo3.doc" and "Document1-logo4.doc". So the process is as follows: *Create "Document1-logo1.doc" *Print "Document1-logo1.doc" to Acrobat Distiller printer, yielding the default filename of "Document1-logo1.pdf" *Save as "Document1-logo2.doc" *Print "Document1-logo2.doc" to Acrobat Distiller printer, yielding the default filename of "Document1-logo2.pdf" *Save as "Document1-logo3.doc" *Print "Document1-logo3.doc" to Acrobat Distiller printer, yielding the default filename of "Document1-logo3.pdf" *Save as "Document1-logo4.doc" *Print "Document1-logo4.doc" to Acrobat Distiller printer, yielding the default filename of "Document1-logo4.pdf" The client wants the process to end up with only the original file ("Document1-logo1.doc"), so I need to delete "Document1-logo2.doc", "Document1-logo3.doc" and "Document1-logo4.doc". I store the fully-qualified filenames that I've used as strings named "killfile1", "killfile2" and "killfile3" but when I attempt to delete the files using the language "kill killfile1" I get a "Runtime error '70', Permission denied". So it appears that I've got the instruction correct but there's something that prevents me from actually deleting the file. So my second question is how do I avoid the "Runtime error '70', Permission denied"? Or is there a way I can pass the preferred PDF filename and path directly to the Acrobat Distiller printer driver so I never have to do a "Save As..." to the Word document?? 3. When I create the file initially, the filename I use is constructed from user input (from the example above, the user would have typed "Document1" in the dialog box I put up) with a representative logo string ("-logo1"). If, at some point in the future, the user wants to revise the document, they'll open "Document1-logo1.doc". Now I have a problem because I don't have a user-entered string stored ("Document1"). So if they then click the PDF button, they end up with: "Document1-logo1.doc" "Document1-logo1.pdf" "Document1-logo1-logo2.doc" "Document1-logo1-logo2.pdf" "Document1-logo1-logo3.doc" "Document1-logo1-logo3.pdf" "Document1-logo1-logo4.doc" "Document1-logo1-logo4.pdf" And my file deletion code fails because it's never able to construct the proper "killfile1", "killfile2" and "killfile3" strings. <arggh> Any suggestions?? Thanks Mike -- Mike Starr WriteStarr Information Services Technical Writer - Online Help Developer - Technical Illustrator Graphic Designer - Desktop Publisher - MS Office Expert (262) 694-1028 - mike@writestarr.com - http://www.writestarr.com -- -- Mike Starr WriteStarr Information Services Technical Writer - Online Help Developer - Technical Illustrator Graphic Designer - Desktop Publisher - MS Office Expert (262) 694-1028 - mike@writestarr.com - http://www.writestarr.com Tag: Nonmodal user form focus Tag: 76595
  - 4
    - Word should have a temp file like cookies for unsaved documents. I do IT support for NDSU. One of the people I was helping yesterday had her laptop loose power. She didn't save her document and lost 15 pages she had typed. If there was a stored temp file for each document typed something like this could be retreved. It could save itself in a directory called temp and label as doc0001, and the next doc0002. It could save over itself say every 10 seconds. ---------------- 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=d571a30f-a9b5-4a8e-81c3-d2822710b20d&dg=microsoft.public.word.vba.general Tag: Nonmodal user form focus Tag: 76585
  - 5
    - Programming Books for Word Having just finished Powerful PowerPoint for Educators, I now want to learn more about VBA for all of the MS Office applications by starting out with learning VBA for MS Word. I am looking for a good book for a beginner who is a step by step type of learner. The book needs to have examples and exercises to do. Thanks, -- Bonnie Tag: Nonmodal user form focus Tag: 76583
  - 6
    - dialogue response Hello everyone, I have a word document that has a macro attached to it, inside the macro i open a form and want to send the response (0 or 1) back to my main module but i don't know how to do this. In vb.net you can say openDialogue and then set the dialogueResponse which will hand the response back to your main form.. i don't know how to do it in VBA... can someone please help? Thanks, Erin Tag: Nonmodal user form focus Tag: 76582
  - 7
    - Browse for a specific path Is there a way to capture a directory location for use later in a macro? I'm looking for the ability to create a button similar to the MODIFY... button on the File Locations tab of the Options dialog box. I will be the only person who uses this code. Basically, I want to create a UserForm that I will use to Save my documents to 3 separate locations simultaneously. I have a macro that does this already, but I can't change the locations for different documents. I want to make it more flexible by giving myself the option to override the default save locations. Ultimately, I hope to use a naming convention to have documents with specific prefixes save to specific directories, but I've got a lot of work and learning to do to get there. Thanks, -- tj Tag: Nonmodal user form focus Tag: 76573
  - 8
    - Help: Overriding Words built-in-function Hi there, what is the MacroName for the function, found in the toolbar, to insert a table and select the desired number of rows and columns by dragging the mouse? I need to override that macro in order to set the checkbox .AllowAutoFit = False (It is True by default) when a new table is created that way. I have succeeded in overriding the Macro TableInsertTable in the desired template. I can set .AllowAutoFit = False which is the desired behaviour. It looks like this: Sub TableInsertTable () With Dialogs(wdDialogTableInsertTable) If .Show = -1 Then Selection.Tables(1).AllowAutoFit = False End If End With End Sub TIA, Peeter Tag: Nonmodal user form focus Tag: 76572
  - 9
    - Need macro to erase data when field is changed I've a document with fields in a protected section and a table for approvals in an unprotected section. When the 'Version' field is changed, I want some of the cells in the approvals tables to be cleared. This is to prevent an updated document slipping through without being re-approved. I'll also need a message box to warn people what will happen if they play around with the field. I'm not very good with Word macros so your help is greatly appreciated. -- Linda M Tag: Nonmodal user form focus Tag: 76571
  - 10
    - Works in 97 but not in 2003 The following macro works in 97 but not in 2003: > Sub QuotesWf() > > ' QuotesWf Macro > ' Macro recorded 08/14/02 by John Doue > > Selection.Find.ClearFormatting > Selection.Find.Replacement.ClearFormatting > With Selection.Find > .Text = "^0147^0148<" > .Replacement.Text = "^0171 " > .Forward = True > .Wrap = wdFindContinue > .Format = False > .MatchCase = False > .MatchWholeWord = False > .MatchWildcards = True > .MatchSoundsLike = False > .MatchAllWordForms = False > End With > Selection.Find.Execute Replace:=wdReplaceAll > With Selection.Find > .Text = ">^0147^0148" > .Replacement.Text = " ^0187" > .Forward = True > .Wrap = wdFindContinue > .Format = False > .MatchCase = False > .MatchWholeWord = False > .MatchWildcards = True > .MatchSoundsLike = False > .MatchAllWordForms = False > End With > Selection.Find.Execute Replace:=wdReplaceAll > End Sub It replaces instances of open-close curly quotes by the appropriate quote in French text (my TA software goofs here and I end-up, instead of an open-quote French character at the beginning of a quote, with open-close English curly characters). Any idea how to solve the problem? Thanks -- John Doue Tag: Nonmodal user form focus Tag: 76570
  - 11
    - How to build a delay into a code Hi I'd like to pause a Winword macro until a specific time. I tried something like Application.Wait Now + TimeValue("00:00:10") and it came with the compilation error "Method or data member not found". Is it only for Excel? Besides, this seems to be a busy wait which blocks the PC, which I have to avoid, because it will run on a Terminal Server. Why "Application.Wait" doesn't work and what is a better way to build a delay in the code? TIA Alex Tag: Nonmodal user form focus Tag: 76565
  - 12
    - Append range to document Hi, I want to append the content of a range to a document, including all formatting. The problem is I can't use the clipboard for this. Can this be done and how? Merijn Tag: Nonmodal user form focus Tag: 76562
  - 13
    - How to Fill the Labels in Mailling Label. Hi, i am using following code to fill the Conatct deatils in the Labeles. addr = "Dave Edson" & vbCr & "123 Skye St." _ & vbCr & "Our Town, WA 98004" Application.MailingLabel.CreateNewDocument _ Name:="2160 mini", Address:=addr, ExtractAddress:=False But it places Same Addrerss Details in all the Labels of the Document. But i have a set of Contact Details, Each Contact Details should go to each Label.I really do not know how to Pass the Different contct details...to each Label. Can any one help me to do this. Thanks in Advance, Thiru ------------------------------------------------------------------------- If you are not contributing to future, Future will not for you.... Tag: Nonmodal user form focus Tag: 76559
  - 14
    - Auto running of a macro I have a macro to update all fields in a document. The fields come from the file>properties section. What I want to happen is for the fields to update (ie the macro to run) when the properties form is OK'd. Currently I can only get it to work using the windowActivate event which means you have to select another window first then select back again. Is there an easy way to make this happen. If not is there a way I can create a toolbar button that keeps with the template and doesnt disappear. (I have already tried the button option but it keeps disappearing if I press the button or if I open up a document from the template. The only way to make it reappear is to go back to customise) Tag: Nonmodal user form focus Tag: 76556
  - 15
    - Programming Word Form Fields I have created a document with form fields and have been trying to unsuccessfully use the code in kb article 211219 to make the enter key behave like the tab key. I also have an area where credit card info will be entered and have set each number up as separate fields ie 16 as the client wishes to show a line between each number. In this area I would like to have the user type a number key and have the insertion point automatically move to the next field. I am very familiar with MS Access and VBA, but am struggling with word objects. I am using Word 2003. Tag: Nonmodal user form focus Tag: 76540
  - 16
    - Protect Form I created from using option button. I protected form. So I can only type the filed information and select option button. I placed this file on the server. But other user can't select option button. totally protected. I only protected from, so people can select option button. From my computer, it's working, But if the file is pulled out from the other computer, it's totally protect, people even can't select option button. Tag: Nonmodal user form focus Tag: 76539
  - 17
    - Disk is full error I have a Word document which contains a macro to update the entire document, which is connected to a toolbar button. The macro is as follows: Sub UpdateDocument() ' ' Macro1 Macro ' Macro recorded 8/25/2005 by mark ' Dim pRange As Word.Range For Each pRange In ActiveDocument.StoryRanges Do Until pRange Is Nothing pRange.Fields.Update Set pRange = pRange.NextStoryRange Loop Next End Sub When I run this macro it goes through the entire document, including the headers and footers, and updates all of the fields. In this document all of the headers are the same and I have a single fill-in field in the header in the first section (it contains several sections, but the headers are all set as "Same as Previous"). Therefore it asks me what I want to fill-in the field with. Every once in awhile it will ask me twice, which I think is odd because there is only one of these fields in the header. Then after I do this I try to save and it gives me an error that the disk is full (which it definitely is not). The error message is as follows: The disk is full. Free some space on this drive, or save the document on another disk. Try one or more of the following: *Close any unneeded documents, programs, and windows. *Save the document on another disk. I have tried these solutions and it still doesn't save. Can anyone help me with this? Thank you in advance, Mark64 Tag: Nonmodal user form focus Tag: 76533
  - 18
    - How to position multiple DOC windows I am quite new to VBA, yet I'm hopefull that there is an easy way to open and postion multiple word documents throughout a dual monitor desktop (after a Word crash etc). I'm working with 10 files covering 5 languages. I'm thinking either by somehow 'remembering' the last displayed position of each document, or maybe reading path/filenames and desired position from a word table or text data file. Please help... Tag: Nonmodal user form focus Tag: 76527
  - 19
    - Macro Question: Syntax Error (Long) I previously posted this to the Microsoft Communities: _____________________ When I open a previously saved file and cancel options to enter a new number and form name, a debugging error message comes up (Run-time error â??4605â??). When the "end" option within that dialog box is selected, my cursor is placed within the header instead of in the document, and when I close out of the header/footer toolbar, Iâ??m taken back to the document, but the entire document is selected instead of me simply being within a certain cell or row. This debugging error does not happen when the form is being created as normal; this is only an issue when previously saved forms are opened to be edited. When the "debug" option within that dialog box is selected, I am taken into the Visual Basic editor and show the following macro: * * * * * * Sub AutoOpen() Selection.HomeKey Unit:=wdStory Selection.WholeStory Selection.Fields.Update If ActiveWindow.View.SplitSpecial <> wdPaneNone Then ActiveWindow.Panes(2).Close End If If ActiveWindow.ActivePane.View.Type = wdNormalView Or ActiveWindow. _ ActivePane.View.Type = wdOutlineView Or ActiveWindow.ActivePane.View.Type _ = wdMasterView Then ActiveWindow.ActivePane.View.Type = wdPageView End If ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader ActiveWindow.ActivePane.View.NextHeaderFooter Selection.WholeStory Selection.Fields.Update ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument Selection.HomeKey Unit:=wdStory End Sub * * * * * * The macro bombs out at â??ActiveWindow.ActivePane.View.NextHeaderFooter.â?? ________________________________ The answer I received was to change the coding to this: Sub AutoOpen() Selection.HomeKey Unit:=wdStory Selection.WholeStory Selection.Fields.Update If ActiveWindow.View.SplitSpecial <> wdPaneNone Then ActiveWindow.Panes(2).Close End If If ActiveWindow.ActivePane.View.Type = wdNormalView Or ActiveWindow. _ ActivePane.View.Type = wdOutlineView Or ActiveWindow.ActivePane.View.Type _ = wdMasterView Then ActiveWindow.ActivePane.View.Type = wdPageView End If ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader On Error resume next ActiveWindow.ActivePane.View.NextHeaderFooter If err.number = 0 then on error goto 0 Selection.WholeStory Selection.Fields.Update End iF on error goto 0 ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument Selection.HomeKey Unit:=wdStory End Sub I did this, however, the new code works fine when functioning only with Word, but when the code tries to execute via an Access macro, we receive a â??Compile error: Syntax errorâ?? message. I believe the line â??ActiveWindow.ActivePane.View.NextHeaderFooterâ?? generates this message. This Word macro runs via a macro initialized by a â??buttonâ?? inside an Access file. The Access macro is responsible for opening the Word document that will be utilized. The Word document is not opened prior to running the Access macro. Any help would be greatly appreciated. Tag: Nonmodal user form focus Tag: 76526
  - 20
    - after using spell check from vb6 not close properly normal.dot I am ussing spell check of word 2002 in our VB project. Its works fine when running first time but 2nd time display a error message that error in your 'normal.dot' file, please give me solution on 'ansar_m@hotmail.com' or 'ansarmah@gmail.com' my codes are Private Sub Command1_Click() Dim oWord As Object Dim oTmpDoc As Object Dim lOrigTop As Long ' Create a Word document object... Set oWord = CreateObject("Word.Application") Set oTmpDoc = oWord.Documents.Add oWord.Visible = True ' Position Word off screen to avoid having document visible... lOrigTop = oWord.Top oWord.WindowState = 0 oWord.Top = -3000 ' copy the contents of the text box to the clipboard Text1.SelStart = 0 Text1.SelLength = Len(Text1.Text) Clipboard.Clear Clipboard.SetText Text1.SelText ' Assign the text to the document and check spelling... With oTmpDoc .Content.Paste .Activate .CheckSpelling ' After user has made changes, use the clipboard to ' transfer the contents back to the text box .Content.Copy Text1.Text = Clipboard.GetText(vbCFText) ' Close the document and exit Word... .Saved = True .Close End With Set oTmpDoc = Nothing oWord.Top = lOrigTop oWord.quit Set oWord = Nothing End Sub Tag: Nonmodal user form focus Tag: 76524
  - 21
    - How macro can do printscrn of other application and paste in word I am trying to create a macro in word to do a printscreen in toad and paste it in word. Is it possible to get the events of toad application captured in word macro. Thanks Tag: Nonmodal user form focus Tag: 76520
  - 22
    - Change first space in each paragraph to a tab Does anyone have a simple macro that will change the first space in each paragraph to a tab? Greatly appreciate some help with this. Tag: Nonmodal user form focus Tag: 76515
  - 23
    - Automatically update field Hello, I have a document with several custom properties that we've added such as 'Client'. Using VBA we prompt for the value of the custom property and update it using ActiveDocument.CustomDocumentProperties("Client").Value = "Name" This all works great and the new value for the custom property is saved. However, the field in the document header linked to this custom property does not get updated. Is there any way to automatically update the field linked to this custom property? Right now the user has to edit the document and use "Update field" to update the field with the new value for the custom property. Thanks, Russ Tag: Nonmodal user form focus Tag: 76511
  - 24
    - determine is text was typed in or pasted into a document Is it possible to determine if the text in a document was pasted in from another source or typed in letter by letter? I have a word document and I want to find out if this person wrote it themselves or copy and pasted it into the document. I'm thinking maybe a 3rd party software that could do this or something... Hopefully someone out there can point me in the right direction. Thanks Andy Tag: Nonmodal user form focus Tag: 76508
  - 25
    - You really need to improve both your auto correct feature.... How can you even consider that your auto-correct feature, or the thesaurus are up to par if it does not include even the simplest of words such as adelpated? ---------------- 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=206a49cc-2053-4e7d-9835-a0269c6c4837&dg=microsoft.public.word.vba.general Tag: Nonmodal user form focus Tag: 76507

And while I'm asking questions about user forms with ShowModal set to False,
how do I detect when the user has activated another window (the user form has
lost focus) and when the user returns to the user form?

Bear

Top

Re: Nonmodal user form focus by Jezebel

Jezebel
Wed Nov 16 19:28:22 CST 2005

Write code for the form's Activate and Deactivate events.

"Bear" <Bear@discussions.microsoft.com> wrote in message
news:6443FB75-B119-4018-BD70-4EC89914AC94@microsoft.com...
> And while I'm asking questions about user forms with ShowModal set to
> False,
> how do I detect when the user has activated another window (the user form
> has
> lost focus) and when the user returns to the user form?
>
> Bear

Top

Re: Nonmodal user form focus by Bear

Bear
Thu Nov 17 08:41:04 CST 2005

Jezebel:

(Word 2000, Windows XP)

Maybe I'm testing this wrongly, but putting a simple MsgBox in the Activate
and Deactivate events does nothing. Well, the activate message box is
displayed when the form is initially shown. But switching between the
document and the user form (by clicking in one or the other) has no effect.

What am I doing wrong?

Bear

Top

RE: Nonmodal user form focus by Bear

Bear
Tue Dec 13 11:20:04 CST 2005

Just to bring this thread up to date with what I've discovered.

There is no way to detect when a modeless userform gains or loses focus. I
found out how to determine the caption of the active window, using the
Windows API. But that's a far cry from a working activate and deactivate
event that treats the userform as a separtate window.

Bear

Top