I update my ADO page today.
The code is also working in Excel 2007 now (Excel 2000-2007).
I use Late binding now to avoid private mails like “It is not working”
When you use the Subfolder option in Example 7 it will loop through all files in all levels below the rootfolder.
If you have problems or suggestions let me know.
I wish all readers of this blog a Merry Christmas and a Super 2008.
Ron de Bruin