Hi Simon,
The process of setting a reference to the library is actually early binding. You'll notice in the code that's in the file I gave you that we have:
How long it will take, I'm not actually sure. It will slow down a bit, for sure, but 2000 entries shouldn't take a noticeable amount of time to search through, I wouldn't think. 20,000 maybe.Dim conn as ADODB.Connection
Last edited by Aussiebear; 03-11-2025 at 06:07 PM.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Posting Permissions
Reply With Quote