Load a ListBox from a Named Range in Excel using DAO

[abousetta]

Hi,

I'm feeling a little dumb right now and need some help (again). I found a webpage explaining how to 'Load a ListBox from a Named Range in Excel using DAO' and sounds like a neat trick, but can't get an example to work. If anyone can put an example together to demonstrate how this works then I would be grateful.

Thanks.

abousetta

[domfootwear]

Hi,

I'm feeling a little dumb right now and need some help (again). I found a webpage explaining how to 'Load a ListBox from a Named Range in Excel using DAO' and sounds like a neat trick, but can't get an example to work. If anyone can put an example together to demonstrate how this works then I would be grateful.

Thanks.

abousetta

You should up excel database in here, If i can I will help you to do this by ADO.

[Kyle123]

The problem with using DAO as opposed to ADO in that example is that (as far as I can see) you'd need Access installed on the machine.

Here's an example using ADO - you'll obviously need to change the path of "Source.xlsx"

It's worth noting there are some weird things that happen with datatypes and stuff when using Excel as a data source - http://support.microsoft.com/kb/257819

The driver also would need changing if you were to use on .xls files to a jet Provider

[JosephP]

could you be more specific about the problem you are facing with it? (note a dynamic named range in a closed workbook won't work with either dao or ado)

[abousetta]

Thanks Kyle and everyone for your support. Kyle, your example works great and I was able to use it along with the reference you provided to resolve the issues with the original code. I noticed that I was using an apostrophe instead of a slanted single quote which was throwing an error.

I will read the article in more depth and try to learn a new technique.

Thanks again.

Best wishes,

abousetta

[Kyle123]

Thanks for the feedback, glad you got it sorted