CopyFromRecordset does nothing
I have a routine written and executed from an access
modulate that creates an instance of Excel and copies a
recordset from access to Excel using the CopyFromRecordSet
method.
Currently, this code is being executed successfully on
about 50 separate machines running windows and excel 2000.
Just recently, one of the users has reported an error and
I've isloated it the "CopyFromRecordSet" routine.
I don't know why the code stops working (no error message
is given). I've searched the KnowledgeBase but have come
up with nothing.
TIA
Hafeez
|