Hi all
I update my ADO page today.
http://www.rondebruin.nl/ado.htm
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 [...]
Read the complete post at http://www.dailydoseofexcel.com/archives/2007/12/23/page-update-copy-a-range-from-closed-workbooks-ado/
Posted
Dec 23 2007, 11:12 AM
by
Daily Dose of Excel