Userform/FormFields Greetings, I have a userform with a lisbox on it that allows multiple selections. I would like to add FormFields for each of the selected items and add the selected items text as the form field result property following a button click event. Is this possible and any Ideas how to accomplish this? TIA. ... 26 Feb 2010 09:40
Subscript problem I'm just getting back into Word Macros after a long absence in which I feel like I've forgotten almost everything. My macros worked perfectly in Word 2002 but I've upgraded to Word 2007 and now I'm having a problem or two. The one that concerns me most right now is a subscript error. This is the macro that ... 25 Feb 2010 10:18
Removing External Data I have a spreadsheet that retrieves external data from a SQL Server database. The user clicks a button that executes a macro. The table returned has a named range. I want to provide a button to REMOVE the data. Can someone point me to an example of how to remove the data (ideally using the named range, bu... 25 Feb 2010 06:57
Error: Programmatic Access is not trusted I am revisiting an old VBScript that I wrote several years ago. It basically opens an existing Word document, then exports the macros associated with that document. This is the script: =========================== ' Get arguments into variables If WScript.Arguments.Count < 1 Then MsgBox "Too few arguments; e... 25 Feb 2010 09:10
user form that retrieves data from Microsoft Access query I created a word document that displays a userform when the template is opened, when you click on the ok button on the userform the template should display data that comes from a microsoft access query. The thing is that this works perfectly for me with my non-administrators account. The problem is that wheneve... 1 Mar 2010 06:59
Add a Listbox to the Quick Access Toolbar from a macro In Word 2007 I need to add a listbox to the Quick Launch Toolbar when a specific Word document gets focus and remove the listbox when that document looses focus. Can anyone give me a hand with this? The part I know is the event for getting and loosing focus but I can't figure out how to change the Quick Launc... 24 Feb 2010 14:19
set up a macro that prints the document when opened How do we set up a macro in Word(2003) such that when the document is opened, a print request is sent automatically. ... 24 Feb 2010 21:07
returning a value from a date/time picker Hi all, I would like to know how to retrieve a value from a date/time picker that I have inserted as an OLE Object into my document via this line: ActiveDocument.Tables(iTableCount).Rows(1).Cells(2).Range. _ InlineShapes.AddOLEControl(ClassType:="MSComCtl2.DTPicker.2") I cannot seem to fathom it out so any ... 26 Feb 2010 07:27
Drag & drop text from other application Hi, I`m writing an app that need to drag&drop a plain text (it`s actually the html text but converted to plain) into MS Word (2007 for now). Also, user should be able to drop text to a html editor. So on drag&drop I`ve registered two d&d formats (html and plain text) in the d&d clipboard. I can drop the tex... 24 Feb 2010 12:02
Monitor Ribbon Events With Word2003 I could create an event monitor to detect when a user used a command bar button. For example, the following is used to detect use of the "Print..." command: Private WithEvents ctrlEvent As CommandBarButton Sub AutoExec() Set ctrlEvent = Application.CommandBars("Menu Bar").Controls("File").Co... 24 Feb 2010 05:21 |