Thread: [Solved] load list box from range in excel
View Single Post
 
Old 05-26-2011, 04:05 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2007
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
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
Hi Joe,

In what format is the file you're retrieving from - Excel 2007-10 or Excel 97-2003?
If it's Excel 2007-10 , is Access 2007 is installed on the system?
If it's Excel 2007-10 and Access 2007 is not installed on the system have you downloaded & installed the object library?
Do you have a reference set to:
Microsoft DAO 3.51 (or 3.6) Object Library?
or is to:
Microsoft Office 12.0 Access database engine Object Library?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote