Threads Replies Last Post 10 Pages: 1  2  3  4  5  6  7  8  9  10   Getting data from file into comboboxes and listboxes Hello, My question comes in 3 parts really. I scanned the newsgroup and found some help, but the tips I tried seemed to take a long time. Here goes... I have a template that will be used to generate a letter. Each letter will be addressed to one person, and then have copies to go to others, from none to likely up to 5. I have a userform that opens to ask some other informati... 8 15.02.2006 15:05:44 Need help getting Total in MS Word forms Hi, I'm pulling my hair out (almost) trying to get my form to work. I have 3 columns with the following: Qty1 * Price1 = Amount1 Qty2 * Price2 = Amount2 .... Total = TOTAL (Amount1 + Amount2 +... = TOTAL) The Amounts calculate just fine but when I try and total the Amounts, I get garbage! Am I doing something wrong or is there something wrong wit... 3 10.02.2006 18:51:14 Update Subject document property from Userform Input I have a userform that prompts the user to insert a subject for their memo/letter/fax into textbox4 for example. I would like the subject response to update the Subject of the document properties. I am using the following code wdPropertySubject = TextBox4.Text but get an error message advising the field is a constant when running the code. How do I work around this please or am I u... 5 22.02.2006 15:45:13 How to extract and save Packages from Word Hi guys I am trying ot write a routine in vb.net where in I can read all inline shapes and save them to file. I am able to extract Word,Excel,PDF files but I am unable to extract images and textfiles embedded as Packages in my word document. How Can I ? Plz help me.. Thanks, Sujan... 2 14.02.2006 14:23:26 Unable to print the .dot file 2 times. All, I have a .dot file template with 13 userforms. the user can navigate from each form and key in the details. All the details in all the forms are capturted and kept in the template. My dot file has option for Print DRAFT (This is from File Menu). DRAFT print is the same as the normal print, only difference is that there will be a mark "DRAFT" on first page. Once the user finishes ... 2 14.02.2006 14:21:28 User Form Run Error 5 Hi Anybody help me with this. I have a user form set up that when called within a macro - macro1 - uses the selected word or words in the document and creates a Sub index mark for them. - It displays all the existing main index words in a list box on the form, so the user only needs to select a word an click "ok". - It also checks for a couple of document variables that another macro s... 6 07.02.2006 14:51:52 Long Fill in I have a form that the field I use to capture data is not large enough. I remember seeing a web site that explained how to set it. Ex. like a police report. Does anyone remember the web address. Thanks ... 2 07.02.2006 05:10:23 User Form Error When 2nd Form is Created Hi Any body help me with this. I have a user form that works great - displays index data. - userFrm1 I have created a 2nd form to do something else - userForm2 - this works great but now when i run the macro that uses userForm1 I get a runtime error of '5'. and debug flags the userFrm1.show statement as the source of the error. Form 1 and 2 do not share any data, macros or anything.... 4 06.02.2006 14:41:35 Corrupt spelling in tables The spell checker is working fine in the normal text body of my doc but ONLY SOME of the misspelt words in the tables are not being checked - the ones beside which I have put an asterisk and space as a bulleting mark. I've tried selecting the whole document, gone to tools/language/set language/and unchecked the "do not check spelling ...... box" but it keeps coming back with a greyed ti... 2 06.02.2006 10:13:41 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:20:16 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:20:16 Word files have arrows, musical notes Hope this is correct forum; if not please direct me. I've done something that caused all my Word documents to fill in blank lines between pages with "musical notes"--at least they look like them. Also arrows, both straight and curved. Help, please. I assemble computers, but know little about software & using comp's.--this is MS Office Pro 2000. Thanks for any help in 'undecora... 3 03.02.2006 22:04:20 Form data output Not really a VBA issue but... I've got a really long form (~50 pages) template. I need to export the data into Access and I know the standard output method for saving as a CSV file. But, since Word exports the data as a single row of comma separated data, and the form has around 400 inputs, this blows the capacity of Access to import. What I'd like to do is insert some kind of break in ... 5 30.01.2006 18:16:35 DOC or DOT for emailed forms? I am sending to participants in a survey a simple MS Word document containing checkboxes and text form fields . (There's no VBA in it, but this newsgroup seems the most relevant.) I am asking recipients to fill out the form, save the file and send it back as an email attachment. All help from Microsoft and other sources recommends sending the file as a Word template (.dot) rather tha... 11 30.01.2006 01:50:10 Bookmark updating form issue. I created a form that pops up when a user opens this template. The template is a birth certificate. When the user opens the template my form pops up and they fill it out. Once they are done, they click on the submit button. The information they typed in the form then gets placed on the Birth Certificate were the book marks are located. My problem is my bookmarks have a grey space we... 2 27.01.2006 18:25:57 BUG?: Control transparency in Word 2000/XP I haven't been successful in making a textbox control transparent over an image inserted into a document. My image is set to "behind text" under the layout tab. My textboxes are inserted and set "in front of text". Also, under the textbox properties I have set BackStyle to transparent and SpecialEffect to flat. While in design mode, my textboxes appear transparent, showing the image b... 2 27.01.2006 18:11:25 Formatting All, This question is simple but someone can help me out i have a checkbox and a label, when user selects the checkbox, the caption of the checkbox (aaaaaaaaaaaaaaaaaaaaa) and label caption (abc...etc) should be printed in the document here label caption is spread accross 4-5 lines, how i want to see in the document is aaaaaaaaaaaaaaaaaaaaa (checkbox caption) abcccccccccccccccccc... 3 27.01.2006 14:57:02 Loading a forum without a focus I have a user form in my application (VBA under ArcGIS) that has 20 or so checkboxes. The code for my form determines if the various check boxes will be enabled or not when the form loads, based on a value I acquired before loading the form. It's all working fine, although when I load it the first enabled checkbox gets the focus and has that thin dashed line around it. I would rather not have... 4 27.01.2006 01:50:07 building a web site I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. Paul ... 1 27.01.2006 01:35:15 bookmark underline Would like to only underline the data in the bookmark not the entire length of the bookmark. currently we do: .bookmark(" ... ").range.font.underline=true then we add text to that bookmark with: Dim Bmrange As Range Set Bmrange = ActiveDocument.Bookmarks(strBkmk).Range Bmrange.Text = strRep ActiveDocument.Bookmarks.Add strBkmk, Bmrange where strBkmk is the name of the... 2 26.01.2006 19:14:26 Date validation and conversion On a word template I have two textboxes, DOFC and DOFA. The template will be used to transfer legal documents from paper archives to digital form. DOFC is the date of creation of the paper document. DOFA is its date of approval. Whats the prefered VBA code for: 1. The user can fill the textboxes with any admissible date, like dd/mm-yy. On error, (not a date), the user cant leave the tex... 8 24.01.2006 23:25:07 FAQ - Frequently Asked Questions - vba - please read before posting - unofficial January posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted weekly.- more or less Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non-... 6 23.01.2006 21:48:37 Fil in Forms A simple question, I have a fill in form, when data is entered into the field the next field with the label is shifted. How do I keep this from happening.... 3 23.01.2006 00:16:03 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 16:11:27 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 16:11:21 10 Pages: 1  2  3  4  5  6  7  8  9  10