CopyFromRecordset rs

[lisa1980]

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

[Hack]

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?

[RobDog888]

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

[lisa1980]

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

[RobDog888]

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 ???