Thread: [Solved] How to import list from Excel into drop-down list into word
View Single Post
 
Old 11-23-2017, 01:03 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by gmaxey View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]