CopyFromRecordset rs

Hello all I am trying to use the code CopyFromRecordset rs
but i found that only i can run this while it's sitting on a network drive. I need to loop and return each record what can i use instead of CopyFromRecordset rs? here is what I have now...Thanks in advance

For i = 1 To rs.Fields.Count

xlWs.Cells(currentRow, i).Value = rs.Fields(i - 1).Name


Next i

currentRow = currentRow + 1

'append recordset data to worksheet

xlWs.Cells(currentRow, 1).CopyFromRecordset rs

Quote:

---

Originally Posted by lisa1980

but i found that only i can run this while it's sitting on a network drive.

---

This is a first...what happens when you are not on a network drive?

How are you populating your rs? when it doesnt work "locally" what error(s) do you receive?

Maybe taking a look at my CopyFromRecordset FAQ example will shed some light on it?
post #2 is VB6 example:
http://www.vbforums.com/showthread.php?t=402060

Thank you for responding... I thought by using the CopyFromRecordset would work fine and make the application run a bit faster(lots of data) but because my
Colleague does not work in the same state i do that's is when i notice the issue. I looked at the code example and they all use the CopyFromRecordset.
Any thoughts on this

Both of you being far apart, how are you two connecting to the data? Logging on to a terminal server session or web page or ???