Aaah, Microsoft. Post a solution, but do it in Japanese. God love ya.
I 'fished your page (
http://babelfish.altavista.com/) but the
translation is, um, difficult to understand. Imagine Yoda providing
MSFT tech support.
I have discovered that if you wait for a random amount of time and try
again, this error mysteriously goes away. (I do this by using On Error
Exit Sub in my WriteToWorkSheet sub.) You obviously miss whatever data
was happening during that period of time, but at least your code doesn't
die.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!