Adjust data range without opening multiple excel files
Joel,
Thanks for your quick reply.
It seems that it leave me no choice I have to use ADO
method............
It still very slow after I use your codes to test on one file and then
on whole directory
I'll work around on ADO method and see the progress
Thanks anyway
Regards
Len
|