Hi Paul,
I made a special example for you - I left only 2 files for consolidation, each file contains only one sheet. Enclosed you will find 3 files in version 2003, and 3 files in version 2007. You can run macro inside the main file : the version 2003 works, 2007 not.
I will appreciate any idea, any hint...
Jiri
P.S. my code is not optimized, but I will use your corrections with pleasue when the main topic works...
|