View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kaustav choudhury kaustav choudhury is offline
external usenet poster
 
Posts: 2
Default Open a password protected excel workbook from second workbook to fetch data using dynamic connection

Hi,

I have two excel applications. I wish to fetch data from excel application A
to excel application B using recordsets. My excel application A is password
protected. How do I fetch the data without actually opening application A
(using recordsets in excel application B).

Any help is most welcome.

Thanks,

Kaustav