View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_639_] joel[_639_] is offline
external usenet poster
 
Posts: 1
Default Cannot use recordset twice with copy From recordset


try adding

RS05.MoveFirst


I'm not sure why the code ever worked. Not sure if you are opening and
closing the recordset. A recordset is similar to a file which moves the
pointer as it move the data so when you done reading everything the
point is at the end of the file and you have to reset the pointer to the
beginning of the file before you can read the data a 2nd time.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176179

Microsoft Office Help