How to import list from Excel into drop-down list into word

macropod · #21 11-23-2017, 01:03 PM

Quote:

Originally Posted by gmaxey

I hope you won't feel that I am trying to upstage you in any way, but I thought that I would provide and alternate method that doesn't require the reference to the Excel object library or physically opening the Excel file (with the Excel app). In this method the data is gathered using ADODB in an array then the array is used in various ways to file the CC dropdown list:

Hi Greg,

Your input is always welcome. I've never studied ADODB in any detail, though I am aware of its advantages (higher performance and no need for an Excel reference - though the latter could be avoided though late binding [=yet lower performance]). I probably should study it in more detail; it's yet another tool for users to work with.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamically changing drop-down list based on selection? (Word Form)	laurarem	Word	1	02-21-2013 10:17 PM
How to import a list of names into PowerPoint from Excel?	CarpetRemnant	PowerPoint	4	12-07-2012 11:08 AM
Drop down list, Can it be done???	garethreid	Outlook	0	08-09-2012 06:08 AM
drop down list from external data source Excel 2007?	Intruder	Excel	1	08-03-2012 05:41 AM
Long List for drop down box	DLo99	Word	0	02-28-2010 08:07 AM