To give you an example of application automation read thru the following insight article: Application Automation now this does deal with Outlook and Excel however, word is essentially the same basic principles However, it really depends on your skill set as to the best method to use to get your information out to word. but I'm a little bias here given the amount of help his site has given me over the years.įrom here, we're going to need to either store the query that you will create using the control's values- and then you can open the word document by hand (IMHO the easiest for newer VBA programmers or for those just occational type merges), store the query and then call word to open with the mail merge document that has already been linked to a query with that name, or pass the query via application automation.
Browne most likely has the easiest to follow methods. Use a multi-select list box to filter a report - Allen Browne One Method to get the selected information So in order to do anything with the control, you'll need to understand how a multiselect works and the common methods of retrieving the information out of the control: nor to the best of my knowledge can it be used that way directly. punnyĪs seen here: (don't bother to follow the links in this thread, they are all long dead thus, the code they reference is no longer available) you basically need to pass a record set to the word document and that's not what is happening with your document. Ah, as so often happens the multi-select-listbox bytes again.
0 kommentar(er)
