Dear Garry,
The problem here is that i am only one using ADO in my excel file A to
recieve data form excel file B.
Note : If excel file B is open by any user (other than myself), when i
run the macro on A, file B opens up in readonly mode.... (to copy data
using ADO).
I do not want this file to open. I just want the Data.
Regards,
Deepak
--
deepakmehta
------------------------------------------------------------------------
deepakmehta's Profile:
http://www.excelforum.com/member.php...o&userid=29609
View this thread:
http://www.excelforum.com/showthread...hreadid=539665