View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amit Patel[_2_] Amit Patel[_2_] is offline
external usenet poster
 
Posts: 1
Default Runtime 440:Automation Error

I create one macro which access oracle database and fill up recordset using
OO4O server request.

when i print recordset into worksheet it gives AUTOMATION error or OVERFLOW
error.if recordset contain 15000 record it print only 14080 record and not
print all record .

Now i get same error when i create Dynaset object.

Set OraDynaSet = objdatabase.DBCreateDynaset(strSQL, 0&)

This statement gives Automation error from last days.

Please help