Sounds like you will need to be a bit more "creative" to trace the cause..
Do these help ?

http://www.mrexcel.com/archive2/20000/22741.htm
http://support.microsoft.com/default...;en-us;Q319832

NickHK

"russian_hamlet" wrote in message
ps.com...

I had to rem out most of it, but what was left threw me an error on
file2 (original 1234 order) ...
Automation error -2147417848 (80010108)
The object has disconnected from its clients