View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
deepakmehta[_10_] deepakmehta[_10_] is offline
external usenet poster
 
Posts: 1
Default Problem copying data with ADO


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