Threads Replies Last Post 14 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14   Impossible to acces to the VBA project Hello, I have a bizzare (for me) problem. I develop some macro in a master and save it. I can open new document from the master and use the macros. But when I want to modify the macro, under VBA it's impossible to acces the master. In fact for each modif, I save the master under a different revision. I can modify all the versions except the two last one (with a big modification in... 2 2/27/2007 4:43:33 PM Combobox Columnheads I seem to remember that the Columnheads option for comboboxes and listboxes didn't work in early versions of Word. I am using W2003 and it still doesn't seem to work. Is it still on Mr Gates' 'to do' list, or am I missing something? JCNZ... 2 2/26/2007 2:48:37 AM Help with Userform loading listboxes from extenral MS Word Doc Hello All, I have a fairly complex userform where I have many textboxes, combo boxes, list boxes, etc. I have had some success in using examples found on the MVP web sites for populating a userform's listbox from a separate MS Word document table, but need some help.... I will include the code below that I hacked my way through. I am trying to populate several listboxes with the text f... 6 2/25/2007 5:16:46 PM Template with UserForm. Sorry to crosspost. I don't known wich group is the right for my question :-) I have an template (rekv.dot) containing an UserForm, to create a rekvisiton form. I would like to save the final document, on closing the document, in two different destinations. If the document is reopened, I don't want it to save unless it was altered. ThisDocument contains: Private Sub Document_N... 5 2/23/2007 3:31:56 PM COM Save Hello, I am using the Word COM objects via ColdFusion pages. Everything works nice and smooth except for one thing, very weird. I am opening a Word document, I read it and modify it OK, but when I try to save it, by "TheDocument.Save()" it throws me this exception: 'Save' is not a property even if Save is called as a method, not a property. And no other details on the error. IMPO... 3 2/23/2007 8:19:05 AM Transfert VBA macro to a document Hi, Do you know if it's possible (and eventually how) to transfert automatically macro (and some classes) from a model (.dot) to a document (.doc) and if possible not the possibility to read or modify it (the macro and class)? My aim is to develop the functionalities in a model and furnish my customer with our documents and the related macro to help them (how to make formated remarks... 15 2/21/2007 4:23:16 PM VBA code help for userform - ref fields not updating Hi, am new and self taught at using VBA in word, and just use the basics... I've created a document that uses a userform to fill in fields throughout the document. I've used bookmarks, and then for some repeated info through the doc have used the insert/ref method and referred back to the original bookmark name. But, when I run the macro it will only insert the variables on the actual bo... 3 2/21/2007 7:04:10 AM Combobox populate textbox alt. label Hello again. Thank you for the excellent help last time I posted here. Have a new small problem. Have searched the forum but cant seem to find what I need. Im very new to allt his so... What I would like is: depending on what value is selected form combobox1, textbox (or label is possible) is populated with 1 of 3 values. All help is welcome and appreciated... ... 4 2/20/2007 1:21:17 PM userform before addin's mailmerge I have a userform on the open_document event that "gets" which tables/rows to delete from the activedocument. Then, my addin (which is automatically installed via /L) generally runs a mailmerge, then other code. The trouble is, if I have the userform in my document, the addin doesn't run. Is there an explanation and fix for this? I don't really want to put the userform's code within the ... 1 2/17/2007 3:04:30 AM Printing the contents of a textbox Is there a way, please, to print the text contents of a large userform textbox? To explain: A template has a userform which gets data from a database (an Excel file). The userform has a combo box showing the title from one cell. The long and expanded contents of the adjoing cell then displays in the large userform textbox. No problems up to this stage. However, the client has now asked m... 3 2/16/2007 9:18:22 PM How to Make Word 97 UserForm Modeless Hi, my main goal that I am trying to accomplish is having 2 command buttons be visible at all times within a document. The simplest way (if my company was using a newer version of Office) would be to create a modeless UserForm. So needless to say, I am having an issue with this one. I have received input from another thread to try to use the following code, but to no avail: Quote ... 3 2/15/2007 4:27:48 PM Giving a label focus Hi, I'm in the process of making a macro I wrote accessible for sight impaired clients. They use a tool called 'JAWS' to read the screen. In order to read the text, the controls need to receive focus. I have plenty of labels that are not associated with other controls that provide users with critical information. Unfortunately Jaws cannot read them because they don't accept focus. ... 2 2/12/2007 8:14:10 PM Ink Annotations in Word Protected Form (PC Tablets) I have created several word documents that I protected as a form. The have drop downs and inserted fields to type in. I have an area that I need for the user to draw a picture of even sign. I can't seem to get the Ink Annotations button to be enabled when it's in the protected mode. ANyone know a way that I can use the PC Tablets function to get this done. Chris ... 2 2/12/2007 4:38:01 PM Populate Drop Down Box in Word I have a drop down in my word document. It's not a list, but a form drop down (HTMLSelect) using the Web Tools toolbar. I want to populate this drop down with values from an Excel sheet. How do I do this? I'm connecting to Excel, but unable to figure out how to populate the drop down. ... 1 2/10/2007 3:08:44 PM Word 2007/Visual Basic - Document Branding with Controls Hello, I'll try to be as specific and short in describing the issue I cannot resolve or find a work around for as it applies to my company and using word 2007. I have been assigned the task to find a way to develop one document that can, based on a button/list box control, set the appropriate images & text in the document. In order to do this, I need to find a way to select a par... 5 2/10/2007 4:51:22 AM Form DropDown Object Limitation How can I get around the limitation of total number of (25) items allowed in a DropDown object? I have a DropDown object in a table. I'm populating this DropDown in VBA code but when I hit over 25 values, I get the error: Run-tim error '4663': Cannot add more than 25 items in the dropdown list box.... 2 2/8/2007 6:28:52 PM Text typed in form use Soft Return insead of hard return? Hi, I'm using Word 2003 If a user types muliple lines in a UserForm textbox, when the data is inserted into the document it uses hard returns. Even if they pressed shift+Enter in the form. How can change or control this? txtReLine is the field name and it inserts it in the document at the bookmark. The bookmark location is setup with a hanging indent so if the text wraps to the next ... 3 2/8/2007 11:56:03 AM Footer Update Question I read the many posts on this newsgroup about updating headers and footers. My situation seems to be different than any of the others. My footer has some initial information in it such as some text on the left side and then the page x of y on the right side. I need to replace the initial text that I have in the footer with the text I capture from a Userform. I basically understand how to a... 3 2/7/2007 11:32:35 PM Error Handling DAO Is Null BoundColumn? Hi, I am currently working in a Word 2003 VBA User Form. I have been using the DAO excel table as my list of employees and data that pulls into the combo box. (got away from Word Tables) I know how to trap the error of Null (error 94 Invalid use of Null) by using a If statement for every boundcolumn...but I was hoping I could accomplish two things with out typing as much code. I placed ... 3 2/7/2007 7:35:40 PM Help with tables using VBA (Code messing up) I am using Office 2007 and I have created a form that pulls information from an Access database. My problem is the code works fine for the first two records, but it gets jumbled up after that. Below is a copy of my code. Public blnCancelled As Boolean Public rstart As Object Public rend As Object Private Sub btnCancel_Click() Opinion.blnCancelled = True Unload Me End Sub Private Su... 2 2/7/2007 6:05:54 PM "user-defined type not defined" on mouse event handlers Hi all, Using Word 2000 vba. I am getting the following 'compile-time' error being flagged on a mouse event handler: "user-defined type not defined" The mouse event handler is declared in the form's code. The handler is for a 10tec iGrid control: Private Sub iGrid1_MouseDown(index As Long, ByVal Button As fmButton, _ ByVal Shift As fmShiftState,... 9 2/6/2007 9:18:00 AM Change focus from userform to Document I have a userform. I set the Show Modal to False so the user can select and edit the document. After pressing a button on the userform a routine will run. I would like the focus to shift back to the document automatically without requiring the user to click on the document after that routine is run. Is there a way to automatically set focus away from the userform and back to the d... 4 2/4/2007 6:56:24 AM Check boxes and userforms I have a form that starts with a questionnaire and uses the information in the questionnaire part to create a letter. For example The questionnaire asks the name of the customer in a text form field, the age of the customer in a text form field and I was trying to use check boxes to add other items in the list but noted that the check boxes cannot be used in cross references. For example... 2 2/3/2007 1:38:21 AM Repeating a table on a page Hello everyone. I am using Microsoft Office 2007 and I have created a form that pulls information from an Access database and puts it in a table. I want to have 3 tables per page that are populated with information from the database. My dilemma is I can populate one table, but for some reason the table will not repeat for the next recordset. I get runtime error '4605': this method or pr... 4 2/2/2007 9:13:44 PM User forms and CheckBoxes I have a form that starts with a questionnaire and uses the information in the questionnaire part to create a letter. For example The questionnaire asks the name of the customer in a text form field, the age of the customer in a text form field and I was trying to use check boxes to add other items in the list but noted that the check boxes cannot be used in cross references. For example... 4 2/1/2007 7:37:11 AM 14 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14