UserForm Data Capture in Word

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - GetSpellingSuggestions -- 9132 Hello, I have successfully used the wdWildcard and wdAnagrams constant with the SuggestionMode argument for the GetSpellingSuggestions method for Word in Office 98. But these constants cannot be used with Word 2000 and Word 2003 (see: http://support.microsoft.com/default.aspx?scid=kb;en-us;224722 ). Is there any way I can use the dll and other files from Office 98 to beef-up my Word 2003 so that I get support for these constants? If so, how? Thanks, --Suresh Tag: UserForm Data Capture in Word Tag: 66546
  - 2
    - big corner red X in Word Make the big red X close all windows like it used to. Tag: UserForm Data Capture in Word Tag: 66544
  - 3
    - Problem with previous post re: individual footers for each copy ma I asked the question Friday if I could create a macro that would print 3 copies of a one page document with each copy having different footer text. Greg instructed me on the macro and it worked great. The problem I am having is that the document has form fields in it, and when the document form field are protected and the macro is run I get an error with no text. I assume it's because of the protection. How can I avoid the error from appearing while still having the document protected? Tag: UserForm Data Capture in Word Tag: 66543
  - 4
    - Create submit button to trx to Access I have created a form in word and would like a "Submit Data" button to transfer all the data from the form to an access table in a database. I'm being a bit adventurous as I am a new user and have no idea where to begin. Can anyone help me through step by step? Tag: UserForm Data Capture in Word Tag: 66538
  - 5
    - Bookmark Hi, Each paragraph in my document is a bookmark: Paragraph 1 = bm1 Paragraph 2 = bm2 Paragraph 3 = bm3 ... The user can delete paragraph. This mean that paragraph numer 4 not necessarily means bm4. It could be bm2. When I click a button, I want the macro to show me in which bookmark I clicked in and show a messagebox that correspond with that bookmark. How is this done? / Ulf Tag: UserForm Data Capture in Word Tag: 66531
  - 6
    - Syntax doubt - Find and Replace Hi, Some time back I had a requirement where I had to REPLACE some text in EACH PAGE of the MAIN STORY IN MS Word. The text was of the form -- Page 83 -- or -- Page 62-- and so on and the replacement text was the related to the actual word page number. The below macro I got from NG for this purpose works great. Only change is that previously I had to find and replace text with 2 digit numbers following "Page ". But now I want to be able to replace 3 digit numbers also. I have tried changing the syntax -- .Text = "Page [0-9]{1,2}" -- to -- .Text = "Page [0-9]{1,2,3}" -- thinking that this would extend the search to one more character, but Im getting -- Runtime error '5560': The find what text contains a pattern match expression which is not valid.-- and the above error occurs at the -- .Execute Replace:=wdReplaceAll--. Strangely if I change it to .Text = "Page [0-9]{3}" -- then am able to get it working (that is am able to search for -- Page 768 -- and replace it with the desired text). Why is it that .Text = "Page [0-9]{1,2}" works well for finding -- Page 83 -- or -- Page 62-- but .Text = "Page [0-9]{1,2,3}" -- gives syntax error. Isnt the number within the squiggly bracket meant to indicate the extent of the search? Thanks a lot, Hari India Sub ReWritingPageNumbersByHelmutWeber() 'Swiped from NG by Hari Prasadh ResetSearch Dim lPgs As Long Dim lTmp As Long lPgs = Selection.Information(wdNumberOfPagesInDocument) For lTmp = 777 To lPgs Selection.GoTo _ what:=wdGoToPage, _ which:=wdGoToAbsolute, _ Count:=lTmp Selection.Bookmarks("\page").Select With Selection.Find .Text = "Page [0-9]{1,2}" .Replacement.Text = "Page " & lTmp - 20 .Wrap = wdFindStop .MatchWildcards = True .Execute Replace:=wdReplaceAll End With Next ResetSearch End Sub '--- Public Sub ResetSearch() With Selection.Find .ClearFormatting .Replacement.ClearFormatting .Text = "" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False ' plus some more .Execute End With End Sub Tag: UserForm Data Capture in Word Tag: 66528
  - 7
    - How do I create text that if you type within it it will be repaced Hi guys, I'm trying to create a word docment with a series of "blank" areas in it. At present they just have pink writing within them. I am looking now at being able to label these blank areas. I.E what powerpoint does with its faded text when you insert a text box. So that it will say for example "Insert Date here" then when a user puts the date in it will remove the string of text and replace it with what ever has been typed. Anythoughts would be greatly appriciated. cheers, steve Tag: UserForm Data Capture in Word Tag: 66525
  - 8
    - does anybody know optical character recognition? I am trying to find out how to scan a form into OCR. Do anybody know how? Tag: UserForm Data Capture in Word Tag: 66518
  - 9
    - Fixed Size Table Hello I use C++ to automate Word. Here is the code to insert a table with 1 row and 1 column BOOL CAutoWordDlg::AddCoverPage( Selection WordSelection) { WordSelection.TypeParagraph(); Range WordRange = WordSelection.GetRange(); WordRange.Collapse( vtCollapseEnd); Tables WordTables = WordSelection.GetTables(); Table WordTable = WordTables.Add( WordRange, 1, 1, vtFalse, vtTrue); } The parameters of the Add function allows the AutoFit of the table ... OK but I would like to set a fixed size for this table, say 80% of the page with and 80 % of the page height. Is it possible to do this ? Thanks for your help Thierry Tag: UserForm Data Capture in Word Tag: 66515
  - 10
    - Is their any way to automacically copy text in Word from one page. Is their any way to automacically copy text in Word from one page to another, or from one document to another Tag: UserForm Data Capture in Word Tag: 66511
  - 11
    - new document counter: how to change? Hello, I want to change default name for new document (like "Doc1", "Doc2", ... in Polish and German version it is "Dokument1", "Dokument2"). Is it possible? I need it, because my VBA application creates one "hidden" document for each newly created document. So, user creates first document ("Dokument1") and one hidden, linked to first one, is created (not visible, but it uses name "Dokument2"). Then, user closes document ("Dokument1") - automatically hidden document ("Dokument2") is closed - and creates second one. He is suprised, that its name is "Dokument3" (should be "Dokument2"). Is there any property to set counter of documents? Regards, Tomasz Swedrowski Tag: UserForm Data Capture in Word Tag: 66510
  - 12
    - Fax programming via Ole automation for sending faxes over a LAN enviroment I search lot of time for the best fax program with candy COM interface for send faxes from my APP, over the LAN... I would apreciate some confesions/comments via email about this... Thanks from Cordoba, Spain !! ........ Tag: UserForm Data Capture in Word Tag: 66508
  - 13
    - Registry setting for Proof directory? Options.DefaultFilePath(wdProofingToolsPath) returns \program files\common files\microsoft shared\proof Is there a registry setting, or some other means, to get a pointer to \Documents and Settings\username\Application Data\Microsoft\Proof when there are no custom dictionaries? -- http://www.standards.com/; See Howard Kaikow's web site. Tag: UserForm Data Capture in Word Tag: 66507
  - 14
    - AutoText fields inserting as static text Program: Word 2003 Not sure how to describe this correctly, but when one of our users inserts an AutoText entry that contains a field code, such as Filename and Path or a date field, Word is inserting the *text* of the code, i.e. _ FILENAME \p _ (except there are boxes instead of "_"). I've made sure the user's language is set to English, but I'm not sure where else to begin with this problem. It's as though Word is not inserting the brackets enclosing the code, or it's automatically unlinking the field. Where the brackets should be enclosing the code, there are the boxes Word usually inserts for characters not included in a font set. So the code for pathnames and dates are inserted but not a working field code. Where the pathname should be, you just see the pathname code text in the document and that's how it prints (even when unchecking any options that cause the field code to print or be viewed in the document). I'm at a loss and am hoping for a resolution other than reinstallation. OTOH, the user *can* insert both the date field and pathname via Insert -> Field. Claudia Tag: UserForm Data Capture in Word Tag: 66496
  - 15
    - Auto Fill Contracts In a contract I have the same name appearing over and over on the signature pages. How can I type it in once and have it copied throughout the document? Tag: UserForm Data Capture in Word Tag: 66494
  - 16
    - delete section breaks Hi, for word xp, how could i delete all the section breaks in a document in vba? thank you, william. -- Tag: UserForm Data Capture in Word Tag: 66493
  - 17
    - Strange Delineation of Sentences Consider the a document containing only: John Doe, Ph.D., is a scientist. As expected, "ActiveDocument.Words(1).Text" return "John". However, "ActiveDocument.Sentences(1).Text" returns "," and the second sentence is returned as "is a scientist". Is this a bug? Am I missing something here? Tag: UserForm Data Capture in Word Tag: 66489
  - 18
    - How do I hide information in a Word document for different docume. Our team would like to create information once and use it throughout multiple versions of a document. Since we did not receive approval for a CMS, I am trying to optimize Word 2003 to gain us the same benefits. I guess you call it applying conditions to text. Thanks! Tag: UserForm Data Capture in Word Tag: 66488
  - 19
    - Merging Two documents and have them print duplex as one document Here is what I need to do - I have a word document with several pages (grade reports), usually in the thousands. Each page is a separate grade report. I have a generic letter that I would like to print out on the back of each grade report (duplex printing). How can I add this generic letter to the back of each of the grade report? Is there a way to do this without using a macro...and if not how can I do it with a macro? Thanks. Tag: UserForm Data Capture in Word Tag: 66483
  - 20
    - Specify Number of copies and individual footer for each copy. I have a document that I need to print exactly 3 copies of. On each copy I want a different footer, like "Customer Copy", "Our Copy", "File Copy". How can I do this programatically? Tag: UserForm Data Capture in Word Tag: 66480
  - 21
    - Spelling suggetsions in Word should be in reverse order. In MS Word: When you right-click over an incorrectly spelt word, the spelling suggestions should list the most likely word closer to the mouse; the list should begin with the least likely suggestion and end with the most likely. Reversing the order that the words are currently listed in would make this feature more convenient. Tag: UserForm Data Capture in Word Tag: 66473
  - 22
    - Spelling suggetsions in Word should be in reverse order. In MS Word: When you right-click over an incorrectly spelt word, the spelling suggestions should list the most likely word closer to the mouse; the list should begin with the least likely suggestion and end with the most likely. Reversing the order that the words are currently listed in would make this feature more convenient. Tag: UserForm Data Capture in Word Tag: 66472
  - 23
    - Find/Replace of Phrases: How to Avoid Nesting? I need to run a series of find and replace operations on phrases. The idea is to standardize the wording of phrases but I am having trouble avoiding "nesting". Consider the following phrases that might be found in my document: Research Data Sharing Data Sharing I want to replace instances of "Data Sharing" with "Research Data Sharing". The desired result should be: Research Data Sharing Research Data Sharing However, if I do a search and replace, searching for "Data Sharing" and replacing with "Research Data Sharing" the text would become: Research Research Data Sharing Research Data Sharing How can I avoid this "nesting"? Thanks! Tag: UserForm Data Capture in Word Tag: 66469
  - 24
    - Can I force a SAVE Hi I have designed some Word userform templates (based on Word 2000) and I am wondering if I can force people to Save a document as soon as it has been generated, and before they begin to add additional text to the document etc. I am very much a newbie, so if this is possible, I would appreciate lots of detail on how to please! Sample code would be even better! Thanks Dave Tag: UserForm Data Capture in Word Tag: 66466
  - 25
    - Delete tables in the page footer I have two tables in the page footer and want to delete one of these, depending on what optionbox in the form is selected This code is not working so I need something similar.? ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader Selection.GoTo What:=wdGoToBookmark, Name:="bSidfStrategic" With ActiveDocument.Bookmarks .DefaultSorting = wdSortByName .ShowHidden = False End With Selection.Tables(2).Select Selection.Tables(2).Select Selection.Tables(2).Delete Selection.Delete Unit:=wdCharacter, Count:=1 Tag: UserForm Data Capture in Word Tag: 66451
- Next
  - 1
    - adressing cells in table Dear experts, how can I select a cell in a table, some cells of which are 'connected' in the column next to it? The error message reads that an addressing of any cell is not feasible in a table whose cells are connected in any of its columns. But my selection confines itself to only one column, where the number of rows and cells should always be well-defined. Thank you Martin Tag: UserForm Data Capture in Word Tag: 66449
  - 2
    - Need help in Find and Replace function I have a large Word document and I need to Find certain text and Replace it with a pre-defined bookmark. How? Thanks. Tag: UserForm Data Capture in Word Tag: 66444
  - 3
    - Create User form I'd like to create a form to e-mail to users so that when they type in the spaces provided, the text behind their input does not move. Tag: UserForm Data Capture in Word Tag: 66440
  - 4
    - Can't believe they did this? Easy way to fix? This table looked rather odd. On closer inspection, it was not a table, but totally created from individual drawing objects!! Each cell is its own text box, and each border is a separate line! Anyone got a rabbit in their hat for fixing this and making it a real table? Ed Tag: UserForm Data Capture in Word Tag: 66439
  - 5
    - Macro to format pictures Hi, I find that I often need to copy pictures (for example screen prints) to Word and then format them. Often I use the same formatting over and over. I'd like to write a macro to do this for me. Unfortunately I'm not very familiar with the Word object model. I found the "crop" functions in the PictureFormat object. I haven't yet found the "Size" (I'd often like 100%) or the "in front of text" type options. Can anyone give me a hint as to where to look - or even if this is possible? Thanks, Art Tag: UserForm Data Capture in Word Tag: 66436
  - 6
    - Delete 'filename and path' field from footer Hi There, I want to create a macro which deletes the field (File name and Path- FILENAME \p ) from footer and then insert my customized footer. I donâ??t know how to delete this fields I tried many different ways but none work properly please help. thanks! ---------- If WordBasic.ViewFooter() = 0 Then 'Go to footer area WordBasic.ViewFooter End If 'This will clear the contents of the previous Footer WordBasic.EditSelectAll WordBasic.EditCut ------------- ' this doesnt work ?????? FooterAField = NormalTemplate.AutoTextEntries("Filename and path") If FooterAField = 1 Then 'Marker exists, Delete it NormalTemplate.AutoTextEntries("Filename and path").Delete End If Tag: UserForm Data Capture in Word Tag: 66435
  - 7
    - How do I calculate a duration of time in Word using form fields? I have three form fields that are bookmarked ... [start_date], [stop_date] and [duration_months]. Both dates are text form fields of "Date" type and formatted "mm/yy". [Duration_months] is a text form field of "Calculation" type with the expression "= datedif [stop] [start],m", length "Unlimited" and number format "0". The [Duration_months] field is returning the character "t". Example: [start_date] = 02/05 [stop_date] = 10/05 [duration_months] should come up with 8 Any help would be greatly appreciated!! Tag: UserForm Data Capture in Word Tag: 66426
  - 8
    - How do I permanently retain autotext entries? An autotext entry entered and supposedly saved has disappeared from my autotext twice now. After the second "disappearance" I deleted many outdated and unused entries, thinking I had reached the storage capacity for Autotext. Lost the entry once again today, and discovered that at least two of the entries deleted yesterday appeared once again. Does anyone have an explanation? And how can I correct this? Tag: UserForm Data Capture in Word Tag: 66425
  - 9
    - 5149: the measurement must be between 1584 and -1584 Hi All, The error message is coming up when a macro is run on word 2003 on XP Professional.Works fine on some machines and failes on others with the same configuration. the macro is: Any ideas? I have marked the error with : the error is here!!!!!!!!!!!!!!!!! Thanks mskinnerNOSPAM@intellisoftgroup.com //////////////////////////////////// Sub SaveFiles() 'Defsgn A - Z Dim li_top_margin As Single Dim li_left_margin As Single Dim li_right_margin As Single Dim li_bottom_margin As Single Set fs = CreateObject("Scripting.FileSystemObject") If Not fs.FolderExists("c:\intellicred\fax\") Then MsgBox ("The folder c:\intellicred\fax\ does not exist. This must be created") Exit Sub End If ChangeFileOpenDirectory "C:\intellicred\fax\" ActiveDocument.SaveAs FileName:="main.doc" li_top_margin = ActiveDocument.PageSetup.TopMargin li_bottom_margin = ActiveDocument.PageSetup.BottomMargin li_left_margin = ActiveDocument.PageSetup.LeftMargin li_right_margin = ActiveDocument.PageSetup.RightMargin With ActiveDocument.MailMerge .DataSource.FirstRecord = 1 .DataSource.LastRecord = 100000 .Destination = wdSendToNewDocument .SuppressBlankLines = True .Execute End With Documents(1).Activate ActiveDocument.SaveAs FileName:="mergeddoc.doc" Documents("main.doc").Activate ActiveDocument.Repaginate li_main_doc_page_cnt = ActiveDocument.BuiltInDocumentProperties(wdPropertyPages) Documents("mergeddoc.doc").Activate 'Used to set criteria for moving through the document by page Application.Browser.Target = wdBrowsePage ActiveDocument.Repaginate 'get the number of pages in the mergedoc li_merge_doc_pages = ActiveDocument.BuiltInDocumentProperties("Number of Pages") p = 0 For i = 1 To li_merge_doc_pages p = p + 1 'For p = 1 To li_main_doc_page_cnt 'go to the MERGE TO document 'Select and copy the text to the clipboard ActiveDocument.Bookmarks("\page").Range.Copy If p = 1 Then DocNum = DocNum + 1 ls_new_doc_name = "fax_" & DocNum & ".doc" Documents.Add ActiveDocument.SaveAs FileName:="fax_" & DocNum & ".doc" ActiveDocument.PageSetup.TopMargin = li_top_margin /// the error is here!!!!!!!!!!!!!!!!!!!! ActiveDocument.PageSetup.BottomMargin = li_bottom_margin ActiveDocument.PageSetup.LeftMargin = li_left_margin ActiveDocument.PageSetup.RightMargin = li_right_margin 'set margins 'With Documents("fax_" & DocNum & ".doc").PageSetup ' .LeftMargin = InchesToPoints(li_left_margin) ' .RightMargin = InchesToPoints(li_right_margin) ' .TopMargin = InchesToPoints(li_top_margin) '.BottomMargin = InchesToPoints(li_bottom_margin) 'End With End If 'Open new document to paste the content of the clipboard into. Documents(ls_new_doc_name).Activate Selection.Paste If p = li_main_doc_page_cnt Then 'Removes the break that is copied at the end of the page, if any. Selection.MoveLeft Unit:=wdCharacter, Count:=1 Selection.Delete Unit:=wdCharacter, Count:=1 Selection.Delete Unit:=wdCharacter, Count:=1 ActiveDocument.Repaginate If ActiveDocument.BuiltInDocumentProperties("Number of Pages") > p Then Selection.TypeBackspace End If End If If p = li_main_doc_page_cnt Then Documents(ls_new_doc_name).Activate ActiveDocument.Save ActiveDocument.Close 'Move the selection to the next page in the document Documents("mergeddoc.doc").Activate p = 0 End If Documents("mergeddoc.doc").Activate Application.Browser.Next 'Next p Next i Documents("mergeddoc.doc").Activate ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges Documents("main.doc").Activate ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges 'Application.Quit _ End Sub /////////////////////////////////// Tag: UserForm Data Capture in Word Tag: 66423
  - 10
    - Missing reference - Word Template - but it's there I have fixed this problem but I'd like to know why it happened. Here goes: I created a document that contains a macro that basically merges the document with a .TXT file. I transferred (if that's the right word) into a new template called "projectabstract.dot". I sent the document to other users along with instructions to save projectabstract.dot into the subdirectory where their other templates were (found by Tools, Options, File Locations). Most of the users did everything right and the macro ran fine. Then I needed to edit the document and the macro and send it out again. This time, some users (all Word97 users) got the message "Compile error: Can't find project or library". When I got them to stop the macro and go to Tools, References, it showed that the projectabstract.dot template file was MISSING. BUT it wasn't. It was in the same place that it had been (I got them to check). They unchecked the missing reference, saved the document and now the macro runs fine. BUT why did it say that the template itself was missing, which was wrong? I'm pretty sure that I sent them another copy of the template and told them to save it again, overwriting the one that was already there. The users I was working with are pretty savvy and usually follow the directions they are given. But if they hadn't replaced projectabstract.dot, could that have made the difference? We will probably be doing other things like this (i.e. one person creates a document/macro and sends it to other users) so I'd like to know which pitfall I fell into. Many thanks. Carol. Tag: UserForm Data Capture in Word Tag: 66421
  - 11
    - How to Access Container from within an ActiveX Control! hi! i have an activex control for Word. i want to send Printing command to my Container(Word) to print itself at specific location from within my ActiveX (My be on clicking some context menu item.) is it possible to do that. if so then plz help me. A sample code will help a lot. Thanks in advance. Ahmad Jalil Qarshi Tag: UserForm Data Capture in Word Tag: 66417
  - 12
    - If Staement question I have a macro Sub Save2() Dim vRefferingPhysician, vDate As String If vRefferingPhysician = "Swain" Then Save Else SaveR End If End Sub when I run the code it will always run the saveR macro, even if the field is swain am I asking the right if question? Thanks Tag: UserForm Data Capture in Word Tag: 66410
  - 13
    - How to detect if autotext entry is showing? Hi, I have defined some autotext entries: when I type some text, the autotext entry is showing, and when I hit Enter the entry is inserted in the document. Now I have created a KeyBinding for the Enter key: when the Enter key is hit, a specific macro is executed. My question is: how can I detect in that macro if the autotext entry is showing? Thanks for help Henk Tag: UserForm Data Capture in Word Tag: 66407
  - 14
    - Custom Document Properties - Writing Too Hi How can i write to a custom document property called TimesPrinted. This document property already exists. Many thanks DMc Tag: UserForm Data Capture in Word Tag: 66396
  - 15
    - How can I reference another project as Normal? i can call normal function, Sub Foo() normalfunc ' normal.normalfunc End Sub But If I reference a project, I only call that like below: Sub Foo() RefProject.testfunc ' Why i must writer RefProject? End Sub Tag: UserForm Data Capture in Word Tag: 66393
  - 16
    - Selecting columns in table gives 5992 error I have used the VB editor in Word 2000 to create a class that adds columns to existing tables and sets text in the new column cells based on the contents of the existing cells in the neighbouring column. To Insert Column: Create column object Select it Insert new column Set oColX = TableX.Columns(lngCol) oColX.Select Selection.InsertColumnsRight All went well till the program encountered a table split over multiple pages. I then got run time error 5992 ..... cannot select.... column has mixed cell widths! So a) how do I con Word into letting me select a column to insert a column after it or b) how do I insert a column where the table is split over a page split? Anybody solved this problem before. Thanks Tag: UserForm Data Capture in Word Tag: 66392
  - 17
    - Documents referencing a ~tmp file ? I have several hundred documents that were created using a VBA template. Occasionally when closing of the documents based on the template, I get the error "This document cannot be closed because it is referenced by an open VBA project. You should close the project that references this document before closing this document." The documents that seem to do this have a weird reference to ~wrc004.tmp etc. How can I remove the references for ALL documents and replace them with the correct one programatically? Why would this be happening? Thanks! Ben Tag: UserForm Data Capture in Word Tag: 66384
  - 18
    - If there's an error then Exit the Sub! Hi, This is simple for all of you but I can't get it to work. Instead of the user seeing a VBA error message, I'd like for the sub to end or for it to skip down a few lines of code. How do I do this? Thanks! Tag: UserForm Data Capture in Word Tag: 66382
  - 19
    - how can i sort a 241 page document in word 2003 please help me out Tag: UserForm Data Capture in Word Tag: 66377
  - 20
    - Table in Word XP Hi all I am looking for some help to fix the following problem. When I create a table in Word, it it possible to add a row by pressing the Tab key when the cursor is in the last cell of the table. I wish to be able to lock up the number of row so that it become impossible to add another row. It would be pactical when many independant table are created in the same document. (I do not want create a form; it is not always the right solution. I never found a solution by using Word "normal" features. Is there a way to do that by using some VBA code? Thank you very much in advance for any advice, help or code. Alain Kadlec Ottawa Tag: UserForm Data Capture in Word Tag: 66376
  - 21
    - FileName on Last Page of Word Doc Hi, Can anyone help me with the code for the following: Open the footer Insert FileName (including path) preferably without the file extension in the footer of the LAST PAGE ONLY left aligned TNR size 8 font Gray color Close the footer I could record a Macro in Word, but it's bulky and I didn't know how to record the "last page only" thing. Thanks very much, Karen VB novice Tag: UserForm Data Capture in Word Tag: 66375
  - 22
    - Need to find the web wizzard in office I have save a document to web and then try to go to web wizzard but can't find it in the list of wizzards in my office 03. Can anyone help Tag: UserForm Data Capture in Word Tag: 66373
  - 23
    - Problem creating Attribute on XMLNode Hi, I'm trying to write some C# code that automates Word to do the following: - Open a document - Attach my custom schema - Search the document for some specific text - When I find the text, create an XML Node that includes an attribute - Save the document in XML format First off, I'm a total rookie at this. But here's a bit of the code I wrote: private void button1_Click(object sender, System.EventArgs e) { object sTokenPattern = "\\<%[A-Za-z.0-9]@%\\>"; object sReplace = ""; object wrap = Word.WdFindWrap.wdFindStop; Word.WdSeekView[] locations = { Word.WdSeekView.wdSeekCurrentPageHeader, Word.WdSeekView.wdSeekCurrentPageFooter, Word.WdSeekView.wdSeekMainDocument }; wordApp.ActiveWindow.View.Type = Word.WdViewType.wdPrintView; for (int x=0; x < locations.Length; x++) { wordApp.ActiveWindow.ActivePane.View.SeekView = locations[x]; bool bFound = true; while (bFound) { bFound = wordApp.Selection.Find.Execute( ref sTokenPattern, // FindText ref bFalse, // MatchCase ref bFalse, // MatchWholeWord ref bTrue, // MatchWildcards ref bFalse, // MatchSoundsLike ref bFalse, // MatchAllWordForms ref bTrue, // Forward ref wrap, // Wrap ref bFalse, // Format ref sReplace, // ReplaceWith ref none, // Replace ref bFalse, // MatchKashida ref bFalse, // MatchDiacritics ref bFalse, // MatchAlefHamza ref bTrue); // MatchControl if (bFound) { String sValue = wordApp.Selection.Text; object ch = Word.WdUnits.wdCharacter; object one = 1; object range = wordApp.Selection.Range; Word.XMLNode tokenNode = wordApp.ActiveDocument.XMLNodes.Add("Token", (string)FCINS, ref range); Word.XMLNode nameAttr = tokenNode.Attributes.Add("tokenName", "", ref missing); nameAttr.NodeValue = sValue; wordApp.Selection.MoveRight(ref ch, ref one, ref bFalse); } } } Now here's my problem. When the location is the main document, everything works fine. But when the location is either the header or the footer, I end up losing my attribute. That is, the code seems to execute just fine, but after saving the document and inspecting the XML, only the nodes that were created in the main document have their attributes. Here's some sample... main doc - <ns0:Token name="<%Common.DisplayName%>"> <w:r> <w:t><%Common.DisplayName%></w:t> </w:r> </ns0:Token> header - <ns0:Token> <== NOTICE MY NAME ATTRIBUTE IS MISSING <w:r> <w:t><%CurrentUser.Name%></w:t> </w:r> </ns0:Token> Am I way off base here? Any advice would be greatly appreciated. -Rob Tag: UserForm Data Capture in Word Tag: 66371
  - 24
    - Insert shape at x, y on page n I want to insert the shape on the last page of a document (whatever page # that may be, it's variable). It's a textbox with some text in it, and it's background is filled with a bitmap of someone's signature - it goes on the last page in the bottom-right corner to "sign" a document. Our users "apply a signature to the document" by clicking a little macro button that does [essentially] this: Dim objYouWereHere as Range Set objYouWereHere = Selection.Range Application.ScreenUpdating = False 'Physically move to the "last page" Selection.EndKey Unit:=wdStory 'Position the signature textbox With ActiveDocument.Shapes("SignatureBox") .Top = 536 .Left = 231 End With 'Return my user to wherever they were prior to running the macro objYouWereHere.Select Application.ScreenUpdating = True I'm not well versed enough in word/vba to know the answer to this; but is it possible to programatically define the last page (maybe as a range?) in such a way that I could insert a shape onto it at an x, y coordinate relative to that page **without** having to move the selection? With the above methodology, the user does end up at wherever they were prior to running the macro, but the objYouWereHere.Select call can sometimes leave them at a new vertical scroll position and it's a little disorienting for them. So, before I go hunting down how to store & retreive the vertical scroll position (similar to how I store and retrieve the selection pre & post textbox adjustment)... is there a more "elegant" way to do this that doesn't require I move the selection at all? Insert shape at x, y on page n, without involving the Selection? Tag: UserForm Data Capture in Word Tag: 66370
  - 25
    - Command Button and Lock I need information on how to add a CommandButton to Word2000 and have it be able to email that form back to the client with a set email address. I would also need to lock that form also. It does not allow me to lock the word document if I put in a CommandButton. -- Message posted via http://www.officekb.com Tag: UserForm Data Capture in Word Tag: 66369

I have designed a UserForm in a word document that has a couple of comboboxs
with drop down lists and a few text boxes. What do I need to do in VBA to
transfer the data the user has entered into specified places in the document?
Am I also able to insert other documents depending on the result of a
combobox?
--
Dave

Top

Re: UserForm Data Capture in Word by Perry

Perry
Mon Apr 11 15:05:09 CDT 2005

This article will suit yr quest
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

Krgrds,
Perry

"Dave" <Dave@discussions.microsoft.com> wrote in message
news:A9EB65B5-462B-45F5-A3ED-316C84583380@microsoft.com...
> I have designed a UserForm in a word document that has a couple of
comboboxs
> with drop down lists and a few text boxes. What do I need to do in VBA
to
> transfer the data the user has entered into specified places in the
document?
> Am I also able to insert other documents depending on the result of a
> combobox?
> --
> Dave

Top